/// <summary> /// 增加一条数据 /// </summary> public int Add(GSSModel.Department model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_Department("); strSql.Append("F_ParentID,F_DepartName,F_Note)"); strSql.Append(" values ("); strSql.Append("@F_ParentID,@F_DepartName,@F_Note)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@F_ParentID", SqlDbType.Int, 4), new SqlParameter("@F_DepartName", SqlDbType.NVarChar, 30), new SqlParameter("@F_Note", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.F_ParentID; parameters[1].Value = model.F_DepartName; parameters[2].Value = model.F_Note; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(GSSModel.Department model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_Department set "); strSql.Append("F_ParentID=@F_ParentID,"); strSql.Append("F_DepartName=@F_DepartName,"); strSql.Append("F_Note=@F_Note"); strSql.Append(" where F_DepartID=@F_DepartID"); SqlParameter[] parameters = { new SqlParameter("@F_ParentID", SqlDbType.Int, 4), new SqlParameter("@F_DepartName", SqlDbType.NVarChar, 30), new SqlParameter("@F_Note", SqlDbType.NVarChar, 200), new SqlParameter("@F_DepartID", SqlDbType.Int, 4) }; parameters[0].Value = model.F_ParentID; parameters[1].Value = model.F_DepartName; parameters[2].Value = model.F_Note; parameters[3].Value = model.F_DepartID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 保存数据 /// </summary> private void SaveData() { //验证数据项 string msg = ""; if (f_DepartNameTextBox.Text.Trim().Length == 0) { msg += "部门名不能为空!\r\n"; } if (f_ParentIDComboBox.SelectedValue.ToString() == f_DepartIDTextBox.Text && f_DepartIDTextBox.Text != "0") { msg += "上级部门不能选择本部门!\r\n"; } if (msg.Length > 0) { MessageBox.Show(msg, "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } //数据准备 GSSModel.Department model = new GSSModel.Department(); model.F_ParentID = int.Parse(f_ParentIDComboBox.SelectedValue.ToString()); model.F_DepartName = f_DepartNameTextBox.Text; model.F_Note = f_NoterichTextBox.Text; //数据提交 GSSBLL.Department bll = new GSSBLL.Department(); bool isok = false; if (_id != 0) { model.F_DepartID = int.Parse(f_DepartIDTextBox.Text); isok = bll.Update(model); } else { int num = bll.Add(model); if (num > 0) { isok = true; } } if (isok) { MessageBox.Show("数据保存成功!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("数据保存失败!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// 初始化窗体 /// </summary> private void InitForm() { GSSServerLibrary.ServerUtil.BindDropDLTDept(this.f_ParentIDComboBox); if (_id != 0) { this.Text = "部门修改"; GSSBLL.Department bll = new GSSBLL.Department(); GSSModel.Department model = bll.GetModel(_id); f_DepartIDTextBox.Text = model.F_DepartID.ToString(); f_ParentIDComboBox.SelectedValue = model.F_ParentID; f_DepartNameTextBox.Text = model.F_DepartName; f_NoterichTextBox.Text = model.F_Note; } }
/// <summary> /// 得到一个对象实体 /// </summary> public GSSModel.Department GetModel(int F_DepartID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 F_DepartID,F_ParentID,F_DepartName,F_Note from T_Department "); strSql.Append(" where F_DepartID=@F_DepartID"); SqlParameter[] parameters = { new SqlParameter("@F_DepartID", SqlDbType.Int, 4) }; parameters[0].Value = F_DepartID; GSSModel.Department model = new GSSModel.Department(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["F_DepartID"].ToString() != "") { model.F_DepartID = int.Parse(ds.Tables[0].Rows[0]["F_DepartID"].ToString()); } if (ds.Tables[0].Rows[0]["F_ParentID"].ToString() != "") { model.F_ParentID = int.Parse(ds.Tables[0].Rows[0]["F_ParentID"].ToString()); } if (ds.Tables[0].Rows[0]["F_DepartName"] != null) { model.F_DepartName = ds.Tables[0].Rows[0]["F_DepartName"].ToString(); } if (ds.Tables[0].Rows[0]["F_Note"] != null) { model.F_Note = ds.Tables[0].Rows[0]["F_Note"].ToString(); } return(model); } else { return(null); } }