public static bool Update(Model.WebBase model)
{
return(DAL.WebBase.Update(model));
}
public static bool Update(Model.WebBase model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update WebBase set ");
strSql.Append("SMSState=@SMSState,");
strSql.Append("SMSName=@SMSName,");
strSql.Append("SMSPassword=@SMSPassword,");
strSql.Append("TelVerify=@TelVerify,");
strSql.Append("SMSTitle=@SMSTitle,");
strSql.Append("MonitorTel=@MonitorTel,");
strSql.Append("SMSMinCount=@SMSMinCount,");
strSql.Append("EmailSmtp=@EmailSmtp,");
strSql.Append("EmailName=@EmailName,");
strSql.Append("EmailPassword=@EmailPassword,");
strSql.Append("EmailTitle=@EmailTitle,");
strSql.Append("EmailVerify=@EmailVerify,");
strSql.Append("EmailState=@EmailState,");
strSql.Append("DaySMSCount=@DaySMSCount,");
strSql.Append("RandPassword=@RandPassword,");
strSql.Append("AutoID=@AutoID,");
strSql.Append("MonitorEmail=@MonitorEmail");
SqlParameter[] parameters =
{
new SqlParameter("@SMSState", SqlDbType.Bit, 1),
new SqlParameter("@SMSName", SqlDbType.VarChar, 50),
new SqlParameter("@SMSPassword", SqlDbType.VarChar, 50),
new SqlParameter("@TelVerify", SqlDbType.Bit, 1),
new SqlParameter("@SMSTitle", SqlDbType.VarChar, 50),
new SqlParameter("@MonitorTel", SqlDbType.VarChar, 50),
new SqlParameter("@SMSMinCount", SqlDbType.Int, 4),
new SqlParameter("@EmailSmtp", SqlDbType.VarChar, 50),
new SqlParameter("@EmailName", SqlDbType.VarChar, 50),
new SqlParameter("@EmailPassword", SqlDbType.VarChar, 50),
new SqlParameter("@EmailTitle", SqlDbType.VarChar, 50),
new SqlParameter("@EmailVerify", SqlDbType.Bit, 1),
new SqlParameter("@EmailState", SqlDbType.Bit, 1),
new SqlParameter("@DaySMSCount", SqlDbType.Int, 4),
new SqlParameter("@RandPassword", SqlDbType.Bit, 1),
new SqlParameter("@AutoID", SqlDbType.Bit, 1),
new SqlParameter("@MonitorEmail", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.SMSState;
parameters[1].Value = model.SMSName;
parameters[2].Value = model.SMSPassword;
parameters[3].Value = model.TelVerify;
parameters[4].Value = model.SMSTitle;
parameters[5].Value = model.MonitorTel;
parameters[6].Value = model.SMSMinCount;
parameters[7].Value = model.EmailSmtp;
parameters[8].Value = model.EmailName;
parameters[9].Value = model.EmailPassword;
parameters[10].Value = model.EmailTitle;
parameters[11].Value = model.EmailVerify;
parameters[12].Value = model.EmailState;
parameters[13].Value = model.DaySMSCount;
parameters[14].Value = model.RandPassword;
parameters[15].Value = model.AutoID;
parameters[16].Value = model.MonitorEmail;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected override void SetValue()
{
WebBaseModel = BLL.WebBase.Model;
}
