public PDM_ALL_PRODUCT GetById(String p_id) { PDM_ALL_PRODUCT t_product = new PDM_ALL_PRODUCT(); string sqlText = "select * from PDM_ALL_PRODUCT where PRODUCTID = '" + p_id + "'"; System.Data.DataTable dt = this.DataAccessor.QueryDataTable(sqlText); if (dt.Rows.Count > 0) { t_product.PRODUCTID = dt.Rows[0]["PRODUCTID"].ToString(); t_product.PRODUCTNO = dt.Rows[0]["PRODUCTNO"].ToString(); t_product.MODELTYPE = dt.Rows[0]["MODELTYPE"].ToString(); t_product.PRODUCTTYPE = dt.Rows[0]["PRODUCTTYPE"].ToString(); t_product.PRODUCTLEVEL = Convert.ToInt16(dt.Rows[0]["PRODUCTLEVEL"].ToString()); t_product.VERSION = dt.Rows[0]["VERSION"].ToString(); t_product.STATUS = dt.Rows[0]["STATUS"].ToString(); t_product.CREATER = dt.Rows[0]["CREATER"].ToString(); t_product.MODIFIER = dt.Rows[0]["MODIFIER"].ToString(); t_product.CREATETIME = dt.Rows[0]["CREATETIME"].ToString(); t_product.MODIFYTIME = dt.Rows[0]["MODIFYTIME"].ToString(); t_product.MEMO_ZH = dt.Rows[0]["MEMO_ZH"].ToString(); t_product.MEMO_EN = dt.Rows[0]["MEMO_EN"].ToString(); t_product.MEMO = dt.Rows[0]["MEMO"].ToString(); } return(t_product); }
private void bt_Query_Click(object sender, EventArgs e) { if (s_type == selectType.Matieral) { this.p_materail = new PDM_MATERAIL(); p_materail.MATERIALNO = this.tb_No.Text; p_materail.MODELTYPE = this.tb_Model.Text; p_materail.VERSION = this.tb_Version.Text; p_materail.MEMO = this.tb_Memo.Text; } else if (s_type == selectType.Parts) { this.p_parts = new PDM_ALL_PRODUCT(); p_parts.PRODUCTNO = this.tb_No.Text; p_parts.MODELTYPE = this.tb_Model.Text; p_parts.VERSION = this.tb_Version.Text; p_parts.MEMO = this.tb_Memo.Text; } else if (s_type == selectType.Product) { this.p_products = new PDM_ALL_PRODUCT(); p_products.PRODUCTNO = this.tb_No.Text; p_products.MODELTYPE = this.tb_Model.Text; p_products.VERSION = this.tb_Version.Text; p_products.MEMO = this.tb_Memo.Text; } this.DialogResult = DialogResult.OK; }
private void query_Product_Click(object sender, EventArgs e) { /*Condition condition = PDM_ALL_PRODUCT.Create().CreateCondition(); if (!string.IsNullOrEmpty(no_Product.Text)) { condition.AddElement("PRODUCTNO", no_Product.Text, ElementType.Match); } if (!string.IsNullOrEmpty(version_Product.Text)) { condition.AddElement("VERSION", version_Product.Text); } if (!string.IsNullOrEmpty(type_Product.Text)) { condition.AddElement("PRODUCTTYPE", type_Product.Text); } if (!string.IsNullOrEmpty(status_Product.Text)) { condition.AddElement("STATUS", status_Product.Text); } if (!string.IsNullOrEmpty(mperson_Product.Text)) { condition.AddElement("MODIFIER", mperson_Product.Text, ElementType.Match); } if (!string.IsNullOrEmpty(modifyDate_Product.Text)) { condition.AddElement("MODIFYTIME", modifyDate_Product.Text); } condition.AddElement("PRODUCTLEVEL", 1); */ PDM_ALL_PRODUCT t_product = new PDM_ALL_PRODUCT(); t_product.PRODUCTNO = no_Product.Text; t_product.VERSION = version_Product.Text; m_productList = m_productService.GetProductList(t_product); this.DialogResult = DialogResult.OK; }
public DocAddForm(String p_ProductId) { InitializeComponent(); m_AllPartsService = EAS.Services.ServiceContainer.GetService<IAllPartsService>(); m_Product = m_AllPartsService.GetById(p_ProductId); this.tsb_type.SelectedIndex = 0; DocList_Init(); }
private void CopyStrut(PDM_ALL_PRODUCT p_OldProduct, PDM_ALL_PRODUCT p_NewProduct) { string sqlText = " INSERT INTO PDM_STRUCT(OBJECTID, ASSOBJECTID, ASSONUM, ASSOWEIGHT, SORTNUM, MEMO,DEL_FLAG) " + " SELECT '" + p_NewProduct.PRODUCTID + "', " + " ASSOBJECTID, ASSONUM, ASSOWEIGHT, SORTNUM, MEMO,DEL_FLAG " + " FROM PDM_STRUCT " + " WHERE DEL_FLAG='N' " + " AND OBJECTID='" + p_OldProduct.PRODUCTID + "' "; this.DataAccessor.Execute(sqlText); }
/// <summary> /// 根据半成品对象更新记录 /// </summary> /// <param name="c"></param> public void UpdateByID(PDM_ALL_PRODUCT c) { string sqlText = "update PDM_ALL_PRODUCT SET PRODUCTNO ='" + c.PRODUCTNO + "'," + "MODELTYPE ='" + c.MODELTYPE + "'," + "PRODUCTTYPE ='" + c.PRODUCTTYPE + "'," + "MEMO_ZH ='" + c.MEMO_ZH + "'," + "MEMO_EN ='" + c.MEMO_EN + "'," + "MEMO ='" + c.MEMO + "'," + "MODIFYTIME ='" + c.MODIFYTIME + "'," + "MODIFIER ='" + c.MODIFIER + "' " + "where PRODUCTID = '" + c.PRODUCTID + "'"; int temp = this.DataAccessor.Execute(sqlText); }
private void CopyDoc(PDM_ALL_PRODUCT p_OldProduct, PDM_ALL_PRODUCT p_NewProduct) { string sqlText = " INSERT INTO ObjectRelation(ORID, MASTEROBJECTID, MASTEROBJECTTYPE, MASTEROBJECTVERSION, RELATIONOBJECTID, RELATIONOBJECTTYPE, RELATIONOBJECTVERSION,OPT1, OPT2, DEL_FALG) " + " SELECT NEWID(), MASTEROBJECTID, MASTEROBJECTTYPE, MASTEROBJECTVERSION, '" + p_NewProduct.PRODUCTID + "', " + " RELATIONOBJECTTYPE, '" + p_NewProduct.VERSION + "'," + " OPT1, OPT2, DEL_FALG " + " FROM ObjectRelation " + " WHERE DEL_FALG ='N' " + " and RELATIONOBJECTID ='" + p_OldProduct.PRODUCTID + "' " + " and RELATIONOBJECTVERSION='" + p_OldProduct.VERSION + "' "; this.DataAccessor.Execute(sqlText); }
private void query_Product_Click(object sender, EventArgs e) { PDM_ALL_PRODUCT t_product = new PDM_ALL_PRODUCT(); t_product.PRODUCTNO = no_Product.Text; t_product.VERSION = version_Product.Text; t_product.PRODUCTTYPE = type_Product.Text; t_product.STATUS = status_Product.Text; t_product.MODIFIER = mperson_Product.Text; t_product.CREATETIME = createDate_Product.Text; t_product.MODIFYTIME = modifyDate_Product.Text; t_product.MODELTYPE = model_Product.Text; m_productList = m_productService.GetProductList(t_product,this.AdvanceQueryString); this.DialogResult = DialogResult.OK; }
/// <summary> /// 初始化 /// </summary> private void common_Init(string p_firstId, string p_secondId) { m_StructService = EAS.Services.ServiceContainer.GetService <IStructService>(); m_AllProductService = EAS.Services.ServiceContainer.GetService <IAllProductService>(); m_firstObj = m_AllProductService.GetById(p_firstId); m_secondObj = m_AllProductService.GetById(p_secondId); this.tb_firstNo.Text = m_firstObj.PRODUCTNO; this.tb_firstMemo.Text = m_firstObj.MEMO_ZH; this.tb_firstVersion.Text = m_firstObj.VERSION; this.tb_secondNo.Text = m_secondObj.PRODUCTNO; this.tb_secondMemo.Text = m_secondObj.MEMO_ZH; this.tb_secondVersion.Text = m_secondObj.VERSION; }
/// <summary> /// 更加对象查询半成品记录 /// </summary> /// <param name="c"></param> /// <returns></returns> public DataTable GetProductList(PDM_ALL_PRODUCT c) { string sqlText = "Select * from PDM_ALL_PRODUCT WHERE PRODUCTLEVEL=2 AND DEL_FLAG = 'N' "; if (!string.IsNullOrEmpty(c.PRODUCTNO)) { sqlText += " AND PRODUCTNO LIKE '%" + c.PRODUCTNO + "%' "; } if (!string.IsNullOrEmpty(c.VERSION)) { sqlText += " AND VERSION LIKE '%" + c.VERSION + "%' "; } System.Data.DataTable dt = this.DataAccessor.QueryDataTable(sqlText); return(dt); }
private void query_Product_Click(object sender, EventArgs e) { PDM_ALL_PRODUCT t_product = new PDM_ALL_PRODUCT(); t_product.PRODUCTNO = no_Product.Text; t_product.VERSION = version_Product.Text; t_product.PRODUCTTYPE = type_Product.Text; t_product.STATUS = status_Product.Text; t_product.MODIFIER = mperson_Product.Text; t_product.CREATETIME = createDate_Product.Text; t_product.MODIFYTIME = modifyDate_Product.Text; t_product.MODELTYPE = model_Product.Text; m_productList = m_productService.GetProductList(t_product, this.AdvanceQueryString); this.DialogResult = DialogResult.OK; }
private void query_Product_Click(object sender, EventArgs e) { Condition condition = PDM_ALL_PRODUCT.Create().CreateCondition(); if (!string.IsNullOrEmpty(no_Product.Text)) { condition.AddElement("PRODUCTNO", no_Product.Text, ElementType.Match); } if (!string.IsNullOrEmpty(version_Product.Text)) { condition.AddElement("VERSION", version_Product.Text); } if (!string.IsNullOrEmpty(type_Product.Text)) { condition.AddElement("PRODUCTTYPE", type_Product.Text); } if (!string.IsNullOrEmpty(status_Product.Text)) { condition.AddElement("STATUS", status_Product.Text); } if (!string.IsNullOrEmpty(mperson_Product.Text)) { condition.AddElement("MODIFIER", mperson_Product.Text, ElementType.Match); } if (!string.IsNullOrEmpty(createDate_Product.Text)) { condition.AddElement("MODIFYTIME", createDate_Product.Text); } condition.AddElement("PRODUCTLEVEL", 2); PDM_ALL_PRODUCT t_product = new PDM_ALL_PRODUCT(); t_product.PRODUCTNO = no_Product.Text; t_product.VERSION = version_Product.Text; t_product.PRODUCTTYPE = type_Product.Text; t_product.STATUS = status_Product.Text; t_product.MODIFIER = mperson_Product.Text; t_product.CREATETIME = createDate_Product.Text; t_product.MODIFYTIME = modifyDate_Product.Text; t_product.MODELTYPE = model_Product.Text; m_partsList = m_partsService.GetProductList(t_product, this.AdvanceQueryString); this.DialogResult = DialogResult.OK; }
public DataTable GetProductList(PDM_ALL_PRODUCT c, String p_partSql) { StringBuilder sb = new StringBuilder(); sb.Append("Select A.* from PDM_ALL_PRODUCT A Left join PDM_Params_DETAIL on PK_VALUE =PRODUCTID where PRODUCTLEVEL=2 AND DEL_FLAG ='N' "); if (!string.IsNullOrEmpty(c.PRODUCTNO)) { sb.Append(" AND PRODUCTNO LIKE '%").Append(c.PRODUCTNO).Append("%' "); } if (!string.IsNullOrEmpty(c.PRODUCTTYPE)) { sb.Append(" AND PRODUCTTYPE LIKE '%").Append(c.PRODUCTTYPE).Append("%' "); } if (!string.IsNullOrEmpty(c.MODELTYPE)) { sb.Append(" AND MODELTYPE LIKE '%").Append(c.MODELTYPE).Append("%' "); } if (!string.IsNullOrEmpty(c.VERSION)) { sb.Append(" AND VERSION LIKE '%").Append(c.VERSION).Append("%' "); } if (!string.IsNullOrEmpty(c.STATUS)) { sb.Append(" AND STATUS LIKE '%").Append(c.STATUS).Append("%' "); } if (!string.IsNullOrEmpty(c.MODIFIER)) { sb.Append(" AND MODIFIER LIKE '%").Append(c.MODIFIER).Append("%' "); } if (!string.IsNullOrEmpty(c.CREATETIME)) { sb.Append(" AND CREATETIME LIKE '%").Append(c.CREATETIME).Append("%' "); } if (!string.IsNullOrEmpty(c.MODIFYTIME)) { sb.Append(" AND MODIFYTIME LIKE '%").Append(c.MODIFYTIME).Append("%' "); } sb.Append(p_partSql); System.Data.DataTable dt = this.DataAccessor.QueryDataTable(sb.ToString()); return(dt); }
/// <summary> /// 调用存储过程,用于插入产品结构时排序的序号加1. /// </summary> /// <param name="p_productId"></param> /// <param name="p_sortNum"></param> public DataSet GetProductByPage(PDM_ALL_PRODUCT c, int currentpage, int pagesize) { string sqlText = "Select * from PDM_ALL_PRODUCT WHERE PRODUCTLEVEL=1 AND DEL_FLAG = 'N' "; if (!string.IsNullOrEmpty(c.PRODUCTNO)) { sqlText += " AND PRODUCTNO LIKE '%" + c.PRODUCTNO + "%' "; } if (!string.IsNullOrEmpty(c.VERSION)) { sqlText += " AND VERSION LIKE '%" + c.VERSION + "%' "; } ParameterCollection pc = new ParameterCollection(); pc.Add("sqlstr", sqlText); pc.Add("currentpage", currentpage); pc.Add("pagesize", pagesize); DataSet ds = this.DataAccessor.QueryDataSet("SqlPager", CommandType.StoredProcedure, pc); return(ds); }
/// <summary> /// 获取符合条件的产成品的列表 /// </summary> /// <param name="p"></param> /// <returns></returns> public DataTable GetPartsList(PDM_ALL_PRODUCT p) { string sqlText = "Select PRODUCTID,PRODUCTNO,MODELTYPE,PRODUCTTYPE from PDM_ALL_PRODUCT WHERE DEL_FLAG='N' AND PRODUCTLEVEL =2 "; if (!string.IsNullOrEmpty(p.PRODUCTNO)) { sqlText += "AND PRODUCTNO like '%" + p.PRODUCTNO + "%' "; } if (!string.IsNullOrEmpty(p.MODELTYPE)) { sqlText += "AND MODELTYPE like '%" + p.MODELTYPE + "%' "; } if (!string.IsNullOrEmpty(p.VERSION)) { sqlText += "AND VERSION like '%" + p.VERSION + "%' "; } if (!string.IsNullOrEmpty(p.MEMO)) { sqlText += "AND MEMO like '%" + p.MEMO + "%' "; } System.Data.DataTable dt = this.DataAccessor.QueryDataTable(sqlText); return(dt); }
/// <summary> /// 基本信息--修改按钮操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void toolBaseEdit_Click(object sender, EventArgs e) { // if (this.m_product == null) { MessageBox.Show("该产品不存在,无法修改!"); return; } //判断是否需要修改 if (MessageBox.Show("您确认要修改此产品基本信息?", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No) { return; } //1.更新数据库产品基本信息记录 PDM_ALL_PRODUCT t_product = new PDM_ALL_PRODUCT(); t_product.PRODUCTID = this.m_product.PRODUCTID; t_product.PRODUCTNO = this.tb_productNo.Text; t_product.MODELTYPE = this.tb_modelType.Text; t_product.PRODUCTTYPE = this.tb_productType.Text; t_product.MEMO_ZH = this.tb_memoZh.Text; t_product.MEMO_EN = this.tb_memoEn.Text; t_product.MEMO = this.rtbMemo.Text; t_product.MODIFYTIME = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); t_product.MODIFIER = this.LoginInfo.LoginID; m_AllProductService.UpdateByID(t_product); //2.基本信息改变后更新基本信息显示 this.tb_modifyTime.Text = t_product.MODIFYTIME; this.tb_modifier.Text = t_product.MODIFIER; //3.更新(派生历史记录,ERC,文档,图纸,技术任务单,产品结构,版本)等tab页面列表显示,更新基本属性信息 this.m_product = m_AllProductService.GetById(t_product.PRODUCTID); allinit(); }
private void query_Product_Click(object sender, EventArgs e) { /*Condition condition = PDM_ALL_PRODUCT.Create().CreateCondition(); * if (!string.IsNullOrEmpty(no_Product.Text)) * { * condition.AddElement("PRODUCTNO", no_Product.Text, ElementType.Match); * } * if (!string.IsNullOrEmpty(version_Product.Text)) * { * condition.AddElement("VERSION", version_Product.Text); * } * if (!string.IsNullOrEmpty(type_Product.Text)) * { * condition.AddElement("PRODUCTTYPE", type_Product.Text); * } * if (!string.IsNullOrEmpty(status_Product.Text)) * { * condition.AddElement("STATUS", status_Product.Text); * } * if (!string.IsNullOrEmpty(mperson_Product.Text)) * { * condition.AddElement("MODIFIER", mperson_Product.Text, ElementType.Match); * } * if (!string.IsNullOrEmpty(modifyDate_Product.Text)) * { * condition.AddElement("MODIFYTIME", modifyDate_Product.Text); * } * condition.AddElement("PRODUCTLEVEL", 1); */ PDM_ALL_PRODUCT t_product = new PDM_ALL_PRODUCT(); t_product.PRODUCTNO = no_Product.Text; t_product.VERSION = version_Product.Text; m_productList = m_productService.GetProductList(t_product); this.DialogResult = DialogResult.OK; }
public DataTable GetProductList(PDM_ALL_PRODUCT c, String p_partSql) { StringBuilder sb = new StringBuilder(); sb.Append("Select A.* from PDM_ALL_PRODUCT A Left join PDM_Params_DETAIL on PK_VALUE =PRODUCTID where PRODUCTLEVEL=2 AND DEL_FLAG ='N' "); if (!string.IsNullOrEmpty(c.PRODUCTNO)) { sb.Append(" AND PRODUCTNO LIKE '%").Append(c.PRODUCTNO).Append("%' "); } if (!string.IsNullOrEmpty(c.PRODUCTTYPE)) { sb.Append(" AND PRODUCTTYPE LIKE '%").Append(c.PRODUCTTYPE).Append("%' "); } if (!string.IsNullOrEmpty(c.MODELTYPE)) { sb.Append(" AND MODELTYPE LIKE '%").Append(c.MODELTYPE).Append("%' "); } if (!string.IsNullOrEmpty(c.VERSION)) { sb.Append(" AND VERSION LIKE '%").Append(c.VERSION).Append("%' "); } if (!string.IsNullOrEmpty(c.STATUS)) { sb.Append(" AND STATUS LIKE '%").Append(c.STATUS).Append("%' "); } if (!string.IsNullOrEmpty(c.MODIFIER)) { sb.Append(" AND MODIFIER LIKE '%").Append(c.MODIFIER).Append("%' "); } if (!string.IsNullOrEmpty(c.CREATETIME)) { sb.Append(" AND CREATETIME LIKE '%").Append(c.CREATETIME).Append("%' "); } if (!string.IsNullOrEmpty(c.MODIFYTIME)) { sb.Append(" AND MODIFYTIME LIKE '%").Append(c.MODIFYTIME).Append("%' "); } sb.Append(p_partSql); System.Data.DataTable dt = this.DataAccessor.QueryDataTable(sb.ToString()); return dt; }
/// <summary> /// 初始化 /// </summary> private void common_Init(string p_firstId, string p_secondId) { m_StructService = EAS.Services.ServiceContainer.GetService<IStructService>(); m_AllProductService = EAS.Services.ServiceContainer.GetService<IAllProductService>(); m_firstObj = m_AllProductService.GetById(p_firstId); m_secondObj = m_AllProductService.GetById(p_secondId); this.tb_firstNo.Text = m_firstObj.PRODUCTNO; this.tb_firstMemo.Text = m_firstObj.MEMO_ZH; this.tb_firstVersion.Text = m_firstObj.VERSION; this.tb_secondNo.Text = m_secondObj.PRODUCTNO; this.tb_secondMemo.Text = m_secondObj.MEMO_ZH; this.tb_secondVersion.Text = m_secondObj.VERSION; }
public PDM_ALL_PRODUCT GetById(String p_id) { PDM_ALL_PRODUCT t_product = new PDM_ALL_PRODUCT(); string sqlText = "select * from PDM_ALL_PRODUCT where PRODUCTID = '" + p_id + "'"; System.Data.DataTable dt = this.DataAccessor.QueryDataTable(sqlText); if(dt.Rows.Count>0){ t_product.PRODUCTID = dt.Rows[0]["PRODUCTID"].ToString(); t_product.PRODUCTNO = dt.Rows[0]["PRODUCTNO"].ToString(); t_product.MODELTYPE = dt.Rows[0]["MODELTYPE"].ToString(); t_product.PRODUCTTYPE = dt.Rows[0]["PRODUCTTYPE"].ToString(); t_product.PRODUCTLEVEL = Convert.ToInt16(dt.Rows[0]["PRODUCTLEVEL"].ToString()); t_product.VERSION = dt.Rows[0]["VERSION"].ToString(); t_product.STATUS = dt.Rows[0]["STATUS"].ToString(); t_product.CREATER = dt.Rows[0]["CREATER"].ToString(); t_product.MODIFIER = dt.Rows[0]["MODIFIER"].ToString(); t_product.CREATETIME = dt.Rows[0]["CREATETIME"].ToString(); t_product.MODIFYTIME = dt.Rows[0]["MODIFYTIME"].ToString(); t_product.MEMO_ZH = dt.Rows[0]["MEMO_ZH"].ToString(); t_product.MEMO_EN = dt.Rows[0]["MEMO_EN"].ToString(); t_product.MEMO = dt.Rows[0]["MEMO"].ToString(); } return t_product; }
/// <summary> /// 调用存储过程,用于插入产品结构时排序的序号加1. /// </summary> /// <param name="p_productId"></param> /// <param name="p_sortNum"></param> public DataSet GetProductByPage(PDM_ALL_PRODUCT c,int currentpage, int pagesize) { string sqlText = "Select * from PDM_ALL_PRODUCT WHERE PRODUCTLEVEL=1 AND DEL_FLAG = 'N' "; if (!string.IsNullOrEmpty(c.PRODUCTNO)) { sqlText += " AND PRODUCTNO LIKE '%" + c.PRODUCTNO + "%' "; } if (!string.IsNullOrEmpty(c.VERSION)) { sqlText += " AND VERSION LIKE '%" + c.VERSION + "%' "; } ParameterCollection pc = new ParameterCollection(); pc.Add("sqlstr", sqlText); pc.Add("currentpage", currentpage); pc.Add("pagesize", pagesize); DataSet ds = this.DataAccessor.QueryDataSet("SqlPager", CommandType.StoredProcedure, pc); return ds; }
//简单查询按钮操作 private void toolQuery_Click(object sender, EventArgs e) { if (this.toolProValue.Text.Equals("请输入属性值")) { MessageBox.Show("请输入属性值"); return; } if (this.dgv_MaterialList.Visible) { PDM_MATERAIL p_materail = new PDM_MATERAIL(); if (this.toolProComb.Text == "编号") { p_materail.MATERIALNO = this.toolProValue.Text; } else if (this.toolProComb.Text.ToString().Equals("型号")) { p_materail.MODELTYPE = this.toolProValue.Text; } else if (this.toolProComb.Text == "版本") { p_materail.VERSION = this.toolProValue.Text; } else if (this.toolProComb.Text.ToString().Equals("描述")) { p_materail.MEMO = this.toolProValue.Text; } this.dgv_MaterialList.DataSource = m_structService.GetMaterailList(p_materail); } else if (this.dgv_PartsList.Visible) { PDM_ALL_PRODUCT p_parts = new PDM_ALL_PRODUCT(); if (this.toolProComb.Text == "编号") { p_parts.PRODUCTNO = this.toolProValue.Text; } else if (this.toolProComb.Text.ToString().Equals("型号")) { p_parts.MODELTYPE = this.toolProValue.Text; } else if (this.toolProComb.Text == "版本") { p_parts.VERSION = this.toolProValue.Text; } else if (this.toolProComb.Text.ToString().Equals("描述")) { p_parts.MEMO = this.toolProValue.Text; } this.dgv_PartsList.DataSource = m_structService.GetPartsList(p_parts); } else if (this.dgv_productList.Visible) { PDM_ALL_PRODUCT p_products = new PDM_ALL_PRODUCT(); if (this.toolProComb.Text == "编号") { p_products.PRODUCTNO = this.toolProValue.Text; } else if (this.toolProComb.Text.ToString().Equals("型号")) { p_products.MODELTYPE = this.toolProValue.Text; } else if (this.toolProComb.Text == "版本") { p_products.VERSION = this.toolProValue.Text; } else if (this.toolProComb.Text.ToString().Equals("描述")) { p_products.MEMO = this.toolProValue.Text; } this.dgv_productList.DataSource = m_structService.GetProductList(p_products); } }
//产品列表数据初始化 private void dgvProductListInit() { HYPDM.Entities.PDM_ALL_PRODUCT t = new PDM_ALL_PRODUCT(); this.dgv_productList.DataSource = m_structService.GetProductList(t); }
//简单查询按钮操作 private void toolQuery_Click(object sender, EventArgs e) { if (this.toolProValue.Text.Equals("请输入属性值")) { MessageBox.Show("请输入属性值"); return; } if (this.dgv_MaterialList.Visible) { PDM_MATERAIL p_materail = new PDM_MATERAIL(); if (this.toolProComb.Text == "编号") { p_materail.MATERIALNO = this.toolProValue.Text; } else if (this.toolProComb.Text.ToString().Equals("型号")) { p_materail.MODELTYPE = this.toolProValue.Text; } else if (this.toolProComb.Text == "版本") { p_materail.VERSION = this.toolProValue.Text; } else if (this.toolProComb.Text.ToString().Equals("描述")) { p_materail.MEMO = this.toolProValue.Text; } this.dgv_MaterialList.DataSource=m_structService.GetMaterailList(p_materail); }else if(this.dgv_PartsList.Visible) { PDM_ALL_PRODUCT p_parts = new PDM_ALL_PRODUCT(); if (this.toolProComb.Text == "编号") { p_parts.PRODUCTNO = this.toolProValue.Text; } else if (this.toolProComb.Text.ToString().Equals("型号")) { p_parts.MODELTYPE = this.toolProValue.Text; } else if (this.toolProComb.Text == "版本") { p_parts.VERSION = this.toolProValue.Text; } else if (this.toolProComb.Text.ToString().Equals("描述")) { p_parts.MEMO = this.toolProValue.Text; } this.dgv_PartsList.DataSource=m_structService.GetPartsList(p_parts); } else if (this.dgv_productList.Visible) { PDM_ALL_PRODUCT p_products = new PDM_ALL_PRODUCT(); if (this.toolProComb.Text == "编号") { p_products.PRODUCTNO = this.toolProValue.Text; } else if (this.toolProComb.Text.ToString().Equals("型号")) { p_products.MODELTYPE = this.toolProValue.Text; } else if (this.toolProComb.Text == "版本") { p_products.VERSION = this.toolProValue.Text; } else if (this.toolProComb.Text.ToString().Equals("描述")) { p_products.MEMO = this.toolProValue.Text; } this.dgv_productList.DataSource= m_structService.GetProductList(p_products); } }
/// <summary> /// 更加对象查询半成品记录 /// </summary> /// <param name="c"></param> /// <returns></returns> public DataTable GetProductList(PDM_ALL_PRODUCT c) { string sqlText = "Select * from PDM_ALL_PRODUCT WHERE PRODUCTLEVEL=2 AND DEL_FLAG = 'N' "; if (!string.IsNullOrEmpty(c.PRODUCTNO)) { sqlText += " AND PRODUCTNO LIKE '%" + c.PRODUCTNO + "%' "; } if (!string.IsNullOrEmpty(c.VERSION)) { sqlText += " AND VERSION LIKE '%" + c.VERSION + "%' "; } System.Data.DataTable dt = this.DataAccessor.QueryDataTable(sqlText); return dt; }
/// <summary> /// 获取符合条件的产品的列表 /// </summary> /// <param name="p"></param> /// <returns></returns> public DataTable GetProductList(PDM_ALL_PRODUCT p) { string sqlText = "Select PRODUCTID,PRODUCTNO,MODELTYPE,PRODUCTTYPE from PDM_ALL_PRODUCT WHERE DEL_FLAG='N' AND PRODUCTLEVEL =1 "; if (!string.IsNullOrEmpty(p.PRODUCTNO)) { sqlText += "AND PRODUCTNO like '%" + p.PRODUCTNO + "%' "; } if (!string.IsNullOrEmpty(p.MODELTYPE)) { sqlText += "AND MODELTYPE like '%" + p.MODELTYPE + "%' "; } if (!string.IsNullOrEmpty(p.VERSION)) { sqlText += "AND VERSION like '%" + p.VERSION + "%' "; } if (!string.IsNullOrEmpty(p.MEMO)) { sqlText += "AND MEMO like '%" + p.MEMO + "%' "; } System.Data.DataTable dt = this.DataAccessor.QueryDataTable(sqlText); return dt; }
/********************************************************/ /**************** 复制产品结构操作 *******************/ /********************************************************/ public void CopyAllAsso(PDM_ALL_PRODUCT p_OldProduct, PDM_ALL_PRODUCT p_NewProduct) { CopyStrut(p_OldProduct, p_NewProduct); CopyDoc(p_OldProduct, p_NewProduct); }
/// <summary> /// 根据半成品对象更新记录 /// </summary> /// <param name="c"></param> public void UpdateByID(PDM_ALL_PRODUCT c) { string sqlText = "update PDM_ALL_PRODUCT SET PRODUCTNO ='" +c.PRODUCTNO+"'," + "MODELTYPE ='" + c.MODELTYPE + "'," + "PRODUCTTYPE ='" + c.PRODUCTTYPE + "'," + "MEMO_ZH ='" + c.MEMO_ZH + "'," + "MEMO_EN ='" + c.MEMO_EN + "'," + "MEMO ='" + c.MEMO + "'," + "MODIFYTIME ='" + c.MODIFYTIME + "'," + "MODIFIER ='" + c.MODIFIER + "' " + "where PRODUCTID = '" + c.PRODUCTID + "'"; int temp = this.DataAccessor.Execute(sqlText); }
//半成品列表数据初始化 private void dgvPartsListInit() { HYPDM.Entities.PDM_ALL_PRODUCT t = new PDM_ALL_PRODUCT(); this.dgv_PartsList.DataSource = m_structService.GetPartsList(t); }