private void ShowInfo(int OperatorID) { WebDemo.BLL.WebDemo.Operators bll = new WebDemo.BLL.WebDemo.Operators(); WebDemo.Model.WebDemo.Operators model = bll.GetModel(OperatorID); this.lblOperatorID.Text = model.OperatorID.ToString(); this.txtOperatorCode.Text = model.OperatorCode; this.txtOperatorName.Text = model.OperatorName; this.txtRoleID.Text = model.RoleID.ToString(); this.txtOperPassword.Text = model.OperPassword; this.txtSiteID.Text = model.SiteID.ToString(); this.txtFlag.Text = model.Flag.ToString(); this.txtCreateDate.Text = model.CreateDate.ToString(); this.txtLastLoginDate.Text = model.LastLoginDate.ToString(); this.txtPageRowCounts.Text = model.PageRowCounts.ToString(); this.txtOperLevel.Text = model.OperLevel; this.txtTemplateID.Text = model.TemplateID.ToString(); this.txtPaymentTemplateID.Text = model.PaymentTemplateID.ToString(); this.txtICTemplateID.Text = model.ICTemplateID.ToString(); this.txtPhone.Text = model.Phone; this.txtSelfSetting.Text = model.SelfSetting; this.txtAutoRead.Text = model.AutoRead.ToString(); this.txtPhoneSerialNumber.Text = model.PhoneSerialNumber; this.txtIsBinding.Text = model.IsBinding.ToString(); this.txtRoleLevel.Text = model.RoleLevel.ToString(); this.txtExpiryDate.Text = model.ExpiryDate.ToString(); this.txtSkin.Text = model.Skin; }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.Operators GetModel(int OperatorID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 OperatorID,OperatorCode,OperatorName,RoleID,OperPassword,SiteID,Flag,CreateDate,LastLoginDate,PageRowCounts,OperLevel,TemplateID,PaymentTemplateID,ICTemplateID,Phone,SelfSetting,AutoRead,PhoneSerialNumber,IsBinding,RoleLevel,ExpiryDate,Skin from Operators "); strSql.Append(" where OperatorID=@OperatorID "); SqlParameter[] parameters = { new SqlParameter("@OperatorID", SqlDbType.Int, 4) }; parameters[0].Value = OperatorID; WebDemo.Model.WebDemo.Operators model = new WebDemo.Model.WebDemo.Operators(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(WebDemo.Model.WebDemo.Operators model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Operators("); strSql.Append("OperatorID,OperatorCode,OperatorName,RoleID,OperPassword,SiteID,Flag,CreateDate,LastLoginDate,PageRowCounts,OperLevel,TemplateID,PaymentTemplateID,ICTemplateID,Phone,SelfSetting,AutoRead,PhoneSerialNumber,IsBinding,RoleLevel,ExpiryDate,Skin)"); strSql.Append(" values ("); strSql.Append("@OperatorID,@OperatorCode,@OperatorName,@RoleID,@OperPassword,@SiteID,@Flag,@CreateDate,@LastLoginDate,@PageRowCounts,@OperLevel,@TemplateID,@PaymentTemplateID,@ICTemplateID,@Phone,@SelfSetting,@AutoRead,@PhoneSerialNumber,@IsBinding,@RoleLevel,@ExpiryDate,@Skin)"); SqlParameter[] parameters = { new SqlParameter("@OperatorID", SqlDbType.Int, 4), new SqlParameter("@OperatorCode", SqlDbType.VarChar, 50), new SqlParameter("@OperatorName", SqlDbType.VarChar, 50), new SqlParameter("@RoleID", SqlDbType.Int, 4), new SqlParameter("@OperPassword", SqlDbType.VarChar, 50), new SqlParameter("@SiteID", SqlDbType.Int, 4), new SqlParameter("@Flag", SqlDbType.Int, 4), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@LastLoginDate", SqlDbType.DateTime), new SqlParameter("@PageRowCounts", SqlDbType.Int, 4), new SqlParameter("@OperLevel", SqlDbType.VarChar, 50), new SqlParameter("@TemplateID", SqlDbType.Int, 4), new SqlParameter("@PaymentTemplateID", SqlDbType.Int, 4), new SqlParameter("@ICTemplateID", SqlDbType.Int, 4), new SqlParameter("@Phone", SqlDbType.VarChar, 50), new SqlParameter("@SelfSetting", SqlDbType.VarChar, 500), new SqlParameter("@AutoRead", SqlDbType.Int, 4), new SqlParameter("@PhoneSerialNumber", SqlDbType.VarChar, 50), new SqlParameter("@IsBinding", SqlDbType.Int, 4), new SqlParameter("@RoleLevel", SqlDbType.Int, 4), new SqlParameter("@ExpiryDate", SqlDbType.DateTime), new SqlParameter("@Skin", SqlDbType.VarChar, 50) }; parameters[0].Value = model.OperatorID; parameters[1].Value = model.OperatorCode; parameters[2].Value = model.OperatorName; parameters[3].Value = model.RoleID; parameters[4].Value = model.OperPassword; parameters[5].Value = model.SiteID; parameters[6].Value = model.Flag; parameters[7].Value = model.CreateDate; parameters[8].Value = model.LastLoginDate; parameters[9].Value = model.PageRowCounts; parameters[10].Value = model.OperLevel; parameters[11].Value = model.TemplateID; parameters[12].Value = model.PaymentTemplateID; parameters[13].Value = model.ICTemplateID; parameters[14].Value = model.Phone; parameters[15].Value = model.SelfSetting; parameters[16].Value = model.AutoRead; parameters[17].Value = model.PhoneSerialNumber; parameters[18].Value = model.IsBinding; parameters[19].Value = model.RoleLevel; parameters[20].Value = model.ExpiryDate; parameters[21].Value = model.Skin; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.Operators DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.Operators model = new WebDemo.Model.WebDemo.Operators(); if (row != null) { if (row["OperatorID"] != null && row["OperatorID"].ToString() != "") { model.OperatorID = int.Parse(row["OperatorID"].ToString()); } if (row["OperatorCode"] != null) { model.OperatorCode = row["OperatorCode"].ToString(); } if (row["OperatorName"] != null) { model.OperatorName = row["OperatorName"].ToString(); } if (row["RoleID"] != null && row["RoleID"].ToString() != "") { model.RoleID = int.Parse(row["RoleID"].ToString()); } if (row["OperPassword"] != null) { model.OperPassword = row["OperPassword"].ToString(); } if (row["SiteID"] != null && row["SiteID"].ToString() != "") { model.SiteID = int.Parse(row["SiteID"].ToString()); } if (row["Flag"] != null && row["Flag"].ToString() != "") { model.Flag = int.Parse(row["Flag"].ToString()); } if (row["CreateDate"] != null && row["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } if (row["LastLoginDate"] != null && row["LastLoginDate"].ToString() != "") { model.LastLoginDate = DateTime.Parse(row["LastLoginDate"].ToString()); } if (row["PageRowCounts"] != null && row["PageRowCounts"].ToString() != "") { model.PageRowCounts = int.Parse(row["PageRowCounts"].ToString()); } if (row["OperLevel"] != null) { model.OperLevel = row["OperLevel"].ToString(); } if (row["TemplateID"] != null && row["TemplateID"].ToString() != "") { model.TemplateID = int.Parse(row["TemplateID"].ToString()); } if (row["PaymentTemplateID"] != null && row["PaymentTemplateID"].ToString() != "") { model.PaymentTemplateID = int.Parse(row["PaymentTemplateID"].ToString()); } if (row["ICTemplateID"] != null && row["ICTemplateID"].ToString() != "") { model.ICTemplateID = int.Parse(row["ICTemplateID"].ToString()); } if (row["Phone"] != null) { model.Phone = row["Phone"].ToString(); } if (row["SelfSetting"] != null) { model.SelfSetting = row["SelfSetting"].ToString(); } if (row["AutoRead"] != null && row["AutoRead"].ToString() != "") { model.AutoRead = int.Parse(row["AutoRead"].ToString()); } if (row["PhoneSerialNumber"] != null) { model.PhoneSerialNumber = row["PhoneSerialNumber"].ToString(); } if (row["IsBinding"] != null && row["IsBinding"].ToString() != "") { model.IsBinding = int.Parse(row["IsBinding"].ToString()); } if (row["RoleLevel"] != null && row["RoleLevel"].ToString() != "") { model.RoleLevel = int.Parse(row["RoleLevel"].ToString()); } if (row["ExpiryDate"] != null && row["ExpiryDate"].ToString() != "") { model.ExpiryDate = DateTime.Parse(row["ExpiryDate"].ToString()); } if (row["Skin"] != null) { model.Skin = row["Skin"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.Operators model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Operators set "); strSql.Append("OperatorCode=@OperatorCode,"); strSql.Append("OperatorName=@OperatorName,"); strSql.Append("RoleID=@RoleID,"); strSql.Append("OperPassword=@OperPassword,"); strSql.Append("SiteID=@SiteID,"); strSql.Append("Flag=@Flag,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("LastLoginDate=@LastLoginDate,"); strSql.Append("PageRowCounts=@PageRowCounts,"); strSql.Append("OperLevel=@OperLevel,"); strSql.Append("TemplateID=@TemplateID,"); strSql.Append("PaymentTemplateID=@PaymentTemplateID,"); strSql.Append("ICTemplateID=@ICTemplateID,"); strSql.Append("Phone=@Phone,"); strSql.Append("SelfSetting=@SelfSetting,"); strSql.Append("AutoRead=@AutoRead,"); strSql.Append("PhoneSerialNumber=@PhoneSerialNumber,"); strSql.Append("IsBinding=@IsBinding,"); strSql.Append("RoleLevel=@RoleLevel,"); strSql.Append("ExpiryDate=@ExpiryDate,"); strSql.Append("Skin=@Skin"); strSql.Append(" where OperatorID=@OperatorID "); SqlParameter[] parameters = { new SqlParameter("@OperatorCode", SqlDbType.VarChar, 50), new SqlParameter("@OperatorName", SqlDbType.VarChar, 50), new SqlParameter("@RoleID", SqlDbType.Int, 4), new SqlParameter("@OperPassword", SqlDbType.VarChar, 50), new SqlParameter("@SiteID", SqlDbType.Int, 4), new SqlParameter("@Flag", SqlDbType.Int, 4), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@LastLoginDate", SqlDbType.DateTime), new SqlParameter("@PageRowCounts", SqlDbType.Int, 4), new SqlParameter("@OperLevel", SqlDbType.VarChar, 50), new SqlParameter("@TemplateID", SqlDbType.Int, 4), new SqlParameter("@PaymentTemplateID", SqlDbType.Int, 4), new SqlParameter("@ICTemplateID", SqlDbType.Int, 4), new SqlParameter("@Phone", SqlDbType.VarChar, 50), new SqlParameter("@SelfSetting", SqlDbType.VarChar, 500), new SqlParameter("@AutoRead", SqlDbType.Int, 4), new SqlParameter("@PhoneSerialNumber", SqlDbType.VarChar, 50), new SqlParameter("@IsBinding", SqlDbType.Int, 4), new SqlParameter("@RoleLevel", SqlDbType.Int, 4), new SqlParameter("@ExpiryDate", SqlDbType.DateTime), new SqlParameter("@Skin", SqlDbType.VarChar, 50), new SqlParameter("@OperatorID", SqlDbType.Int, 4) }; parameters[0].Value = model.OperatorCode; parameters[1].Value = model.OperatorName; parameters[2].Value = model.RoleID; parameters[3].Value = model.OperPassword; parameters[4].Value = model.SiteID; parameters[5].Value = model.Flag; parameters[6].Value = model.CreateDate; parameters[7].Value = model.LastLoginDate; parameters[8].Value = model.PageRowCounts; parameters[9].Value = model.OperLevel; parameters[10].Value = model.TemplateID; parameters[11].Value = model.PaymentTemplateID; parameters[12].Value = model.ICTemplateID; parameters[13].Value = model.Phone; parameters[14].Value = model.SelfSetting; parameters[15].Value = model.AutoRead; parameters[16].Value = model.PhoneSerialNumber; parameters[17].Value = model.IsBinding; parameters[18].Value = model.RoleLevel; parameters[19].Value = model.ExpiryDate; parameters[20].Value = model.Skin; parameters[21].Value = model.OperatorID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtOperatorCode.Text.Trim().Length == 0) { strErr += "OperatorCode不能为空!\\n"; } if (this.txtOperatorName.Text.Trim().Length == 0) { strErr += "OperatorName不能为空!\\n"; } if (!PageValidate.IsNumber(txtRoleID.Text)) { strErr += "RoleID格式错误!\\n"; } if (this.txtOperPassword.Text.Trim().Length == 0) { strErr += "OperPassword不能为空!\\n"; } if (!PageValidate.IsNumber(txtSiteID.Text)) { strErr += "SiteID格式错误!\\n"; } if (!PageValidate.IsNumber(txtFlag.Text)) { strErr += "1-正常 2锁定格式错误!\\n"; } if (!PageValidate.IsDateTime(txtCreateDate.Text)) { strErr += "CreateDate格式错误!\\n"; } if (!PageValidate.IsDateTime(txtLastLoginDate.Text)) { strErr += "LastLoginDate格式错误!\\n"; } if (!PageValidate.IsNumber(txtPageRowCounts.Text)) { strErr += "每页显示行数格式错误!\\n"; } if (this.txtOperLevel.Text.Trim().Length == 0) { strErr += "OperLevel不能为空!\\n"; } if (!PageValidate.IsNumber(txtTemplateID.Text)) { strErr += "TemplateID格式错误!\\n"; } if (!PageValidate.IsNumber(txtPaymentTemplateID.Text)) { strErr += "PaymentTemplateID格式错误!\\n"; } if (!PageValidate.IsNumber(txtICTemplateID.Text)) { strErr += "ICTemplateID格式错误!\\n"; } if (this.txtPhone.Text.Trim().Length == 0) { strErr += "Phone不能为空!\\n"; } if (this.txtSelfSetting.Text.Trim().Length == 0) { strErr += "SelfSetting不能为空!\\n"; } if (!PageValidate.IsNumber(txtAutoRead.Text)) { strErr += "AutoRead格式错误!\\n"; } if (this.txtPhoneSerialNumber.Text.Trim().Length == 0) { strErr += "PhoneSerialNumber不能为空!\\n"; } if (!PageValidate.IsNumber(txtIsBinding.Text)) { strErr += "IsBinding格式错误!\\n"; } if (!PageValidate.IsNumber(txtRoleLevel.Text)) { strErr += "RoleLevel格式错误!\\n"; } if (!PageValidate.IsDateTime(txtExpiryDate.Text)) { strErr += "ExpiryDate格式错误!\\n"; } if (this.txtSkin.Text.Trim().Length == 0) { strErr += "Skin不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int OperatorID = int.Parse(this.lblOperatorID.Text); string OperatorCode = this.txtOperatorCode.Text; string OperatorName = this.txtOperatorName.Text; int RoleID = int.Parse(this.txtRoleID.Text); string OperPassword = this.txtOperPassword.Text; int SiteID = int.Parse(this.txtSiteID.Text); int Flag = int.Parse(this.txtFlag.Text); DateTime CreateDate = DateTime.Parse(this.txtCreateDate.Text); DateTime LastLoginDate = DateTime.Parse(this.txtLastLoginDate.Text); int PageRowCounts = int.Parse(this.txtPageRowCounts.Text); string OperLevel = this.txtOperLevel.Text; int TemplateID = int.Parse(this.txtTemplateID.Text); int PaymentTemplateID = int.Parse(this.txtPaymentTemplateID.Text); int ICTemplateID = int.Parse(this.txtICTemplateID.Text); string Phone = this.txtPhone.Text; string SelfSetting = this.txtSelfSetting.Text; int AutoRead = int.Parse(this.txtAutoRead.Text); string PhoneSerialNumber = this.txtPhoneSerialNumber.Text; int IsBinding = int.Parse(this.txtIsBinding.Text); int RoleLevel = int.Parse(this.txtRoleLevel.Text); DateTime ExpiryDate = DateTime.Parse(this.txtExpiryDate.Text); string Skin = this.txtSkin.Text; WebDemo.Model.WebDemo.Operators model = new WebDemo.Model.WebDemo.Operators(); model.OperatorID = OperatorID; model.OperatorCode = OperatorCode; model.OperatorName = OperatorName; model.RoleID = RoleID; model.OperPassword = OperPassword; model.SiteID = SiteID; model.Flag = Flag; model.CreateDate = CreateDate; model.LastLoginDate = LastLoginDate; model.PageRowCounts = PageRowCounts; model.OperLevel = OperLevel; model.TemplateID = TemplateID; model.PaymentTemplateID = PaymentTemplateID; model.ICTemplateID = ICTemplateID; model.Phone = Phone; model.SelfSetting = SelfSetting; model.AutoRead = AutoRead; model.PhoneSerialNumber = PhoneSerialNumber; model.IsBinding = IsBinding; model.RoleLevel = RoleLevel; model.ExpiryDate = ExpiryDate; model.Skin = Skin; WebDemo.BLL.WebDemo.Operators bll = new WebDemo.BLL.WebDemo.Operators(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }