public MODELBASE_POST GetModelBASE_POST(string strDepID) { DataTable dt = new DataTable(); MODELBASE_POST MODELBASE_POST = new MODELBASE_POST(); StringBuilder str = new StringBuilder(); str.Append("SELECT * FROM BASE_POST WHERE POSTID=@POSTID"); SqlParameter[] para = { new SqlParameter("@POSTID", SqlDbType.VarChar, 30) }; para[0].Value = strDepID; dt = DBUtility.DbHelperSQL.Query(str.ToString(), para).Tables[0]; if (dt.Rows.Count == 0) { return(null); } else { MODELBASE_POST.POSTNAME = dt.Rows[0]["POSTNAME"].ToString(); if (dt.Rows[0]["MEMO"] != null) { MODELBASE_POST.MEMO = dt.Rows[0]["MEMO"].ToString(); } return(MODELBASE_POST); } }
public bool UpdatePOST(MODELBASE_POST MODELBASE_POST) { StringBuilder str = new StringBuilder(); str.Append("UPDATE BASE_POST SET POSTNAME=@POSTNAME,MEMO=@MEMO "); str.Append("WHERE POSTID=@POSTID"); SqlParameter[] para = { new SqlParameter("@POSTNAME", SqlDbType.VarChar, 50), new SqlParameter("@MEMO", SqlDbType.VarChar, 50), new SqlParameter("@POSTID", SqlDbType.VarChar, 50) }; para[0].Value = MODELBASE_POST.POSTNAME; para[1].Value = MODELBASE_POST.MEMO; para[2].Value = MODELBASE_POST.POSTID; if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0) { return(true); } else { return(false); } }
private void toolSubmit_Click(object sender, EventArgs e) { try { if (txtName.Text.Trim() == "") { mes.Show("请输入职务名称!"); txtName.Focus(); return; } MODELBASE_POST MODELBASE_POST = new MODELBASE_POST(); MODELBASE_POST.POSTNAME = txtName.Text; MODELBASE_POST.MEMO = txtMemo.Text; if (txtID.Text == "") { if (BLLBASE_POST.InsertBASE_POST(MODELBASE_POST)) { toolSearch_Click(null, null); dgList.ClearSelection(); dgList.CurrentCell = dgList.Rows[dgList.Rows.Count - 1].Cells[1]; dgList_SelectionChanged(null, null); } else { mes.Show("添加失败,请重新点击保存按钮!"); return; } } else { MODELBASE_POST.POSTID = txtID.Text; if (BLLBASE_POST.UpdatePOST(MODELBASE_POST)) { dgList.CurrentRow.Cells["POSTID"].Value = MODELBASE_POST.POSTID; dgList.CurrentRow.Cells["POSTNAME"].Value = MODELBASE_POST.POSTNAME; dgList.CurrentRow.Cells["MEMO"].Value = MODELBASE_POST.MEMO; } else { mes.Show("修改失败,请重新点击保存按钮!"); return; } } //DisEnableControl(gbDetail); dgList.Enabled = true; toolAdd.Text = "添加"; toolDelete.Enabled = true; toolSearch.Enabled = true; } catch (Exception ex) { log.Write(ex.Message, MsgType.Error); mes.Show(ex.Message); } }
public bool InsertBASE_POST(MODELBASE_POST MODELBASE_POST) { StringBuilder str = new StringBuilder(); str.Append("INSERT INTO BASE_POST(POSTNAME,MEMO) "); str.Append("VALUES(@POSTNAME,@MEMO)"); SqlParameter[] para = { new SqlParameter("@POSTNAME", SqlDbType.VarChar, 50), new SqlParameter("@MEMO", SqlDbType.VarChar, 50) }; para[0].Value = MODELBASE_POST.POSTNAME; para[1].Value = MODELBASE_POST.MEMO; if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0) { return(true); } else { return(false); } }