/// <summary>
/// 刷新节点
/// </summary>
/// <param name="tnParent"></param>
/// <param name="strValue"></param>
private void refreshNode(TreeNode tnParent, string strValue)
{
if (tnParent == null)
{
return;
}
T_JB_MaterielType tempType = (T_JB_MaterielType)messages[tnParent];
if (tempType.C_id == strValue)
{
messages.Remove(tnParent);
T_JB_MaterielType 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 Init()
{
try
{
T_JB_MaterielType 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;
cbEnd.Checked = mo.I_end == 0 ? false : true;
cbJx.Checked = mo.I_if_jx == 0 ? false : true;
}
}
catch (Exception)
{
MessageBox.Show("与数据库连接失败，请查看网络连接是否正常。如不能解决请与网络管理员联系！", "严重错误：", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 更新类型
/// </summary>
/// <param name="dm_type">类型信息</param>
/// <returns></returns>
public bool update(T_JB_MaterielType dm_type)
{
try
{
int count = 0;
string sql = "UPDATE T_JB_MATERIELTYPE SET C_NAME=@C_NAME, I_END=@I_END, 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("I_END", dm_type.I_end);
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="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_JB_MaterielType)messages[e.Node];
if (currentType.I_end == 1)
{
this.button1.Enabled = false;
}
else
{
this.button1.Enabled = true;
}
initNew(currentType.C_id);
isQuery = false;
setList(currentType.C_id, null, null, -1);
}
catch (Exception)
{
MessageBox.Show("与数据库连接失败，请查看网络连接是否正常。如不能解决请与网络管理员联系！", "严重错误：", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 根据编码获得信息
/// </summary>
/// <param name="tableName"></param>
/// <param name="id"></param>
/// <returns></returns>
public T_JB_MaterielType getById(string id)
{
T_JB_MaterielType area = null;
string sql = " SELECT * from T_JB_MATERIELTYPE where C_ID = '" + id + "'";
try
{
DataTable dt = dbHelper.GetDataSet(sql);
if (dt != null && dt.Rows.Count > 0)
{
area = new T_JB_MaterielType();
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.I_grade = DBNull.Value.Equals(dt.Rows[0]["I_GRADE"]) ? 0 : Convert.ToInt32(dt.Rows[0]["I_GRADE"]);
area.I_if_jx = DBNull.Value.Equals(dt.Rows[0]["I_IF_JX"]) ? 0 : Convert.ToInt32(dt.Rows[0]["I_IF_JX"]);
area.I_end = DBNull.Value.Equals(dt.Rows[0]["I_END"]) ? 0 : Convert.ToInt32(dt.Rows[0]["I_END"]);
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_JB_MaterielType> getAllChild(string pid)
{
List <T_JB_MaterielType> list = new List <T_JB_MaterielType>();
string sql = "SELECT C_ID, C_NAME, C_PRE_ID, I_GRADE, I_IF_JX, I_END, C_MEMO FROM T_JB_MATERIELTYPE 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_JB_MaterielType dm_type = new T_JB_MaterielType();
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.I_grade = Convert.IsDBNull(ds.Rows[i]["I_GRADE"]) ? 1 : Convert.ToInt32(ds.Rows[i]["I_GRADE"]);
dm_type.I_if_jx = Convert.IsDBNull(ds.Rows[i]["I_IF_JX"]) ? 0 : Convert.ToInt32(ds.Rows[i]["I_IF_JX"]);
dm_type.I_end = Convert.IsDBNull(ds.Rows[i]["I_END"]) ? 1 : Convert.ToInt32(ds.Rows[i]["I_END"]);
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);
}
/// <summary>
/// 初始化树菜单
/// </summary>
public void initTree()
{
this.treeView1.Nodes.Clear();
TreeNode root = new TreeNode("全部");
root.ImageIndex = 2;
T_JB_MaterielType all = new T_JB_MaterielType();
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>
public void addNewType(T_JB_MaterielType dm_type)
{
TreeNode subnode = new TreeNode(dm_type.C_name);
subnode.ImageIndex = 1;
currnetNode.Nodes.Add(subnode);
messages.Add(subnode, dm_type);
}
/// <summary>
/// 保存
/// </summary>
/// <param name="tableName"></param>
/// <param name="name"></param>
/// <param name="MEMO"></param>
/// <returns></returns>
public string Save(T_JB_MaterielType dm_type)
{
try
{
long dec_id = 0;
string c_id = null;
int count = 0;
string sql = "";
sql = "SELECT max(right(c_id,4)) FROM T_JB_MATERIELTYPE 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_JB_MATERIELTYPE ( C_ID, C_NAME, C_PRE_ID, I_GRADE, I_IF_JX, I_END, C_MEMO) " +
"values (@C_ID,@C_NAME,@C_PRE_ID,@I_GRADE,@I_IF_JX,@I_END,@C_MEMO)";
Hashtable table = new Hashtable();
dec_id = dec_id + 1;
c_id = dm_type.C_pre_id.Equals("0") ? dec_id.ToString().PadLeft(4, '0') : dm_type.C_pre_id + dec_id.ToString().PadLeft(4, '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("I_GRADE", dm_type.I_grade);
table.Add("I_IF_JX", dm_type.I_if_jx);
table.Add("I_END", dm_type.I_end);
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();
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
MaterielTypeAdd wa = new MaterielTypeAdd(this);
wa.ShowDialog();
if (addType != null)
{
addNewType(addType);
setList(currentType.C_id, null, null, -1);
initNew(currentType.C_id);
addType = null;
}
}
//增加
private void button1_Click(object sender, EventArgs e)
{
currentType = (T_JB_MaterielType)messages[currnetNode];
if (currentType.C_id.Equals("0001"))
{//刀具
KnifeAdd mm = new KnifeAdd(null, currentType.C_id);
mm.ShowDialog();
}
else
{
MaterielAdd mm = new MaterielAdd(null, currentType.C_id);
mm.ShowDialog();
}
querryList();
}
private void querryList()
{
string name = null;
string area = null;
string type = null;
string tuhao = null;
string cid = null;
int finish = -1;
string standerd = null;
if (this.txtName.Text != null && !(string.Empty.Equals(txtName.Text.Trim())))
{
name = txtName.Text;
}
if (this.cmbArea.SelectedValue != null && !(string.Empty.Equals(cmbArea.SelectedValue.ToString().Trim())))
{
area = cmbArea.SelectedValue.ToString();
}
if (this.textBox2.Text != null && !(string.Empty.Equals(textBox2.Text.Trim())))
{
cid = textBox2.Text;
}
if (isQuery == false)
{
currentType = (T_JB_MaterielType)messages[currnetNode];
type = currentType.C_id;
}
else
{
if (checkBox2.Checked == false)
{
currentType = (T_JB_MaterielType)messages[currnetNode];
type = currentType.C_id;
}
}
if (this.txtStand.Text != null && !(string.Empty.Equals(txtStand.Text.Trim())))
{
standerd = txtStand.Text;
}
this.dgv_Data.DataSource = mbll.getMaterielList(name, area, type, finish, standerd, Global.longid, tuhao, cid);
getName();
}
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_JB_MaterielType temp = new T_JB_MaterielType();
temp.C_name = txtName.Text.Trim();
temp.C_pre_id = lblPid.Text.Trim();
temp.I_grade = 1;
temp.I_if_jx = cbJx.Checked ? 1 : 0;
temp.I_end = cbEnd.Checked ? 1 : 0;
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);
}
}
}
/// <summary>
/// 删除节点
/// </summary>
/// <param name="tnParent"></param>
/// <param name="strValue"></param>
private void deleteNode(TreeNode tnParent, string strValue)
{
if (tnParent == null)
{
return;
}
T_JB_MaterielType tempType = (T_JB_MaterielType)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, txtName.Text.Trim(), id))
{
MessageBox.Show("名称重复！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
try
{
T_JB_MaterielType mo = new T_JB_MaterielType();
mo.C_id = id;
mo.C_pre_id = lblPid.Text;
mo.C_name = txtName.Text.Trim();
mo.C_memo = txtMemo.Text.Trim();
mo.I_end = cbEnd.Checked ? 1 : 0;
mo.I_if_jx = cbJx.Checked ? 1 : 0;
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>
/// <param name="dm_type">类型信息</param>
/// <returns></returns>
public bool Update(T_JB_MaterielType 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_JB_MaterielType dm_type)
{
return(dal.Save(dm_type));
}
