/// <summary>
/// 删除产品结构的一条记录
/// </summary>
/// <param name="c"></param>
public void delStruct(PDM_STRUCT c)
{
string sqlText = "DELETE FROM PDM_STRUCT WHERE OBJECTID='" + c.OBJECTID
+ "' AND ASSOBJECTID ='" + c.ASSOBJECTID + "' ";
this.DataAccessor.Execute(sqlText);
}
/// <summary>
/// 插入产品结构
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void toolStructInsert_Click(object sender, EventArgs e)
{
//1.找到插入的节点的位置
PDM_STRUCT t_struct = new PDM_STRUCT();
TreeListViewItem item = this.list_productTreeStruct.Items[0];
int count = 0; int index = 0;
for (int i = 0; i < item.Items.Count; i++)
{
if (item.Items[i].CheckStatus == CheckState.Checked)
{
count++;
index = i;
}
}
if (count != 1)
{
MessageBox.Show("只能选择一条记录且子结构无法更改！");
return;
}
t_struct.OBJECTID = this.m_product.PRODUCTID;
t_struct.ASSOBJECTID = item.Items[index].Tag.ToString();
//2.打开产品添加界面传递（产品对象，关联对象ID,操作类型--插入）参数
ProductsStructAddForm o = new ProductsStructAddForm(this.m_product, t_struct.ASSOBJECTID, Enum_AssOpType.INSERT);
o.StartPosition = FormStartPosition.CenterParent;
o.ShowDialog();
//3.清空产品结构树，并重新构造树
this.list_productTreeStruct.Items.Clear();
list_productTreeStruct_init();
}
public StructAddForm(PDM_STRUCT p_struct, string p_assobjectId, Enum_AssOpType p_assoPType)
{
InitializeComponent();
m_struct = p_struct;
m_assojectId = p_assobjectId;
m_assoPType = p_assoPType;
initControl();
}
public StructAddForm(PDM_STRUCT p_struct, string p_assobjectId, Enum_AssOpType p_assoPType)
{
InitializeComponent();
m_struct = p_struct;
m_assojectId = p_assobjectId;
m_assoPType = p_assoPType;
initControl();
}
/// <summary>
/// 获取一条记录（产品，半成品，材料）之间的关联关系
/// </summary>
/// <param name="c"></param>
/// <returns></returns>
public DataTable getStruct(PDM_STRUCT c)
{
string sqlText = "SELECT * FROM PDM_STRUCT WHERE DEL_FLAG='N' AND OBJECTID='" + c.OBJECTID
+ "' AND ASSOBJECTID ='" + c.ASSOBJECTID + "' ";
DataTable dt = this.DataAccessor.QueryDataTable(sqlText);
return(dt);
}
/// <summary>
/// 保存产品结构的一条记录
/// </summary>
/// <param name="c"></param>
public void saveStruct(PDM_STRUCT c)
{
string sqlText = "INSERT PDM_STRUCT (OBJECTID,ASSOBJECTID,ASSONUM,ASSOWEIGHT,SORTNUM,MEMO,DEL_FLAG) VALUES ('"
+ c.OBJECTID + "','"
+ c.ASSOBJECTID + "','"
+ c.ASSONUM + "','"
+ c.ASSOWEIGHT + "','"
+ c.SORTNUM + "','"
+ c.MEMO + "','N') ";
this.DataAccessor.Execute(sqlText);
}
//插入一条记录时显示初始化
private void initInsert()
{
PDM_STRUCT p_struct = new PDM_STRUCT();
p_struct.OBJECTID = m_struct.OBJECTID;
p_struct.ASSOBJECTID = this.m_assojectId;
DataTable dt = m_structService.getStruct(p_struct);
this.tb_assoNum.Text = "";
this.tb_assoWeight.Text = "";
this.tb_sortNum.Text = (Convert.ToInt16(dt.Rows[0]["SORTNUM"].ToString()) + 1).ToString();
this.rtb_memo.Text = "";
}
//替换一条记录时显示初始化
private void initReplace()
{
PDM_STRUCT p_struct = new PDM_STRUCT();
p_struct.OBJECTID = m_struct.OBJECTID;
p_struct.ASSOBJECTID = this.m_assojectId;
DataTable dt = m_structService.getStruct(p_struct);
this.tb_assoNum.Text = dt.Rows[0]["ASSONUM"].ToString();
this.tb_assoWeight.Text = dt.Rows[0]["ASSOWEIGHT"].ToString();
this.tb_sortNum.Text = dt.Rows[0]["SORTNUM"].ToString();
this.rtb_memo.Text = dt.Rows[0]["MEMO"].ToString();
}
//判断部件是否包含在产品结构中
private int filterSelect(string p_assoId)
{
PDM_STRUCT t_struct = new PDM_STRUCT();
t_struct.OBJECTID = this.copy_Product.PRODUCTID;
t_struct.ASSOBJECTID = p_assoId;
DataTable dt = m_structService.getStruct(t_struct);
if (dt.Rows.Count > 0)
{
return(-1);
}
return(0);
}
/// <summary>
/// 编辑产品结构的一条记录
/// </summary>
/// <param name="c"></param>
/// <param name="p_assobjId"></param>
public void editStruct(PDM_STRUCT c,string p_assobjId)
{
string m_assobjId = "";
if (p_assobjId == "")
{
m_assobjId = c.ASSOBJECTID;
}
else {
m_assobjId = p_assobjId;
}
string sqlText = "UPDATE PDM_STRUCT SET ASSOBJECTID ='" + c.ASSOBJECTID + "',"
+ "ASSONUM ='" + c.ASSONUM + "',"
+ "ASSOWEIGHT ='" + c.ASSOWEIGHT + "',"
+ "SORTNUM ='" + c.SORTNUM + "',"
+ "MEMO ='" + c.MEMO + "' "
+ "WHERE OBJECTID='" + c.OBJECTID +"' "
+ "AND ASSOBJECTID ='" + m_assobjId + "' ";
this.DataAccessor.Execute(sqlText);
}
/// <summary>
/// 删除产品结构
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void toolStructDel_Click(object sender, EventArgs e)
{
//1.判断是否要删除选中的产品结构
if (MessageBox.Show("您确认要删除所选择的产品结构\n请确认您的操作。", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
{
return;
}
//2.找出被选择的产品结构
PDM_STRUCT t_struct = new PDM_STRUCT();
TreeListViewItem item = this.list_productTreeStruct.Items[0];
List <TreeListViewItem> list = new List <TreeListViewItem>();
for (int i = 0; i < item.Items.Count; i++)
{
if (item.Items[i].CheckStatus == CheckState.Checked)
{
list.Add(item.Items[i]);
}
}
//3.删除被选择的产品结构
if (list.Count > 0)
{
foreach (TreeListViewItem tlvi in list)
{
t_struct.OBJECTID = this.m_product.PRODUCTID;
t_struct.ASSOBJECTID = tlvi.Tag.ToString();
//m_StructService.delStruct(t_struct);
m_StructService.delStruct(t_struct.OBJECTID, t_struct.ASSOBJECTID);
}
}
else
{
MessageBox.Show("最少选择一条记录！");
}
//4.清空并重新构造产品结构树
this.list_productTreeStruct.Items.Clear();
list_productTreeStruct_init();
}
/// <summary>
/// 编辑产品结构的一条记录
/// </summary>
/// <param name="c"></param>
/// <param name="p_assobjId"></param>
public void editStruct(PDM_STRUCT c, string p_assobjId)
{
string m_assobjId = "";
if (p_assobjId == "")
{
m_assobjId = c.ASSOBJECTID;
}
else
{
m_assobjId = p_assobjId;
}
string sqlText = "UPDATE PDM_STRUCT SET ASSOBJECTID ='" + c.ASSOBJECTID + "',"
+ "ASSONUM ='" + c.ASSONUM + "',"
+ "ASSOWEIGHT ='" + c.ASSOWEIGHT + "',"
+ "SORTNUM ='" + c.SORTNUM + "',"
+ "MEMO ='" + c.MEMO + "' "
+ "WHERE OBJECTID='" + c.OBJECTID + "' "
+ "AND ASSOBJECTID ='" + m_assobjId + "' ";
this.DataAccessor.Execute(sqlText);
}
/// <summary>
/// 修改产品结构
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void toolStructEdit_Click(object sender, EventArgs e)
{
//1.找出需要修改的产品结构
PDM_STRUCT t_struct = new PDM_STRUCT();
TreeListViewItem item = this.list_productTreeStruct.Items[0];
int count = 0; int index = 0;
for (int i = 0; i < item.Items.Count; i++)
{
if (item.Items[i].CheckStatus == CheckState.Checked)
{
count++;
index = i;
}
}
if (count != 1)
{
MessageBox.Show("只能选择一条记录且子结构无法更改！");
return;
}
t_struct.OBJECTID = this.m_product.PRODUCTID;
t_struct.ASSOBJECTID = item.Items[index].Tag.ToString();
//2.记录修改界面传递（关联对象，关联对象ID,操作类型--修改）参数
StructAddForm o = new StructAddForm(t_struct, "", Enum_AssOpType.EDIT);
o.StartPosition = FormStartPosition.CenterParent;
//3.判断是否修改如果修改（清空产品结构树，并重新构造树）
if (o.ShowDialog() == DialogResult.OK)
{
this.list_productTreeStruct.Items.Clear();
list_productTreeStruct_init();
}
}
/// <summary>
/// 删除产品结构
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void toolStructDel_Click(object sender, EventArgs e)
{
//1.判断是否要删除选中的产品结构
if (MessageBox.Show("您确认要删除所选择的产品结构\n请确认您的操作。", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
{
return;
}
//2.找出被选择的产品结构
PDM_STRUCT t_struct = new PDM_STRUCT();
TreeListViewItem item = this.list_productTreeStruct.Items[0];
List<TreeListViewItem> list = new List<TreeListViewItem>();
for (int i = 0; i < item.Items.Count; i++)
{
if(item.Items[i].CheckStatus==CheckState.Checked){
list.Add(item.Items[i]);
}
}
//3.删除被选择的产品结构
if (list.Count > 0)
{
foreach (TreeListViewItem tlvi in list)
{
t_struct.OBJECTID = this.m_product.PRODUCTID;
t_struct.ASSOBJECTID = tlvi.Tag.ToString();
//m_StructService.delStruct(t_struct);
m_StructService.delStruct(t_struct.OBJECTID, t_struct.ASSOBJECTID);
}
}
else {
MessageBox.Show("最少选择一条记录！");
}
//4.清空并重新构造产品结构树
this.list_productTreeStruct.Items.Clear();
list_productTreeStruct_init();
}
/// <summary>
/// 删除产品结构的一条记录
/// </summary>
/// <param name="c"></param>
public void delStruct(PDM_STRUCT c)
{
string sqlText = "DELETE FROM PDM_STRUCT WHERE OBJECTID='" + c.OBJECTID
+ "' AND ASSOBJECTID ='" + c.ASSOBJECTID + "' ";
this.DataAccessor.Execute(sqlText);
}
/// <summary>
/// 保存产品结构的一条记录
/// </summary>
/// <param name="c"></param>
public void saveStruct(PDM_STRUCT c)
{
string sqlText = "INSERT PDM_STRUCT (OBJECTID,ASSOBJECTID,ASSONUM,ASSOWEIGHT,SORTNUM,MEMO,DEL_FLAG) VALUES ('"
+ c.OBJECTID + "','"
+ c.ASSOBJECTID + "','"
+ c.ASSONUM + "','"
+ c.ASSOWEIGHT + "','"
+ c.SORTNUM + "','"
+ c.MEMO + "','N') ";
this.DataAccessor.Execute(sqlText);
}
/// <summary>
/// 获取一条记录（产品，半成品，材料）之间的关联关系
/// </summary>
/// <param name="c"></param>
/// <returns></returns>
public DataTable getStruct(PDM_STRUCT c)
{
string sqlText = "SELECT * FROM PDM_STRUCT WHERE DEL_FLAG='N' AND OBJECTID='" + c.OBJECTID
+ "' AND ASSOBJECTID ='" + c.ASSOBJECTID + "' ";
DataTable dt=this.DataAccessor.QueryDataTable(sqlText);
return dt;
}
/// <summary>
/// 替换产品结构
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void toolStructReplace_Click(object sender, EventArgs e)
{
//1.查找需要替换的产品结构
PDM_STRUCT t_struct = new PDM_STRUCT();
TreeListViewItem item = this.list_productTreeStruct.Items[0];
int count = 0; int index = 0;
for (int i = 0; i < item.Items.Count; i++)
{
if (item.Items[i].CheckStatus == CheckState.Checked)
{
count++;
index = i;
}
}
if (count != 1)
{
MessageBox.Show("只能选择一条记录且子结构无法更改！");
return;
}
t_struct.OBJECTID = this.m_product.PRODUCTID;
t_struct.ASSOBJECTID = item.Items[index].Tag.ToString();
//2.打开产品添加界面传递（产品对象，关联对象ID,操作类型--替换）参数
ProductsStructAddForm o = new ProductsStructAddForm(this.m_product, t_struct.ASSOBJECTID, Enum_AssOpType.REPLACE);
o.StartPosition = FormStartPosition.CenterParent;
o.ShowDialog();
//3.清空产品结构树，并重新构造树
this.list_productTreeStruct.Items.Clear();
list_productTreeStruct_init();
}
//替换一条记录时显示初始化
private void initReplace()
{
PDM_STRUCT p_struct = new PDM_STRUCT();
p_struct.OBJECTID = m_struct.OBJECTID;
p_struct.ASSOBJECTID = this.m_assojectId;
DataTable dt = m_structService.getStruct(p_struct);
this.tb_assoNum.Text = dt.Rows[0]["ASSONUM"].ToString();
this.tb_assoWeight.Text = dt.Rows[0]["ASSOWEIGHT"].ToString();
this.tb_sortNum.Text = dt.Rows[0]["SORTNUM"].ToString();
this.rtb_memo.Text = dt.Rows[0]["MEMO"].ToString();
}
//插入一条记录时显示初始化
private void initInsert()
{
PDM_STRUCT p_struct = new PDM_STRUCT();
p_struct.OBJECTID = m_struct.OBJECTID;
p_struct.ASSOBJECTID = this.m_assojectId;
DataTable dt = m_structService.getStruct(p_struct);
this.tb_assoNum.Text = "";
this.tb_assoWeight.Text = "";
this.tb_sortNum.Text = (Convert.ToInt16(dt.Rows[0]["SORTNUM"].ToString())+1).ToString() ;
this.rtb_memo.Text = "";
}
//判断部件是否包含在产品结构中
private int filterSelect(string p_assoId)
{
PDM_STRUCT t_struct = new PDM_STRUCT();
t_struct.OBJECTID = this.copy_Product.PRODUCTID;
t_struct.ASSOBJECTID = p_assoId;
DataTable dt = m_structService.getStruct(t_struct);
if (dt.Rows.Count > 0)
{
return -1;
}
return 0;
}
/// <summary>
/// 修改产品结构
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void toolStructEdit_Click(object sender, EventArgs e)
{
//1.找出需要修改的产品结构
PDM_STRUCT t_struct = new PDM_STRUCT();
TreeListViewItem item = this.list_productTreeStruct.Items[0];
int count = 0; int index=0;
for (int i = 0; i < item.Items.Count; i++)
{
if (item.Items[i].CheckStatus == CheckState.Checked)
{
count ++;
index = i;
}
}
if (count != 1) {
MessageBox.Show("只能选择一条记录且子结构无法更改！");
return;
}
t_struct.OBJECTID = this.m_product.PRODUCTID;
t_struct.ASSOBJECTID = item.Items[index].Tag.ToString();
//2.记录修改界面传递（关联对象，关联对象ID,操作类型--修改）参数
StructAddForm o = new StructAddForm(t_struct, "", Enum_AssOpType.EDIT);
o.StartPosition = FormStartPosition.CenterParent;
//3.判断是否修改如果修改（清空产品结构树，并重新构造树）
if (o.ShowDialog() == DialogResult.OK)
{
this.list_productTreeStruct.Items.Clear();
list_productTreeStruct_init();
}
}
