方法函数
: #region 添加新站点存储过程版本
/// <summary>
/// 新增站点
/// </summary>
/// <param name="userwebhost">站点表实体</param>
/// <returns></returns>
public bool AddNew(UserWebHost userwebhost, out int ReturnValue, out string ReturnString)
{
Database DBUserWebHost;
DbCommand ComUserWebHost = null;
ReturnValue = -1;
ReturnString = string.Empty;
DBUserWebHost = DatabaseFactory.CreateDatabase("WapAD_Base");
using (IDbConnection IDBConn = DBUserWebHost.CreateConnection())
{
IDBConn.Open();
IDbTransaction IDBTrans = IDBConn.BeginTransaction();
try
{
ComUserWebHost = DBUserWebHost.GetStoredProcCommand("proc_AddUserWebHost");
DBUserWebHost.AddInParameter(ComUserWebHost, "@UserId", DbType.Int32, userwebhost.UserId);
DBUserWebHost.AddInParameter(ComUserWebHost, "@ChannelType", DbType.Int32, userwebhost.ChannelType);
DBUserWebHost.AddInParameter(ComUserWebHost, "@ChannelId", DbType.Int32, userwebhost.ChannelId);
DBUserWebHost.AddInParameter(ComUserWebHost, "@WebName", DbType.String, userwebhost.WebName);
DBUserWebHost.AddInParameter(ComUserWebHost, "@WebUrl", DbType.String, userwebhost.WebUrl);
DBUserWebHost.AddInParameter(ComUserWebHost, "@Description", DbType.AnsiString, userwebhost.Description);
DBUserWebHost.AddInParameter(ComUserWebHost, "@ServerIP", DbType.Int64, userwebhost.ServerIP);
DBUserWebHost.AddInParameter(ComUserWebHost, "@SynchUrl", DbType.String, userwebhost.SynchUrl);
DBUserWebHost.AddInParameter(ComUserWebHost, "@State", DbType.Int32, userwebhost.State);
DBUserWebHost.AddInParameter(ComUserWebHost, "@Keap", DbType.Int32, userwebhost.Keap);
DBUserWebHost.AddInParameter(ComUserWebHost, "@CheckUserID", DbType.Int32, userwebhost.CheckUserID);
DBUserWebHost.AddOutParameter(ComUserWebHost, "@ReturnValue", DbType.Int32, 4);
DBUserWebHost.AddOutParameter(ComUserWebHost, "@ReturnString", DbType.String, 500);
DBUserWebHost.ExecuteNonQuery(ComUserWebHost);
ReturnValue = (int)DBUserWebHost.GetParameterValue(ComUserWebHost, "@ReturnValue");
ReturnString = (string)DBUserWebHost.GetParameterValue(ComUserWebHost, "@ReturnString");
IDBTrans.Commit();
}
catch (Exception ex)
{
IDBTrans.Rollback();
Log.SystemLog(ex.Message);
return false;
}
finally
{
if (IDBConn.State != ConnectionState.Closed)
{
IDBConn.Close();
}
}
}
return true;
}
#endregion
调用代码:
int ReturnValue = 0;//输出参数
string ReturnString = string.Empty;//输出参数
try
{
UserWebHost MyWebHost = new UserWebHost();
DAABUserWebHost _UserWebHost = new DAABUserWebHost();
MyWebHost.UserId = Convert.ToInt32(Session["EUserID"].ToString());
MyWebHost.ChannelId = Convert.ToInt32(Request.Form["ddlChannel"].ToString());
MyWebHost.ChannelType = Convert.ToInt32(ddlChannelTypeID.SelectedValue);
MyWebHost.WebName = txtWebName.Text;
MyWebHost.WebUrl = txtWebUrl.Text;
MyWebHost.Description = "";
MyWebHost.ServerIP = IpAddress(txtServerIp.Text);
MyWebHost.SynchUrl = txtSynUrl.Text;
MyWebHost.BackCount = 0;
MyWebHost.CheckUserID = 0;
MyWebHost.State = 0;
MyWebHost.Keap = 0;
MyWebHost.CheckDate = DateTime.Now;
MyWebHost.CreateDate = DateTime.Now;
_UserWebHost.AddNew(MyWebHost, out ReturnValue, out ReturnString);
ClientScript.RegisterStartupScript(typeof(string), "eror", "<script language='javascript'>alert('添加成功')</script>");
}
catch
{
ClientScript.RegisterStartupScript(typeof(string), "eror", "<script language='javascript'>alert('" + ReturnString + "')</script>");
}
: #region 添加新站点存储过程版本
/// <summary>
/// 新增站点
/// </summary>
/// <param name="userwebhost">站点表实体</param>
/// <returns></returns>
public bool AddNew(UserWebHost userwebhost, out int ReturnValue, out string ReturnString)
{
Database DBUserWebHost;
DbCommand ComUserWebHost = null;
ReturnValue = -1;
ReturnString = string.Empty;
DBUserWebHost = DatabaseFactory.CreateDatabase("WapAD_Base");
using (IDbConnection IDBConn = DBUserWebHost.CreateConnection())
{
IDBConn.Open();
IDbTransaction IDBTrans = IDBConn.BeginTransaction();
try
{
ComUserWebHost = DBUserWebHost.GetStoredProcCommand("proc_AddUserWebHost");
DBUserWebHost.AddInParameter(ComUserWebHost, "@UserId", DbType.Int32, userwebhost.UserId);
DBUserWebHost.AddInParameter(ComUserWebHost, "@ChannelType", DbType.Int32, userwebhost.ChannelType);
DBUserWebHost.AddInParameter(ComUserWebHost, "@ChannelId", DbType.Int32, userwebhost.ChannelId);
DBUserWebHost.AddInParameter(ComUserWebHost, "@WebName", DbType.String, userwebhost.WebName);
DBUserWebHost.AddInParameter(ComUserWebHost, "@WebUrl", DbType.String, userwebhost.WebUrl);
DBUserWebHost.AddInParameter(ComUserWebHost, "@Description", DbType.AnsiString, userwebhost.Description);
DBUserWebHost.AddInParameter(ComUserWebHost, "@ServerIP", DbType.Int64, userwebhost.ServerIP);
DBUserWebHost.AddInParameter(ComUserWebHost, "@SynchUrl", DbType.String, userwebhost.SynchUrl);
DBUserWebHost.AddInParameter(ComUserWebHost, "@State", DbType.Int32, userwebhost.State);
DBUserWebHost.AddInParameter(ComUserWebHost, "@Keap", DbType.Int32, userwebhost.Keap);
DBUserWebHost.AddInParameter(ComUserWebHost, "@CheckUserID", DbType.Int32, userwebhost.CheckUserID);
DBUserWebHost.AddOutParameter(ComUserWebHost, "@ReturnValue", DbType.Int32, 4);
DBUserWebHost.AddOutParameter(ComUserWebHost, "@ReturnString", DbType.String, 500);
DBUserWebHost.ExecuteNonQuery(ComUserWebHost);
ReturnValue = (int)DBUserWebHost.GetParameterValue(ComUserWebHost, "@ReturnValue");
ReturnString = (string)DBUserWebHost.GetParameterValue(ComUserWebHost, "@ReturnString");
IDBTrans.Commit();
}
catch (Exception ex)
{
IDBTrans.Rollback();
Log.SystemLog(ex.Message);
return false;
}
finally
{
if (IDBConn.State != ConnectionState.Closed)
{
IDBConn.Close();
}
}
}
return true;
}
#endregion
调用代码:
int ReturnValue = 0;//输出参数
string ReturnString = string.Empty;//输出参数
try
{
UserWebHost MyWebHost = new UserWebHost();
DAABUserWebHost _UserWebHost = new DAABUserWebHost();
MyWebHost.UserId = Convert.ToInt32(Session["EUserID"].ToString());
MyWebHost.ChannelId = Convert.ToInt32(Request.Form["ddlChannel"].ToString());
MyWebHost.ChannelType = Convert.ToInt32(ddlChannelTypeID.SelectedValue);
MyWebHost.WebName = txtWebName.Text;
MyWebHost.WebUrl = txtWebUrl.Text;
MyWebHost.Description = "";
MyWebHost.ServerIP = IpAddress(txtServerIp.Text);
MyWebHost.SynchUrl = txtSynUrl.Text;
MyWebHost.BackCount = 0;
MyWebHost.CheckUserID = 0;
MyWebHost.State = 0;
MyWebHost.Keap = 0;
MyWebHost.CheckDate = DateTime.Now;
MyWebHost.CreateDate = DateTime.Now;
_UserWebHost.AddNew(MyWebHost, out ReturnValue, out ReturnString);
ClientScript.RegisterStartupScript(typeof(string), "eror", "<script language='javascript'>alert('添加成功')</script>");
}
catch
{
ClientScript.RegisterStartupScript(typeof(string), "eror", "<script language='javascript'>alert('" + ReturnString + "')</script>");
}