public MODELBASE_PIAN GetMODELBASE_PIAN(string strDepID) { DataTable dt = new DataTable(); MODELBASE_PIAN MODELBASE_PIAN = new MODELBASE_PIAN(); StringBuilder str = new StringBuilder(); str.Append("SELECT * FROM BASE_PIAN WHERE PIANID=@PIANID"); SqlParameter[] para = { new SqlParameter("@PIANID", 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_PIAN.PIANNAME = dt.Rows[0]["PIANNAME"].ToString(); if (dt.Rows[0]["PARENTID"] != null) { MODELBASE_PIAN.PARENTID = dt.Rows[0]["PARENTID"].ToString(); } if (dt.Rows[0]["MEMO"] != null) { MODELBASE_PIAN.MEMO = dt.Rows[0]["MEMO"].ToString(); } return(MODELBASE_PIAN); } }
public bool Insert(MODELBASE_PIAN MODELBASE_PIAN) { StringBuilder str = new StringBuilder(); str.Append("INSERT INTO BASE_PIAN(PIANID,PIANNAME,PARENTID,MEMO) "); str.Append("VALUES(@PIANID,@PIANNAME,@PARENTID,@MEMO)"); SqlParameter[] para = { new SqlParameter("@PIANID", SqlDbType.VarChar, 30), new SqlParameter("@PIANNAME", SqlDbType.VarChar, 50), new SqlParameter("@PARENTID", SqlDbType.VarChar, 30), new SqlParameter("@MEMO", SqlDbType.VarChar, 50) }; para[0].Value = MODELBASE_PIAN.PIANID; para[1].Value = MODELBASE_PIAN.PIANNAME; para[2].Value = MODELBASE_PIAN.PARENTID; para[3].Value = MODELBASE_PIAN.MEMO; if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0) { return(true); } else { return(false); } }
public bool Update(MODELBASE_PIAN MODELBASE_PIAN) { StringBuilder str = new StringBuilder(); str.Append("UPDATE BASE_PIAN SET PIANNAME=@PIANNAME,MEMO=@MEMO "); str.Append("WHERE PIANID=@PIANID"); SqlParameter[] para = { new SqlParameter("@PIANNAME", SqlDbType.VarChar, 50), new SqlParameter("@MEMO", SqlDbType.VarChar, 50), new SqlParameter("@PIANID", SqlDbType.VarChar, 50) }; para[0].Value = MODELBASE_PIAN.PIANNAME; para[1].Value = MODELBASE_PIAN.MEMO; para[2].Value = MODELBASE_PIAN.PIANID; if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0) { return(true); } else { return(false); } }
private void toolSubmit_Click(object sender, EventArgs e) { if (!IsADD && tvDep.SelectedNode.Tag.ToString() == "0000") { mes.Show("该片区无法删除或修改!"); return; } if (txtName.Text.Trim() == "") { mes.Show("请填写片区名称!"); txtName.Focus(); return; } MODELBASE_PIAN MODELBASE_PIAN = new MODELBASE_PIAN(); MODELBASE_PIAN.PIANNAME = txtName.Text; MODELBASE_PIAN.PARENTID = "0000"; MODELBASE_PIAN.MEMO = txtMemo.Text; if (IsADD) { MODELBASE_PIAN.PIANID = GETTABLEID.GetTableID("", "BASE_PIAN"); } else { MODELBASE_PIAN.PIANID = txtID.Text; } try { if (IsADD) { if (BLLBASE_PIAN.Insert(MODELBASE_PIAN)) { tvDep.Enabled = true; tvDep.Nodes.Clear(); AddTreeNode("0", null); toolAdd.Text = "添加"; toolAdd.Enabled = true; GetSelectedNode(tvDep.Nodes[0], MODELBASE_PIAN.PIANID); } } else { if (BLLBASE_PIAN.Update(MODELBASE_PIAN)) { tvDep.Enabled = true; tvDep.Nodes.Clear(); AddTreeNode("0", null); GetSelectedNode(tvDep.Nodes[0], MODELBASE_PIAN.PIANID); } } } catch (Exception ex) { lg.Write(ex.ToString(), MsgType.Error); mes.Show(ex.Message.ToString()); return; } IsADD = false; }
private void tvDep_AfterSelect(object sender, TreeViewEventArgs e) { if (e.Node == null) { return; } string strDepID = e.Node.Tag.ToString(); MODELBASE_PIAN MODELBASE_PIAN = new MODELBASE_PIAN(); MODELBASE_PIAN = BLLBASE_PIAN.GetMODELBASE_PIAN(strDepID); txtID.Text = strDepID; txtName.Text = MODELBASE_PIAN.PIANNAME; txtMemo.Text = MODELBASE_PIAN.MEMO; }