private void MaterialRationAdd_Load(object sender, EventArgs e) { ProjectCmbItem.ProjectCmbBind(cmb_project); //ProjectCmbItem.ReasonCmbBind(cmb_reason); //ProjectCmbItem.SiteCmbBind(cmb_site2); ProjectCmbItem.SiteCmbBind(cmb_site); ProjectCmbItem.BindDisciplineName(cmb_discipline); //ProjectCmbItem.BindDiscipline(cmb_discipline2); ecprojectid = ProjectSystem.FindProjectid(ProjectId).ToString(); UnitCmbBind(); ReasonCmbBind(); listviewTitleBind(); if (MEOID == "0") { btn_save.Enabled = true; btn_select.Enabled = true; } else { if (MEOSTATE == "1") { btn_save.Enabled = true; btn_select.Enabled = true; } } }
private void MaterialRequireAdd_Load(object sender, EventArgs e) { ProjectCmbItem.ProjectCmbBind(cmb_project); ProjectCmbItem.ReasonCmbBind(cmb_reason); ProjectCmbItem.SiteCmbBind(cmb_site2); ProjectCmbItem.SiteCmbBind(cmb_site); ProjectCmbItem.BindDiscipline(cmb_discipline); ProjectCmbItem.BindDiscipline(cmb_discipline2); UnitCmbBind(); ReasonCmbBind(); listviewTitleBind(); if (MEOID == "0") { btn_save.Enabled = true; btn_select.Enabled = true; } else { if (MEOSTATE == "1") { btn_save.Enabled = true; btn_select.Enabled = true; } } }
private void button2_Click(object sender, EventArgs e) { //MessageBox.Show("1.首先检查要导入的Excel数据中ERP代码是否在ERP系统中存在;\n2.将该项目该专业的原先的预估数据历史保存,然后将新数据写入数据库;\n3.完成导入;","实现步骤说明"); mSite = cmb_site.SelectedValue.ToString(); DisciplineId = cmb_dpname.SelectedValue.ToString(); ProjectCmbItem item = (ProjectCmbItem)cmb_project.SelectedItem; if (item == null) { MessageBox.Show("请选择项目", "提示"); return; } if (mSite == string.Empty) { MessageBox.Show("请选择域"); return; } if (DisciplineId == string.Empty) { MessageBox.Show("请选择专业"); return; } ProjectId = item.Value; if (dgv2.Rows.Count > 0) { CheckImportDataHanlder CheckData = new CheckImportDataHanlder(CheckImportData); CheckData.BeginInvoke(null, null); } }
private void Form1_Load(object sender, EventArgs e) { ProjectCmbItem.ProjectCmbBind(cmb_project); ProjectCmbItem.ReasonCmbBind(cmb_reason); ProjectCmbItem.SiteCmbBind(cmb_site2); ProjectCmbItem.ProjectCmbBind(cmb_project); ProjectCmbItem.BindDiscipline(cmb_discipline2); }
private void ConvertStandard_Load(object sender, EventArgs e) { ProjectCmbItem.ProjectCmbBind(cmb_project); //ProjectCmbItem.ReasonCmbBind(cmb_reason); ProjectCmbItem.SiteCmbBind(cmb_site); Str_FX = XmlOper.getXMLContent("Fx"); Str_Discipline = XmlOper.getXMLContent("Discipline"); ActivityName = XmlOper.getXMLContent("Parttype"); }
private void MaterialRationForm_Load(object sender, EventArgs e) { ProjectCmbItem.SiteCmbBind(cmb_site); Str_FX = XmlOper.getXMLContent("Fx"); ActivityName = XmlOper.getXMLContent("Parttype"); Str_Discipline = XmlOper.getXMLContent("Discipline"); DataSet MyDs = GetMaterialRationDS("SP_GETMATERIALRATION", projectid, drawing, indicator); this.dgv1.DataSource = MyDs.Tables[0].DefaultView; MyDs.Dispose(); }
private void MISC_PROCUREMENT_Query_Load(object sender, EventArgs e) { // TODO: 这行代码将数据加载到表“dataSet1.MM_PART_REQUIRE_VIEW”中。您可以根据需要移动或移除它。 //this.mM_PART_REQUIRE_VIEWTableAdapter.Fill(this.dataSet1.MM_PART_REQUIRE_VIEW); ProjectCmbItem.ProjectCmbBind(cmb_project); ProjectCmbItem.ReasonCmbBind(cmb_reason); ProjectCmbItem.SiteCmbBind(cmb_site2); ProjectCmbItem.ProjectCmbBind(cmb_project); ProjectCmbItem.BindDiscipline(cmb_discipline2); BindPartNobyAct(); }
private void frmPartParaList_Load(object sender, EventArgs e) { //ProjectCmbBind(); //取出所有零件类别 ecprojectid = ProjectSystem.FindProjectid(ProjectId); string sqlstr = "select typeid,type_desc from mm_part_type_tab where parent_id<>0"; ProjectCmbItem.ProjectCmbBind(cmb_project); ProjectCmbItem.BindDiscipline(cmb_dpname); ProjectCmbItem.SiteCmbBind(cmb_site); //QuerydataBindpara(); }
/// <summary> /// 更换项目时重新构建项目结构树 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cmb_project_SelectedIndexChanged(object sender, EventArgs e) { ProjectCmbItem item = (ProjectCmbItem)cmb_project.SelectedItem; if (item == null) { MessageBox.Show("请选择项目", "提示"); return; } ProjectId = item.Value; ecprojectid = ProjectSystem.FindProjectid(ProjectId).ToString(); ProjectCmbItem.BlockBind(cmb_block, ecprojectid); }
/// <summary> /// 查找材料以及库存 /// </summary> public void QuerydataBind() { //string ProjectId = cmb_project.SelectedValue.ToString(); site = cmb_site.SelectedValue.ToString(); string partno = cmb_partno.Text.Trim().ToString(); string parttype = tb_type.Text.Trim().ToString(); string projectname = string.Empty; string designcode = tb_designcode.Text.Trim(); ProjectCmbItem item = (ProjectCmbItem)cmb_project.SelectedItem; if (item != null) { projectname = item.Value; } else { MessageBox.Show("请选择项目!", "查询提醒"); return; } if (string.IsNullOrEmpty(partno) && string.IsNullOrEmpty(parttype)) { MessageBox.Show("请输入零件编码或者零件描述!", "查询提醒"); return; } string sprojectname = projectname.Substring(projectname.Length - 3, 3); StringBuilder sb = new StringBuilder(); if (site != string.Empty) { sb.Append(" AND CONTRACT = '" + site + "'"); } if (partno != string.Empty) { sb.Append(" AND part_no like '" + partno + "%'"); } if (parttype != string.Empty) { sb.Append(" AND description like'" + parttype + "%'"); } //if (designcode != string.Empty) sb.Append(" AND design_code like'" + designcode + "%'"); //string sqlSelect = "SELECT '','',pp.*,'' FROM PLM.MM_PART_TAB pp WHERE 1=1 and parentid= " + activity; string sqlSelect = "select p.contract 域,p.part_no 零件号,p.description 零件描述,p.unit_meas 单位,nvl((select sum(tt.qty_onhand - tt.qty_reserved) from ifsapp.yr_inv_on_hand_vw tt WHERE tt.part_no = p.part_no and tt.contract = '03' and tt.req_dept like 'YL" + sprojectname + "%'), 0) 项目预留可用,nvl((select sum(REQUIRE_QTY ) from IFSAPP.PROJECT_MISC_PROCUREMENT where design_code like '%" + designcode + "%' and PROJECT_ID = '" + projectname + "' and site = '03' and issue_from_inv = 0 and PART_NO = p.part_no and (select state from ifsapp.purchase_req_line_part q where q.requisition_no =p_requisition_no and q.part_no=p.part_no) <>'Cancelled' ),0) 申请数量,nvl((select sum(IFSAPP.PROJ_PROCU_RATION_API.Get_Accu_Ration_Qty(MATR_SEQ_NO)) from IFSAPP.PROJECT_MISC_PROCUREMENT where design_code like '%" + designcode + "%' and PROJECT_ID = '" + projectname + "' and site = '03' and issue_from_inv = 0 and PART_NO = p.part_no and (select state from ifsapp.purchase_req_line_part q where q.requisition_no =p_requisition_no and q.part_no=p.part_no) <>'Cancelled'),0) 已下发数量,nvl((select sum(REQUIRE_QTY -IFSAPP.PROJ_PROCU_RATION_API.Get_Accu_Ration_Qty(MATR_SEQ_NO)) from IFSAPP.PROJECT_MISC_PROCUREMENT where design_code like '%" + designcode + "%' and PROJECT_ID = '" + projectname + "' and site = '03' and issue_from_inv = 0 and PART_NO = p.part_no and (select state from ifsapp.purchase_req_line_part q where q.requisition_no =p_requisition_no and q.part_no=p.part_no) <>'Cancelled'),0) 余下申请数量,nvl((select sum(tt.qty_onhand ) from ifsapp.yr_inv_on_hand_vw tt WHERE tt.part_no = p.part_no and tt.contract = '03' and tt.req_dept like 'YL" + sprojectname + "%'), 0) 项目预留 from ifsapp.inventory_part p where p.part_status='A' "; string wheresql = sb.ToString(); sqlSelect = sqlSelect + wheresql + "order by p.part_no"; listviewBind(sqlSelect); }
/// <summary> /// 获取ERP中项目列表 /// </summary> public void ProjectCmbBind() { cmb_project.AutoCompleteSource = AutoCompleteSource.ListItems; cmb_project.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cmb_project.Items.Clear(); DataSet PartDS = project.FindProDataset(); DataTable dt = PartDS.Tables[0]; foreach (DataRow row in dt.Rows) { ProjectCmbItem item = new ProjectCmbItem(row["description"].ToString(), row["project_id"].ToString()); cmb_project.Items.Add(item); } //ProjectCmbItem itemn = new ProjectCmbItem("COSLProspector 半潜式钻井平台", "YCRO11-256"); ////cmb_project.SelectedIndex = 7; //cmb_project.SelectedItem = itemn; }
private void dgv1_DoubleClick(object sender, EventArgs e) { if (dgv1.RowCount > 0) { foreach (Form form in this.ParentForm.MdiChildren) { if (form.Text == "材料维护页面") { if (form.WindowState == FormWindowState.Minimized) { form.WindowState = FormWindowState.Normal; } form.Activate(); return; } } string project_name = ""; string site_no = dgv1.CurrentRow.Cells["域"].Value.ToString(); string partno = dgv1.CurrentRow.Cells["零件号"].Value.ToString(); string partname = dgv1.CurrentRow.Cells["零件描述"].Value.ToString(); string designcode = tb_designcode.Text.Trim(); ProjectCmbItem item = (ProjectCmbItem)cmb_project.SelectedItem; if (item != null) { project_name = item.Value; } else { MessageBox.Show("请选择项目!", "查询提醒"); return; } DetailInfo.MaterialManage.MaterialDetail detailform = new DetailInfo.MaterialManage.MaterialDetail(project_name, partno, partname, site_no, designcode); detailform.Text = "材料详情页面"; detailform.MdiParent = this.MdiParent; detailform.Show(); } else { return; } }
private void button1_Click(object sender, EventArgs e) { ProjectCmbItem item = (ProjectCmbItem)cmb_project.SelectedItem; if (item == null) { MessageBox.Show("请选择项目", "提示"); return; } ProjectId = item.Value; Site = cmb_site.SelectedValue.ToString(); openFileDialog1.Filter = "xls files|*.xlsx"; if (openFileDialog1.ShowDialog() == DialogResult.OK) { string aimfile = openFileDialog1.FileName.ToString(); //MessageBox.Show(aimfile); textBox1.Text = aimfile; //getconnect(aimfile, "Sheet1"); dgv1.DataMember = "[定 额 表$]"; dgv1.DataSource = getconnect(aimfile, "定 额 表"); dgv1.Columns[0].ReadOnly = true; dgv1.Columns[1].ReadOnly = true; dgv1.Columns[2].ReadOnly = true; dgv1.Columns[3].ReadOnly = true; dgv1.Columns[4].ReadOnly = true; dgv1.Columns[5].ReadOnly = true; dgv1.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv1.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv1.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv1.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; //读取excel 文件 } else { } }
private void button1_Click_1(object sender, EventArgs e) { mSite = cmb_site.SelectedValue.ToString(); if (mSite == string.Empty) { MessageBox.Show("请选择域"); return; } ProjectCmbItem item = (ProjectCmbItem)cmb_project.SelectedItem; if (item == null) { MessageBox.Show("请选择项目", "提示"); return; } ProjectId = item.Value; #region 如果选择区域和专业 那么按照此专业或者区域进行汇总预估数据 QuerydataBindpara(); #endregion #region 如果没有选择区域和专业 那么按照不进行汇总预估数据 QuerydataBindpara(); #endregion }
/// <summary> /// 更换项目时重新构建项目结构树 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cmb_project_SelectedIndexChanged(object sender, EventArgs e) { tvMType.Nodes.Clear(); tn = new TreeNode(); ProjectCmbItem item = (ProjectCmbItem)cmb_project.SelectedItem; if (item == null) { MessageBox.Show("请选择项目", "提示"); return; } ProjectId = item.Value; tn.Tag = ProjectId; project p = project.Find(ProjectId); if (p != null) { tn.Text = p.description; tn.ImageIndex = 3; tn.SelectedImageIndex = 3; } else { tn.Text = "项目"; } this.tvMType.Nodes.Add(tn); ecprojectid = ProjectSystem.FindProjectid(ProjectId).ToString(); DataTable dt = new DataTable(); DataTable dtact = new DataTable(); //int projectid = ProjectSystem.FindProjectid(ProjectId); dt = SubProject.FindAllSubPro(ProjectId).Tables[0]; dtact = Activity.FindActivityDs(ProjectId).Tables[0]; //string virroot = ProjectSystem.GetProName(projectID); CreateTreeViewRecursiveNew(tn, dt, dtact, "0"); ProjectCmbItem.BlockBind(cmb_block, ecprojectid); }
public void listviewBind(string sql) { //更改并设置列名称以及属性 DataSet ds = PartParameter.QueryPartPara(sql); dgv1.DataSource = ds.Tables[0]; //DataGridViewComboBoxColumn dgvcom = new DataGridViewComboBoxColumn(); //dgvcom.DataSource = PartParameter.QueryPartPara("select name from mm_unit_tab").Tables[0].DefaultView;; //dgvcom.DisplayMember = "name"; //dgvcom.ValueMember = "name"; ////dgv1.Columns.Insert(1, dgvcom); //dgv1.GridColumnStyles[1]=dgvcom; //dgv1.Columns["零件认证"].Width = 100; //dgv1.Columns["单位密度"].ValueType = typeof(); //dgv1.Columns["零件材质"].ValueType = typeof(float); dgv1.Columns["域"].ReadOnly = true; dgv1.Columns["序号"].ReadOnly = true; dgv1.Columns["零件号"].ReadOnly = true; //dgv1.Columns["零件类别"].ReadOnly = true; //dgv1.Columns["零件规格"].ReadOnly = true; //dgv1.Columns["材质"].ReadOnly = true; //dgv1.Columns["证书"].ReadOnly = true; //dgv1.Columns["单位"].ReadOnly = true; dgv1.Columns["parentid"].Visible = false; #region 将库存值填入表格 if (cb_showqty.Checked == true) { dgv1.Columns["项目预留数量"].ReadOnly = true; dgv1.Columns["项目采购数量"].ReadOnly = true; dgv1.Columns["项目可用库存量"].ReadOnly = true; if (dgv1.RowCount != 0) { ProjectCmbItem item = (ProjectCmbItem)cmb_project.SelectedItem; if (item == null) { MessageBox.Show("请选择所查询的项目"); return; } string projectname = item.Value; for (int i = 0; i < dgv1.Rows.Count; i++) { string partno = dgv1.Rows[i].Cells["零件号"].Value.ToString(); InventoryPart part_kucun = InventoryPart.GetOnhandqty(site, partno, projectname.Substring(projectname.Length - 3, 3));; if (part_kucun != null) { dgv1.Rows[i].Cells["项目可用库存量"].Value = part_kucun.qty_onhand; dgv1.Rows[i].Cells["项目采购数量"].Value = Convert.ToDecimal(part_kucun.qty_onhand) - Convert.ToDecimal(part_kucun.qty_reserved); dgv1.Rows[i].Cells["项目预留数量"].Value = part_kucun.qty_reserved; } else { dgv1.Rows[i].Cells["预估量"].Value = 0; //dgv1.Rows[i].Cells[2].Value = "M"; } } //} } } #endregion //#region 设置列的只读性 //int specnum = PartParameter.GetSpecCou(activity); //if (specnum != 0) //{ // if (specnum > 0) // { // string colstr = PartParameter.GetSpecName(activity, "1").Trim(); // dgv1.Columns[colstr].ReadOnly = true; // } // if (specnum > 1) // { // string colstr = PartParameter.GetSpecName(activity, "2").Trim(); // dgv1.Columns[colstr].ReadOnly = true; // } // if (specnum > 2) // { // string colstr = PartParameter.GetSpecName(activity, "3").Trim(); // dgv1.Columns[colstr].ReadOnly = true; // } // if (specnum > 3) // { // string colstr = PartParameter.GetSpecName(activity, "4").Trim(); // dgv1.Columns[colstr].ReadOnly = true; // } //} //#endregion #region 将已设置过的预估值填入表格 //if (dgv1.RowCount != 0) //{ // List<PartParameter> pp = PartParameter.FindPartList(activity, ProjectId,LoginUser,1); // //if (pp.Count != 0) // // { // for (int i = 0; i < dgv1.Rows.Count; i++) // { // int partid = int.Parse(dgv1.Rows[i].Cells["序号"].Value.ToString()); // PartParameter pone = pp.Find(delegate(PartParameter bb) { return bb.ID == partid; }); // if (pone != null) // { // dgv1.Rows[i].Cells["预估量"].Value = pone.PREDICTION_QTY; // //dgv1.Rows[i].Cells[2].Value = pone.UNIT; // } // else // { // dgv1.Rows[i].Cells["预估量"].Value = 0; // //dgv1.Rows[i].Cells[2].Value = "M"; // } // } // //} //} #endregion }
private void M_Estimate_Load(object sender, EventArgs e) { ProjectCmbItem.ProjectCmbBind(cmb_project); ProjectCmbItem.BindDiscipline(cmb_dpname); ProjectCmbItem.SiteCmbBind(cmb_site); }
private void btn_query_Click(object sender, EventArgs e) { ProjectCmbItem item = (ProjectCmbItem)cmb_project.SelectedItem; if (item == null) { MessageBox.Show("请选择项目", "提示"); return; } Projectid = item.Value; if (Projectid == string.Empty) { MessageBox.Show("请选择项目"); return; } mSite = cmb_site2.SelectedValue.ToString(); string meono = txt_meono.Text.Trim().ToLower(); string partno = cmb_partno.Text.Trim().ToString().ToLower(); string PartName = cmb_partname.Text.Trim().ToString().ToLower(); string ReqDateFrom = dateTimePicker3.Checked == true?dateTimePicker3.Value.ToString("yyyy-MM-dd") : string.Empty; string ReqDateTo = dateTimePicker4.Checked == true?dateTimePicker4.Value.ToString("yyyy-MM-dd") : string.Empty; string CreateDateFrom = dateTimePicker1.Checked == true?dateTimePicker1.Value.ToString("yyyy-MM-dd") : string.Empty; string CreateDateTo = dateTimePicker2.Checked == true?dateTimePicker2.Value.ToString("yyyy-MM-dd") : string.Empty; //ReasonCode Ritem = (ReasonCode)cmb_reason.SelectedValue; string ReasonCode = cmb_reason.SelectedValue.ToString(); string DesignCode = txt_designcode.Text.Trim().ToString().ToLower(); string Creator = txt_creator.Text.Trim().ToString().ToLower(); string meostate = cmb_state.Text == null ? "" : cmb_state.Text; string manualno = tb_manual.Text.Trim().ToLower(); StringBuilder sb = new StringBuilder(); if (meostate != string.Empty && meostate != null) { sb.Append(meostate == "已审核" ? " and state='4'" : "and state='1'"); } if (meono != string.Empty) { sb.Append(" and MEO_ERP like '%" + meono + "%'"); } if (Projectid != string.Empty) { sb.Append(" AND PROJECT_ID = '" + Projectid + "'"); } if (partno != string.Empty) { sb.Append(" AND lower(part_no) like '%" + partno + "%'"); } if (PartName != string.Empty) { sb.Append(" AND lower(part_name) like'%" + PartName + "%'"); } if (Creator != string.Empty) { sb.Append(" AND lower(CREATER) like'%" + Creator + "%'"); } if (manualno != string.Empty) { sb.Append(" AND lower(require_no) like'%" + manualno + "%'"); } if (ReasonCode != string.Empty) { sb.Append(" AND REASON_CODE ='" + ReasonCode + "'"); } if (DesignCode != string.Empty) { sb.Append(" AND lower(DESIGN_CODE) like'%" + DesignCode + "%'"); } if (ReqDateFrom != string.Empty) { sb.Append(" and REQUIRE_DATE>=" + Util.GetOracelDateSql(ReqDateFrom)); } if (ReqDateTo != string.Empty) { sb.Append(" and REQUIRE_DATE -interval '1' day <=" + Util.GetOracelDateSql(ReqDateTo)); } if (CreateDateFrom != string.Empty) { sb.Append(" and CREATE_DATE>=" + Util.GetOracelDateSql(CreateDateFrom)); } if (CreateDateTo != string.Empty) { sb.Append(" and CREATE_DATE -interval '1' day <=" + Util.GetOracelDateSql(CreateDateTo)); } string sqlSelect = "select * from plm.mmm_part_require_view where 1=1 "; string wheresql = sb.ToString(); sqlSelect = sqlSelect + wheresql; listviewBindInter(sqlSelect); }