/// <summary> /// 更新一条数据 /// </summary> public bool Update(yinxiang.Model.k3_2Operator_new model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update k3_2Operator_new set "); strSql.Append("PassWord=@PassWord,"); strSql.Append("IsAdmin=@IsAdmin,"); strSql.Append("Note=@Note"); strSql.Append(" where UserID=@UserID"); SqlParameter[] parameters = { new SqlParameter("@PassWord", SqlDbType.VarChar, 20), new SqlParameter("@IsAdmin", SqlDbType.VarChar, 20), new SqlParameter("@Note", SqlDbType.VarChar, 200), new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@OperatorName", SqlDbType.VarChar, 50) }; parameters[0].Value = model.PassWord; parameters[1].Value = model.IsAdmin; parameters[2].Value = model.Note; parameters[3].Value = model.UserID; parameters[4].Value = model.OperatorName; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(yinxiang.Model.k3_2Operator_new model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into k3_2Operator_new("); strSql.Append("OperatorName,PassWord,IsAdmin,Note)"); strSql.Append(" values ("); strSql.Append("@OperatorName,@PassWord,@IsAdmin,@Note)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@OperatorName", SqlDbType.VarChar, 50), new SqlParameter("@PassWord", SqlDbType.VarChar, 20), new SqlParameter("@IsAdmin", SqlDbType.VarChar, 20), new SqlParameter("@Note", SqlDbType.VarChar, 200) }; parameters[0].Value = model.OperatorName; parameters[1].Value = model.PassWord; parameters[2].Value = model.IsAdmin; parameters[3].Value = model.Note; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public yinxiang.Model.k3_2Operator_new DataRowToModel(DataRow row) { yinxiang.Model.k3_2Operator_new model = new yinxiang.Model.k3_2Operator_new(); if (row != null) { if (row["UserID"] != null && row["UserID"].ToString() != "") { model.UserID = int.Parse(row["UserID"].ToString()); } if (row["OperatorName"] != null) { model.OperatorName = row["OperatorName"].ToString(); } if (row["PassWord"] != null) { model.PassWord = row["PassWord"].ToString(); } if (row["IsAdmin"] != null) { model.IsAdmin = row["IsAdmin"].ToString(); } if (row["Note"] != null) { model.Note = row["Note"].ToString(); } } return(model); }
private void ShowInfo(int UserID) { yinxiang.BLL.k3_2Operator_new bll = new yinxiang.BLL.k3_2Operator_new(); yinxiang.Model.k3_2Operator_new model = bll.GetModel(UserID); this.lblUserID.Text = model.UserID.ToString(); this.lblOperatorName.Text = model.OperatorName; this.txtPassWord.Text = model.PassWord; this.txtIsAdmin.Text = model.IsAdmin; this.txtNote.Text = model.Note; }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtOperatorName.Text.Trim().Length == 0) { strErr += "OperatorName不能为空!\\n"; } if (this.txtPassWord.Text.Trim().Length == 0) { strErr += "PassWord不能为空!\\n"; } if (this.txtIsAdmin.Text.Trim().Length == 0) { strErr += "IsAdmin不能为空!\\n"; } if (this.txtNote.Text.Trim().Length == 0) { strErr += "Note不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string OperatorName = this.txtOperatorName.Text; string PassWord = this.txtPassWord.Text; string IsAdmin = this.txtIsAdmin.Text; string Note = this.txtNote.Text; yinxiang.Model.k3_2Operator_new model = new yinxiang.Model.k3_2Operator_new(); model.OperatorName = OperatorName; model.PassWord = PassWord; model.IsAdmin = IsAdmin; model.Note = Note; yinxiang.BLL.k3_2Operator_new bll = new yinxiang.BLL.k3_2Operator_new(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public yinxiang.Model.k3_2Operator_new GetModel(int UserID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 UserID,OperatorName,PassWord,IsAdmin,Note from k3_2Operator_new "); strSql.Append(" where UserID=@UserID"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int, 4) }; parameters[0].Value = UserID; yinxiang.Model.k3_2Operator_new model = new yinxiang.Model.k3_2Operator_new(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }