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; }