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