/// <summary>
/// 刷新节点
/// </summary>
/// <param name="tnParent"></param>
/// <param name="strValue"></param>
private void refreshNode(TreeNode tnParent, string strValue)
{
if (tnParent == null)
{
return;
}
T_DM_UNIT tempType = (T_DM_UNIT)messages[tnParent];
if (tempType.C_id == strValue)
{
messages.Remove(tnParent);
T_DM_UNIT newType = bll.GetById(strValue);
tnParent.Text = newType.C_name;
messages.Add(tnParent, newType);
return;
}
TreeNode tnRet = null;
foreach (TreeNode tn in tnParent.Nodes)
{
refreshNode(tn, strValue);
//if (tnRet != null) break;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (bll.IsExit(lblPid.Text, txtName.Text.Trim(), id))
{
MessageBox.Show("名称重复！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
try
{
T_DM_UNIT mo = new T_DM_UNIT();
mo.C_id = id;
mo.C_pre_id = lblPid.Text;
mo.C_name = txtName.Text.Trim();
mo.C_memo = txtMemo.Text.Trim();
if (bll.Update(mo))
{
MessageBox.Show("保存成功！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
Log.saveLog("修改部门成功！Id：" + lblId.Text);
Close();
}
else
{
MessageBox.Show("获取保存失败！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception)
{
MessageBox.Show("与数据库连接失败，请查看网络连接是否正常。如不能解决请与网络管理员联系！", "严重错误：", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
/// <summary>
/// 初始化树菜单
/// </summary>
public void initTree()
{
this.treeView1.Nodes.Clear();
TreeNode root = new TreeNode("公司");
root.ImageIndex = 2;
T_DM_UNIT all = new T_DM_UNIT();
all.C_name = "公司";
all.C_id = "0";
messages.Add(root, all);
code_Child = bll.GetAllChild("0");
for (int i = 0; i < code_Child.Count; i++)
{
TreeNode subNode = new TreeNode(code_Child[i].C_name);
subNode.ImageIndex = 1;
root.Nodes.Add(subNode);
addTree(code_Child[i].C_id, subNode);
messages.Add(subNode, code_Child[i]);
}
this.treeView1.Nodes.Add(root);
currnetNode = root;
currentType = all;
//展开根节点
root.Expand();
}
/// <summary>
/// 更新
/// </summary>
/// <param name="dm_type">部门信息</param>
/// <returns></returns>
public bool update(T_DM_UNIT dm_type)
{
try
{
int count = 0;
string sql = "UPDATE T_DM_UNIT SET C_NAME=@C_NAME,C_MEMO=@C_MEMO " +
"WHERE C_ID=@C_ID ";
Hashtable table = new Hashtable();
table.Add("C_ID", dm_type.C_id);
table.Add("C_NAME", dm_type.C_name);
table.Add("C_MEMO", dm_type.C_memo);
DbParameter[] parms = dbHelper.getParams(table);
count = dbHelper.ExecuteCommand(sql, parms);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Log.write(ex.Message + "\r\n" + ex.StackTrace);
throw ex;
}
finally
{
dbHelper.getConnection().Close();
}
}
/// <summary>
/// 根据编码获得信息
/// </summary>
/// <param name="tableName"></param>
/// <param name="id"></param>
/// <returns></returns>
public T_DM_UNIT getById(string id)
{
T_DM_UNIT area = null;
string sql = " SELECT * from T_DM_UNIT where C_ID = '" + id + "'";
try
{
DataTable dt = dbHelper.GetDataSet(sql);
if (dt != null && dt.Rows.Count > 0)
{
area = new T_DM_UNIT();
area.C_id = dt.Rows[0]["C_ID"].ToString();
area.C_name = dt.Rows[0]["C_NAME"].ToString();
area.C_pre_id = DBNull.Value.Equals(dt.Rows[0]["C_PRE_ID"]) ? "0" : dt.Rows[0]["C_PRE_ID"].ToString();
area.C_memo = DBNull.Value.Equals(dt.Rows[0]["c_MEMO"]) ? string.Empty : dt.Rows[0]["c_MEMO"].ToString();
}
}
catch (Exception ex)
{
Log.write(ex.Message + "\r\n" + ex.StackTrace);
throw ex;
}
finally
{
dbHelper.getConnection().Close();
}
return(area);
}
/// <summary>
/// 根据部门编号获得子部门信息
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public List <T_DM_UNIT> getAllChild(string pid)
{
List <T_DM_UNIT> list = new List <T_DM_UNIT>();
string sql = "SELECT C_ID, C_NAME, C_PRE_ID, C_MEMO FROM T_DM_UNIT where c_pre_id = '" + pid + "' order by c_id";
try
{
DataTable ds = dbHelper.GetDataSet(sql);
for (int i = 0; i < ds.Rows.Count; i++)
{
T_DM_UNIT dm_type = new T_DM_UNIT();
dm_type.C_id = Convert.IsDBNull(ds.Rows[i]["C_ID"]) ? string.Empty : Convert.ToString(ds.Rows[i]["C_ID"]);
dm_type.C_name = Convert.IsDBNull(ds.Rows[i]["C_NAME"]) ? string.Empty : Convert.ToString(ds.Rows[i]["C_NAME"]);
dm_type.C_pre_id = Convert.IsDBNull(ds.Rows[i]["C_PRE_ID"]) ? "1" : Convert.ToString(ds.Rows[i]["C_PRE_ID"]);
dm_type.C_memo = Convert.IsDBNull(ds.Rows[i]["C_MEMO"]) ? string.Empty : Convert.ToString(ds.Rows[i]["C_MEMO"]);
list.Add(dm_type);
}
}
catch (Exception ex)
{
Log.write(ex.Message + "\r\n" + ex.StackTrace);
throw ex;
}
finally
{
dbHelper.getConnection().Close();
}
return(list);
}
private void querryList()
{
string name = null;
string gw = null;
string unit = null;
string cid = null;
if (this.txtName.Text != null && !(string.Empty.Equals(txtName.Text.Trim())))
{
name = txtName.Text;
}
if (this.cmbGW.SelectedValue != null && !(string.Empty.Equals(cmbGW.SelectedValue.ToString().Trim())))
{
gw = cmbGW.SelectedValue.ToString();
}
if (this.textBox2.Text != null && !(string.Empty.Equals(textBox2.Text.Trim())))
{
cid = textBox2.Text;
}
if (isQuery == false)
{
currentUnit = (T_DM_UNIT)messages[currnetNode];
unit = currentUnit.C_id;
}
this.dgv_Data.DataSource = mbll.getEmployeeList(name, gw, unit, cid);
getName();
}
/// <summary>
/// 给树添加新增的类型节点
/// </summary>
/// <param name="dm_type"></param>
public void addNewType(T_DM_UNIT dm_type)
{
TreeNode subnode = new TreeNode(dm_type.C_name);
subnode.ImageIndex = 1;
currnetNode.Nodes.Add(subnode);
messages.Add(subnode, dm_type);
}
//增加
private void button1_Click(object sender, EventArgs e)
{
currentUnit = (T_DM_UNIT)messages[currnetNode];
EmployeeAdd mm = new EmployeeAdd(null, currentUnit.C_id);
mm.ShowDialog();
InitGW();
querryList();
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
UnitAdd wa = new UnitAdd(this);
wa.ShowDialog();
if (addType != null)
{
addNewType(addType);
setList(currentType.C_id, null, null);
initNew(currentType.C_id);
addType = null;
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="tableName"></param>
/// <param name="name"></param>
/// <param name="MEMO"></param>
/// <returns></returns>
public string Save(T_DM_UNIT dm_type)
{
try
{
long dec_id = 0;
string c_id = null;
int count = 0;
string sql = "";
sql = "SELECT max(right(c_id,2)) FROM T_DM_UNIT where C_PRE_ID = '" + dm_type.C_pre_id + "'";
object obj = dbHelper.GetScalar(sql);
dec_id = Convert.IsDBNull(obj) ? 0 : Convert.ToInt64(obj);
sql = "INSERT INTO T_DM_UNIT ( C_ID, C_NAME, C_PRE_ID, C_MEMO) " +
"values (@C_ID,@C_NAME,@C_PRE_ID,@C_MEMO)";
Hashtable table = new Hashtable();
dec_id = dec_id + 1;
c_id = dm_type.C_pre_id.Equals("0") ? dec_id.ToString().PadLeft(2, '0') : dm_type.C_pre_id + dec_id.ToString().PadLeft(2, '0');
table.Add("c_id", c_id);
table.Add("C_NAME", dm_type.C_name);
table.Add("C_PRE_ID", dm_type.C_pre_id);
table.Add("C_MEMO", dm_type.C_memo);
DbParameter[] parms = dbHelper.getParams(table);
count = dbHelper.ExecuteCommand(sql, parms);
if (count > 0)
{
return(c_id);
}
else
{
return(null);
}
}
catch (Exception ex)
{
Log.write(ex.Message + "\r\n" + ex.StackTrace);
throw ex;
}
finally
{
dbHelper.getConnection().Close();
}
}
//选择类别
private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
{
try
{
currnetNode = e.Node;
currentUnit = (T_DM_UNIT)messages[e.Node];
this.button1.Enabled = true;
initNew();
isQuery = false;
querryList();
}
catch (Exception)
{
MessageBox.Show("与数据库连接失败，请查看网络连接是否正常。如不能解决请与网络管理员联系！", "严重错误：", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 选择类别
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
{
try
{
//c_id = null;
//c_name = null;
currnetNode = e.Node;
currentType = (T_DM_UNIT)messages[e.Node];
initNew(currentType.C_id);
isQuery = false;
setList(currentType.C_id, null, null);
}
catch (Exception)
{
MessageBox.Show("与数据库连接失败，请查看网络连接是否正常。如不能解决请与网络管理员联系！", "严重错误：", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 删除节点
/// </summary>
/// <param name="tnParent"></param>
/// <param name="strValue"></param>
private void deleteNode(TreeNode tnParent, string strValue)
{
if (tnParent == null)
{
return;
}
T_DM_UNIT tempType = (T_DM_UNIT)messages[tnParent];
if (tempType.C_id == strValue)
{
tnParent.Remove();
messages.Remove(tnParent);
return;
}
TreeNode tnRet = null;
foreach (TreeNode tn in tnParent.Nodes)
{
deleteNode(tn, strValue);
//if (tnRet != null) break;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (bll.IsExit(lblPid.Text.Trim(), txtName.Text.Trim()))
{
MessageBox.Show("名称重复！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
try
{
T_DM_UNIT temp = new T_DM_UNIT();
temp.C_name = txtName.Text.Trim();
temp.C_pre_id = lblPid.Text.Trim();
temp.C_memo = txtMemo.Text.Trim();
string c_id = bll.Save(temp);
if (c_id != null && !(string.Empty.Equals(c_id.Trim())))
{
temp.C_id = c_id;
parentForm.addType = temp;
MessageBox.Show("保存成功！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
Log.saveLog("添加部门成功！Id：" + c_id);
Close();
}
else
{
MessageBox.Show("获取保存失败！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception)
{
MessageBox.Show("与数据库连接失败，请查看网络连接是否正常。如不能解决请与网络管理员联系！", "严重错误：", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void Init()
{
try
{
T_DM_UNIT mo = bll.GetById(id);
if (mo == null)
{
MessageBox.Show("获取信息失败！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.Close();
}
else
{
this.lblId.Text = mo.C_id;
this.txtName.Text = mo.C_name;
this.lblPid.Text = mo.C_pre_id;
this.txtMemo.Text = mo.C_memo;
}
}
catch (Exception)
{
MessageBox.Show("与数据库连接失败，请查看网络连接是否正常。如不能解决请与网络管理员联系！", "严重错误：", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 更新部门
/// </summary>
/// <param name="dm_type">部门信息</param>
/// <returns></returns>
public bool Update(T_DM_UNIT dm_type)
{
return(dal.update(dm_type));
}
/// <summary>
/// 保存
/// </summary>
/// <param name="tableName"></param>
/// <param name="name"></param>
/// <param name="meno"></param>
/// <returns></returns>
public string Save(T_DM_UNIT dm_type)
{
return(dal.Save(dm_type));
}
