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;
}
