public bool Insert(MODELBASE_DUAN MODELBASE_DUAN) { StringBuilder str = new StringBuilder(); str.Append("INSERT INTO BASE_DUAN(DUANID,DUANNAME,PARENTID,MEMO) "); str.Append("VALUES(@DUANID,@DUANNAME,@PARENTID,@MEMO)"); SqlParameter[] para = { new SqlParameter("@DUANID", SqlDbType.VarChar, 30), new SqlParameter("@DUANNAME", SqlDbType.VarChar, 50), new SqlParameter("@PARENTID", SqlDbType.VarChar, 30), new SqlParameter("@MEMO", SqlDbType.VarChar, 50) }; para[0].Value = MODELBASE_DUAN.DUANID; para[1].Value = MODELBASE_DUAN.DUANNAME; para[2].Value = MODELBASE_DUAN.PARENTID; para[3].Value = MODELBASE_DUAN.MEMO; if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0) { return(true); } else { return(false); } }
public MODELBASE_DUAN GetMODELBASE_DUAN(string strDepID) { DataTable dt = new DataTable(); MODELBASE_DUAN MODELBASE_DUAN = new MODELBASE_DUAN(); StringBuilder str = new StringBuilder(); str.Append("SELECT * FROM BASE_DUAN WHERE DUANID=@DUANID"); SqlParameter[] para = { new SqlParameter("@DUANID", 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_DUAN.DUANNAME = dt.Rows[0]["DUANNAME"].ToString(); if (dt.Rows[0]["PARENTID"] != null) { MODELBASE_DUAN.PARENTID = dt.Rows[0]["PARENTID"].ToString(); } if (dt.Rows[0]["MEMO"] != null) { MODELBASE_DUAN.MEMO = dt.Rows[0]["MEMO"].ToString(); } return(MODELBASE_DUAN); } }
public bool Update(MODELBASE_DUAN MODELBASE_DUAN) { StringBuilder str = new StringBuilder(); str.Append("UPDATE BASE_DUAN SET DUANNAME=@DUANNAME,MEMO=@MEMO "); str.Append("WHERE DUANID=@DUANID"); SqlParameter[] para = { new SqlParameter("@DUANNAME", SqlDbType.VarChar, 50), new SqlParameter("@MEMO", SqlDbType.VarChar, 50), new SqlParameter("@DUANID", SqlDbType.VarChar, 50) }; para[0].Value = MODELBASE_DUAN.DUANNAME; para[1].Value = MODELBASE_DUAN.MEMO; para[2].Value = MODELBASE_DUAN.DUANID; 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_DUAN MODELBASE_DUAN = new MODELBASE_DUAN(); MODELBASE_DUAN.DUANNAME = txtName.Text; MODELBASE_DUAN.PARENTID = "0000"; MODELBASE_DUAN.MEMO = txtMemo.Text; if (IsADD) { MODELBASE_DUAN.DUANID = GETTABLEID.GetTableID("", "BASE_DUAN"); } else { MODELBASE_DUAN.DUANID = txtID.Text; } try { if (IsADD) { if (BLLBASE_DUAN.Insert(MODELBASE_DUAN)) { tvDep.Enabled = true; tvDep.Nodes.Clear(); AddTreeNode("0", null); toolAdd.Text = "添加"; toolAdd.Enabled = true; GetSelectedNode(tvDep.Nodes[0], MODELBASE_DUAN.DUANID); } } else { if (BLLBASE_DUAN.Update(MODELBASE_DUAN)) { tvDep.Enabled = true; tvDep.Nodes.Clear(); AddTreeNode("0", null); GetSelectedNode(tvDep.Nodes[0], MODELBASE_DUAN.DUANID); } } } 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_DUAN MODELBASE_DUAN = new MODELBASE_DUAN(); MODELBASE_DUAN = BLLBASE_DUAN.GetMODELBASE_DUAN(strDepID); txtID.Text = strDepID; txtName.Text = MODELBASE_DUAN.DUANNAME; txtMemo.Text = MODELBASE_DUAN.MEMO; }