private void btn_del_Click(object sender, EventArgs e) { int dgrow = dgv1.RowCount; string checkstr = ""; for (int i = 0; i < dgrow; i++) { if (dgv1.Rows[i].Cells[0].Value.ToString() == "1") { string partid = dgv1.Rows[i].Cells[3].Value.ToString(); checkstr = "checked"; } } if (checkstr == "") { MessageBox.Show("您还没有选择数据!"); return; } int seqNo = Convert.ToInt32(lbl_seqno.Text.ToString()); if (PartParameter.Delete(seqNo) > 0) { lbl_seqno.Text = string.Empty; MessageBox.Show("删除成功!"); } else { MessageBox.Show("删除失败!"); } QuerydataBind(); }
private void 确认上传ToolStripMenuItem_Click(object sender, EventArgs e) { if (dgv1.RowCount == 0) { return; } DialogResult dgresult = MessageBox.Show("确定要将选中的预估结果进行确认吗?", "操作确认", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dgresult == DialogResult.No) { return; } int confirmcount = dgv1.RowCount; string sequenceList = ""; for (int i = 0; i < confirmcount; i++) { if (dgv1.Rows[i].Cells["confirmflag"].EditedFormattedValue != null) { if (dgv1.Rows[i].Cells["confirmflag"].EditedFormattedValue.ToString() == "True") { string sequenceid = dgv1.Rows[i].Cells["sequence_id"].Value.ToString(); sequenceList += "," + sequenceid; } } } PartParameter.DeleteEstimate(sequenceList.Substring(1)); MessageBox.Show("所选材料的预估结果确认成功", "操作提示"); }
public void listviewBindpara(string sql) { //更改并设置列名称以及属性 dgv1.AutoGenerateColumns = false; ds = PartParameter.QueryPartPara(sql); dgv1.DataSource = ds.Tables[0].DefaultView; //DataGridViewComboBoxColumn dgvcom = new DataGridViewComboBoxColumn(); //DataSet blockds = PartParameter.QueryPartPara("select block_id,description from project_block_tab where project_id=" + ecprojectid.ToString() + " order by description"); //DataRow rowdim = blockds.Tables[0].NewRow(); //rowdim[0] = 1; //blockds.Tables[0].Rows.InsertAt(rowdim, 0); //dgvcom.DataSource = blockds.Tables[0].DefaultView; //dgvcom.DisplayMember = "description"; //dgvcom.ValueMember = "description"; //dgvcom.HeaderText = "分段"; //dgvcom.Name = "分段"; //dgvcom.ReadOnly = false; //CalendarColumn dgvcal = new CalendarColumn(); //dgvcal.HeaderText = "预估日期"; //dgvcal.Name = "预估日期"; ////DateColumn dgvcaln = new DateColumn(); ////dgvcaln.HeaderText = "日期新"; //if (!dgv1.Columns.Contains("预估日期")) //{ // //dgv1.Columns.Add(dgvcom); // dgv1.Columns.Add(dgvcal); // //dgv1.Columns.Add(dgvcaln); // dgv1.Columns["预估日期"].Width = 200; //} }
private void button2_Click(object sender, EventArgs e) { string sqlSelect = " order by t.createdate"; //string wheresql = sb.ToString(); ds = PartParameter.QueryPartPara(sqlSelect); dgv1.DataSource = ds.Tables[0]; SetrowStyle(); }
private void frmPartInventory_Load(object sender, EventArgs e) { ProjectCmbBind(); partnocmb = this.cmb_partno; //MessageBox.Show(site); DataSet unitds = PartParameter.QueryPartPara("select name from mm_unit_tab"); SiteCmbBind(); //GridViewTitleBind(); }
private void button3_Click(object sender, EventArgs e) { if (dgv1.RowCount == 0) { return; } pb1.Visible = true; bool restr = PartParameter.ExportToTxt(dgv1, pb1); pb1.Visible = false; }
/// <summary> /// 对ComboBox控件进行数据绑定 /// </summary> /// <param name="M_str_sqlstr">SQL语句</param> /// <param name="M_str_table">表名</param> /// <param name="M_str_tbMember">数据表中字段名</param> /// <param name="cbox">ComboBox控件ID</param> public static void cboxBind(string M_str_sqlstr, string M_str_tbValue, string M_str_tbMember, ComboBox cbox) { DataSet myds = PartParameter.QueryPartPara(M_str_sqlstr); DataRow rowdim = myds.Tables[0].NewRow(); rowdim[0] = 0; myds.Tables[0].Rows.InsertAt(rowdim, 0); cbox.DataSource = myds.Tables[0].DefaultView; cbox.DisplayMember = M_str_tbMember; cbox.ValueMember = M_str_tbValue; }
private void dateTimePicker1_ValueChanged(object sender, EventArgs e) { string fdate = this.dateTimePicker1.Value.ToString("yyyy-MM-dd"); //DateTime tdate = Convert.ToDateTime(this.dateTimePicker1.Value.AddDays(1).ToString("yyyy-MM-dd")); string datesr = "to_char(createdate,'yyyy-mm-dd')='" + fdate + "'"; string sqlSelect = " order by t.createdate"; ds = PartParameter.QueryPartPara(sqlSelect); dgv1.DataSource = ds.Tables[0]; SetrowStyle(); }
private void MaterialDetail_Load(object sender, EventArgs e) { string sqlstr = "select t.matr_seq_no 申请流水号,t.site 域,(select description from IFSAPP.SUB_PROJECT qq where qq.project_id= t.project_id and qq.sub_project_id =(select sub_project_id from IFSAPP.ACTIVITY_SUM_DETAIL p where p.activity_seq = 100086998)) 专业, (select description from IFSAPP.ACTIVITY_SUM_DETAIL pp where pp.activity_seq = t.activity_seq ) 材料种类,t.part_no 零件号,'" + part_name + "' as 零件描述 ,t.p_requisition_no MEO号,t.p_order_no 采购订单号,t.dt_issued 下发日期,t.request_date 需求日期,t.request_qty 需求数量,IFSAPP.PROJ_PROCU_RATION_API.Get_Accu_Ration_Qty(MATR_SEQ_NO) as 已下发数量,t.request_qty -IFSAPP.PROJ_PROCU_RATION_API.Get_Accu_Ration_Qty(MATR_SEQ_NO) as 可用数量,t.user_cre 操作人,t.reason_code 申请原因,t.design_code 范围,t.c_partial_info 范围 from IFSAPP.PROJECT_MISC_PROCUREMENT t where design_code like '%" + design_code + "%' and PROJECT_ID = '" + project_no + "' and site = '" + site_no + "' and issue_from_inv = 0 and PART_NO ='" + part_no + "' and (select state from ifsapp.purchase_req_line_part q where q.requisition_no =p_requisition_no and q.part_no=t.part_no) <>'Cancelled'"; DataSet ds = PartParameter.QueryPartERPInventory(sqlstr); dgv_meo.DataSource = ds.Tables[0].DefaultView; string sprojectname = project_no.Substring(project_no.Length - 3, 3); string sqlstrnew = "select tt.part_no 零件号,tt.part_desc 零件描述,tt.qty_onhand 预留数量,tt.qty_reserved 已用数量,tt.req_dept 预留标识 from ifsapp.yr_inv_on_hand_vw tt WHERE tt.part_no ='" + part_no + "' and tt.contract = '" + site_no + "' and tt.req_dept like 'YL" + sprojectname + "%'"; DataSet dsnew = PartParameter.QueryPartERPInventory(sqlstrnew); dgv_reserved.DataSource = dsnew.Tables[0].DefaultView; }
private void frmParaLog_Load(object sender, EventArgs e) { //StringBuilder sb = new StringBuilder(); //string spec_namestr = PartParameter.GetSpecName(activity); string sqlSelect = "SELECT * from MM_PART_PARAMETER_TAB where projectid='" + ProjectId + "' and part_no=" + Part_No + " and discipline =" + DisciplineId + "order by createdate";; //string wheresql = sb.ToString(); ds = PartParameter.QueryPartPara(sqlSelect); dgv1.DataSource = ds.Tables[0].DefaultView; SetrowStyle(); }
/// <summary> /// 取得预估重量 /// </summary> public decimal GetParaqty(int partid, string pid) { //partNo=cmb_partno.SelectedValue.ToString(); //Site = cmb_site.SelectedValue.ToString(); //string isInv = InventoryPart.GetIsInventory(Site, partNo); //if (isInv == "1") // checkBox1.Checked = true; //else // checkBox1.Checked = false; decimal invQty = PartParameter.FindPartParaSum(partid, pid); return(invQty); }
private void frmPartAdd_Load(object sender, EventArgs e) { ProjectCmbBind(); AddMaterialTree(); partnocmb = this.cmb_partno; //MessageBox.Show(site); DataSet unitds = PartParameter.QueryPartPara("select name from mm_unit_tab"); tb_unit.DataSource = unitds.Tables[0].DefaultView; tb_unit.DisplayMember = "name"; tb_unit.ValueMember = "name"; SiteCmbBind(); //GridViewTitleBind(); gboxheight = btn_del.Top; }
public void listviewBindInter(string sql) { this.dgv1.AutoGenerateColumns = false; //this.dgv1.Rows.Clear(); DataSet ds = MEOsub.QueryPartMiscProcListEPR(sql); DataView dv = ds.Tables[0].DefaultView; dgv1.DataSource = dv; //方法一:逐行比对ERP中申请的数据然后返回比对结果; if (dgv1.RowCount > 0) { for (int i = 0; i < dgv1.RowCount; i++) { string part_no = dgv1.Rows[i].Cells["part_no"].Value.ToString(); string requir_qty = dgv1.Rows[i].Cells["require_qty"].Value.ToString(); string meo_no = dgv1.Rows[i].Cells["meo_erp"].Value.ToString(); string sqlstr = "select t.p_requisition_no MEO号,t.request_qty as 申请数量 from IFSAPP.PROJECT_MISC_PROCUREMENT t where PROJECT_ID = '" + Projectid + "' and site = '" + mSite + "' and issue_from_inv = 0 and PART_NO ='" + part_no + "'and p_requisition_no =" + meo_no + " and (select state from ifsapp.purchase_req_line_part q where q.requisition_no =p_requisition_no and q.part_no=t.part_no) <>'Cancelled'"; DataSet dsnew = PartParameter.QueryPartERPInventory(sqlstr); if (dsnew.Tables[0].Rows.Count != 0) { dgv1.Rows[i].Cells["ISEXISTED"].Value = "存在"; string req_qty = dsnew.Tables[0].Rows[i]["申请数量"].ToString(); decimal ecqty = decimal.Parse(requir_qty); decimal erpqty = decimal.Parse(req_qty); if (decimal.Round(ecqty, 2) == decimal.Round(erpqty, 2)) { dgv1.Rows[i].Cells["ERP_QTY"].Value = erpqty; dgv1.Rows[i].Cells["compare_result"].Value = "数量一致"; } else { dgv1.Rows[i].Cells["ERP_QTY"].Value = erpqty; dgv1.Rows[i].Cells["compare_result"].Value = "数量不一致"; } } else { dgv1.Rows[i].Cells["ISEXISTED"].Value = "不存在"; } } } //方法二:将符合域与项目条件的所有ERP申请数据整合到DataSet中去,然后遍历比对数据 }
public void ImportParaData() { #region 逐行导入预估结果 for (int i = 0; i < dgv2.Rows.Count - 1; i++) { string partno = dgv2.Rows[i].Cells[4].Value.ToString().Trim(); string quyu = dgv2.Rows[i].Cells[1].Value.ToString().Trim(); string zhuanye = DisciplineId; string parttype = dgv2.Rows[i].Cells[3].Value.ToString().Trim(); string partname = dgv2.Rows[i].Cells[5].Value.ToString().Trim(); string predict_qty = dgv2.Rows[i].Cells[6].Value.ToString().Trim(); string firstbatchqty = dgv2.Rows[i].Cells[7].Value.ToString().Trim(); string firstbatchdate = dgv2.Rows[i].Cells[8].Value.ToString().Trim(); string secondbatchqty = dgv2.Rows[i].Cells[9].Value.ToString().Trim(); string secondbatchdate = dgv2.Rows[i].Cells[10].Value.ToString().Trim(); string unit_meas = dgv2.Rows[i].Cells[11].Value.ToString().Trim(); string predict_date = dgv2.Rows[i].Cells[12].Value.ToString().Trim(); string predict_person = dgv2.Rows[i].Cells[13].Value.ToString().Trim(); PartParameter predictset = new PartParameter(); predictset.OPERATOR = User.cur_user; predictset.PREDICT_DATE = Convert.ToDateTime(predict_date); predictset.PREDICT_CREATOR = predict_person; predictset.PREDICTION_QTY = string.IsNullOrEmpty(predict_qty) == true ? 0 : decimal.Parse(predict_qty); predictset.PART_NO = partno; predictset.PROJECT_ZONE = quyu; predictset.DISCIPLINE = zhuanye; predictset.PART_TYPE = parttype; predictset.DESCRIPTION = partname; predictset.CONTRACT = mSite; predictset.LAST_FLAG = 1; predictset.FIRSTBATCH_QTY = string.IsNullOrEmpty(firstbatchqty) == true ? 0 : decimal.Parse(firstbatchqty); predictset.FIRSTBATCH_DATE = Convert.ToDateTime(firstbatchdate); predictset.SECONDBATCH_QTY = string.IsNullOrEmpty(secondbatchqty) == true ? 0 : decimal.Parse(secondbatchqty); predictset.SECONDBATCH_DATE = Convert.ToDateTime(secondbatchdate); predictset.FINAL_PREDICTION_QTY = string.IsNullOrEmpty(predict_qty) == true ? 0 : decimal.Parse(predict_qty); predictset.UNIT = unit_meas; predictset.ECPROJECTID = ProjectSystem.FindProjectid(ProjectId);; predictset.PROJECTID = ProjectId; int count = predictset.Add(); } #endregion }
private string GetPartMEONO(string part_no, string needqty) { string MEO_NO = ""; decimal avalQty = 0, reqQty = 0; reqQty = Convert.ToDecimal(needqty); string sqlstr = "select t.p_requisition_no MEO号,t.request_qty -IFSAPP.PROJ_PROCU_RATION_API.Get_Accu_Ration_Qty(MATR_SEQ_NO) as 可用数量 from IFSAPP.PROJECT_MISC_PROCUREMENT t where PROJECT_ID = '" + ProjectId + "' and site = '" + Site + "' and issue_from_inv = 0 and PART_NO ='" + part_no + "'"; DataSet ds = PartParameter.QueryPartERPInventory(sqlstr); if (ds != null) { int p = ds.Tables[0].Rows.Count; for (int i = 0; i < p; i++) { avalQty = Convert.ToDecimal(ds.Tables[0].Rows[i][1].ToString()); string TempMEONo = ds.Tables[0].Rows[i][0].ToString(); if (avalQty > 0) { if (Convert.ToDecimal(reqQty) > avalQty) { MEO_NO = MEO_NO + TempMEONo + ";"; reqQty = reqQty - avalQty; } else { MEO_NO = MEO_NO + TempMEONo + ";"; reqQty = 0; break; } } } if (reqQty > 0) { MEO_NO = MEO_NO + GetPartReserveNO(part_no, reqQty.ToString()); } return(MEO_NO.Contains(';') ? MEO_NO.Substring(0, MEO_NO.Length - 1) : MEO_NO); } else { return(GetPartReserveNO(part_no, reqQty.ToString())); } }
private void dgv1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (this.dgv1.RowCount == 0) { return; } string partid = dgv1.CurrentRow.Cells["part_no"].Value.ToString(); string dpid = dgv1.CurrentRow.Cells["discipline"].Value.ToString(); if (PartParameter.GetPartParaCou(partid, dpid, ProjectId) == 0) { MessageBox.Show("无此材料的预估记录!"); return; } frmParaLog frm = new frmParaLog(); frm.ProjectId = ProjectId; frm.Part_No = partid; frm.DisciplineId = dpid; frm.Show(); }
private string GetPartReserveNO(string part_no, string needqty) { string sprojectname = ProjectId.Substring(ProjectId.Length - 3, 3); string MEO_NO = ""; string sqlstrnew = "select (tt.qty_onhand - tt.qty_reserved) 可用数量,tt.req_dept 预留标识 from ifsapp.yr_inv_on_hand_vw tt WHERE tt.part_no ='" + part_no + "' and tt.contract = '" + Site + "' and tt.req_dept like 'YL" + sprojectname + "%'"; DataSet dsnew = PartParameter.QueryPartERPInventory(sqlstrnew); decimal avalQty = 0, reqQty = 0; reqQty = Convert.ToDecimal(needqty); if (dsnew != null) { int p = dsnew.Tables[0].Rows.Count; for (int i = 0; i < p; i++) { avalQty = Convert.ToDecimal(dsnew.Tables[0].Rows[i][0].ToString()); string TempMEONo = dsnew.Tables[0].Rows[i][1].ToString(); if (avalQty > 0) { if (Convert.ToDecimal(reqQty) > avalQty) { MEO_NO = MEO_NO + TempMEONo + ";"; reqQty = reqQty - avalQty; } else { MEO_NO = MEO_NO + TempMEONo + ";"; reqQty = 0; break; } } } return(MEO_NO); } else { return(MEO_NO); } }
private void btn_save_Click(object sender, EventArgs e) { //string projectid = cmb_project.SelectedValue.ToString(); if (ProjectId == string.Empty) { MessageBox.Show("请选择项目!"); return; } if (dgv1.RowCount == 0) { MessageBox.Show("请选择数据!"); return; } string site = cmb_site.SelectedValue.ToString(); int kqrow; kqrow = dgv1.RowCount - 1; try { DataSet unitds = PartParameter.QueryPartPara("select name from mm_unit_tab"); #region 循环表,保存数据 for (int i = 0; i <= kqrow; i++) { string partno = dgv1.Rows[i].Cells["零件号"].Value.ToString().Trim(); int partid = int.Parse(dgv1.Rows[i].Cells["序号"].Value.ToString()); if (Part.Exist(partno, partid)) { MessageBox.Show("第" + partid.ToString() + "行编码重复,请检查!"); return; } Part ppn = new Part(); string partspec = dgv1.Rows[i].Cells["零件规格"].Value.ToString().Trim(); string parttype = dgv1.Rows[i].Cells["零件类别"].Value.ToString().Trim(); string partmat = dgv1.Rows[i].Cells["材质"].Value.ToString().Trim(); string partlevel = dgv1.Rows[i].Cells["等级"].Value.ToString().Trim(); string partcert = dgv1.Rows[i].Cells["证书"].Value.ToString().Trim(); string partpurchase = dgv1.Rows[i].Cells["采购周期"].Value.ToString().Trim(); string destinyunit = dgv1.Rows[i].Cells["密度单位"].Value.ToString().Trim(); string replacecode = dgv1.Rows[i].Cells["替代码"].Value.ToString().Trim(); string spec1 = "", spec2 = "", spec3 = "", spec4 = ""; if (lspec1.Visible == true) { spec1 = dgv1.Rows[i].Cells[lspec1.Text].Value.ToString().Trim(); } if (lspec2.Visible == true) { spec2 = dgv1.Rows[i].Cells[lspec2.Text].Value.ToString().Trim(); } if (lspec3.Visible == true) { spec3 = dgv1.Rows[i].Cells[lspec3.Text].Value.ToString().Trim(); } if (lspec4.Visible == true) { spec4 = dgv1.Rows[i].Cells[lspec4.Text].Value.ToString().Trim(); } string partunit = dgv1.Rows[i].Cells["单位"].Value.ToString().Trim(); string partunitdestiny = dgv1.Rows[i].Cells["单位密度"].Value.ToString().Trim(); ppn.PART_NO = partno; ppn.CONTRACT = site; ppn.PARENTID = int.Parse(activity); ppn.PART_CERT = partcert; decimal temaa = decimal.Parse(partunitdestiny); //temaa = decimal.Round(decimal.Parse("0.3333333"), 2); ppn.PART_UNITDENSITY = decimal.Round(temaa, 2); ppn.PART_LEVEL = partlevel; ppn.PART_SPEC = partspec; ppn.PART_SPEC1 = spec1; ppn.PART_SPEC2 = spec2; ppn.PART_SPEC3 = spec3; ppn.PART_SPEC4 = spec4; ppn.PART_DENSITYUNIT = destinyunit; ppn.PART_UNIT = partunit; ppn.PART_MAT = partmat; ppn.PART_TYPE = parttype; ppn.UPDATEDATE = DateTime.Today; ppn.UPDATER = LoginUser; ppn.REPLACE_CODE = replacecode; if (partpurchase != string.Empty) { ppn.SUPPLYCIRCLE = int.Parse(partpurchase); } else { ppn.SUPPLYCIRCLE = 10; } ppn.ID = int.Parse(dgv1.Rows[i].Cells["序号"].Value.ToString()); #region 判断Unit是否是合格格式 if (dgv1.Rows[i].Cells["单位"].Value != null && dgv1.Rows[i].Cells["单位"].Value.ToString() != string.Empty) { string punit = dgv1.Rows[i].Cells["单位"].Value.ToString().Trim().ToLower(); DataRow[] pone = unitds.Tables[0].Select("name ='" + punit + "'"); if (pone.Length != 0) { ppn.PART_UNIT = punit; } else { MessageBox.Show("第" + (i + 1) + "行单位名称不规范,请检查!", "错误提示"); dgv1.Rows[i].Selected = true; return; } } #endregion int count = ppn.Update(); if (count == 0) { MessageBox.Show("第" + partid.ToString() + "行更新失败"); } } #endregion MessageBox.Show("保存成功!! ", "温馨提示!"); } catch (Exception err) { MessageBox.Show("错误原因:" + err.Message, "错误提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } QuerydataBind(); }
public void listviewBind(string sql) { //更改并设置列名称以及属性 ds = PartParameter.QueryPartPara(sql); dgv1.DataSource = ds.Tables[0].DefaultView; DataGridViewComboBoxColumn dgvcom = new DataGridViewComboBoxColumn(); DataSet blockds = PartParameter.QueryPartPara("select block_id,description from project_block_tab where project_id=" + ecprojectid.ToString() + " order by description"); DataRow rowdim = blockds.Tables[0].NewRow(); rowdim[0] = 1; blockds.Tables[0].Rows.InsertAt(rowdim, 0); dgvcom.DataSource = blockds.Tables[0].DefaultView; dgvcom.DisplayMember = "description"; dgvcom.ValueMember = "description"; dgvcom.HeaderText = "分段"; dgvcom.Name = "分段"; dgvcom.ReadOnly = false; CalendarColumn dgvcal = new CalendarColumn(); dgvcal.HeaderText = "预估日期"; dgvcal.Name = "预估日期"; //DateColumn dgvcaln = new DateColumn(); //dgvcaln.HeaderText = "日期新"; if (!dgv1.Columns.Contains("预估日期")) { //dgv1.Columns.Add(dgvcom); //dgv1.Columns.Add(dgvcal); //dgv1.Columns.Add(dgvcaln); //dgv1.Columns["预估日期"].Width = 200; } dgv1.Columns["预估量"].Width = 100; //dgv1.Columns["分段"].Width = 100; dgv1.Columns["预估量"].ValueType = typeof(double); 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["密度单位"].ReadOnly = true; dgv1.Columns["等级"].ReadOnly = true; dgv1.Columns["单位密度"].ReadOnly = true; dgv1.Columns["parentid"].Visible = false; #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(systemid,mmtypeid, 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; // //DataGridViewComboBoxCell combo = new DataGridViewComboBoxCell(); // dgv1.Rows[i].Cells["预警系数"].Value = pone.PREDICTION_ALERT; // if (pone.BLOCKID != "0") // { // dgv1.Rows[i].Cells["日期"].Value = pone.CREATEDATE; // dgv1.Rows[i].Cells["分段"].Value = pone.BLOCKID; // //DataGridViewComboBoxCell combo = dgv1.Rows[i].Cells["分段"] as DataGridViewComboBoxCell; // //combo.DataSource = blockds.Tables[0]; // //combo.DisplayMember = "description"; // //combo.ValueMember = "block_id"; // //combo.Value = pone.BLOCKID; // } // } // else // { // dgv1.Rows[i].Cells["预估量"].Value = 0; // dgv1.Rows[i].Cells["预警系数"].Value = 0; // } // } // //} //} #endregion }
public void listviewBind(string sql) { //更改并设置列名称以及属性 DataSet ds = PartParameter.QueryPartERPInventory(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); if (ds != null) { this.dgv1.AutoGenerateColumns = false; this.dgv1.Rows.Clear(); this.dgv1.Columns.Clear(); this.dgv1.Columns.Add("Id", "序号"); this.dgv1.Columns.Add("域", "域"); this.dgv1.Columns.Add("零件号", "零件号"); this.dgv1.Columns.Add("零件描述", "零件描述"); this.dgv1.Columns.Add("申请数量", "申请数量"); this.dgv1.Columns.Add("已下发数量", "已下发数量"); this.dgv1.Columns.Add("余下申请数量", "余下申请数量"); this.dgv1.Columns.Add("项目预留可用", "项目预留可用"); this.dgv1.Columns.Add("项目总的数量", "项目总的数量"); this.dgv1.Columns.Add("单位", "单位"); dgv1.Columns["Id"].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["单位"].ReadOnly = true; //dgv1.Columns["单位"].ReadOnly = true; dgv1.Columns["零件描述"].ReadOnly = true; DataView dv = ds.Tables[0].DefaultView; int i = 1; foreach (DataRow dr in dv.Table.Rows) { DataGridViewRow r = new DataGridViewRow(); r.CreateCells(dgv1); r.Cells[0].Value = i.ToString(); r.Cells[1].Value = dr[0].ToString(); r.Cells[2].Value = dr[1].ToString(); r.Cells[3].Value = dr[2].ToString(); r.Cells[4].Value = dr[5].ToString(); r.Cells[5].Value = dr[6].ToString(); r.Cells[6].Value = dr[7].ToString(); r.Cells[7].Value = dr[4].ToString(); r.Cells[8].Value = Convert.ToDecimal(dr[4].ToString()) + Convert.ToDecimal(dr[7].ToString()); r.Cells[9].Value = dr[3].ToString(); if (Convert.ToDecimal(dr[5].ToString()) + Convert.ToDecimal(dr[8].ToString()) != 0) { this.dgv1.Rows.Add(r); i++; } } } }
private void btn_save_Click(object sender, EventArgs e) { // string projectid = cmb_project.SelectedValue.ToString(); string site = cmb_site.SelectedValue.ToString(); decimal singleWeight = 0; //decimal fpreAlert = 0; decimal fcoe = 0; //decimal.TryParse(sigleWeight, out singleWeight); //decimal.TryParse(preAlert, out fpreAlert); //decimal.TryParse(coe, out fcoe); if (ProjectId == string.Empty) { MessageBox.Show("请选择项目!"); return; } if (dgv1.RowCount == 0) { MessageBox.Show("请选择数据!"); return; } int kqrow; kqrow = dgv1.RowCount - 1; try { //DataSet unitds=PartParameter.QueryPartPara("select name from mm_unit_tab"); #region 循环表,保存数据 for (int i = 0; i <= kqrow; i++) { string partno = dgv1.Rows[i].Cells["零件号"].Value.ToString().Trim(); PartParameter pp = PartParameter.Find(int.Parse(activity), ProjectId, partno, site, LoginUser); PartParameter ppn = new PartParameter(); ppn.PART_NO = partno; ppn.CONTRACT = site; ppn.PROJECTID = ProjectId; ppn.WEIGHT_SINGLE = singleWeight; string preQty = dgv1.Rows[i].Cells["预估量"].Value.ToString().Trim(); decimal fpreQty = string.IsNullOrEmpty(preQty) == true ? 0 : decimal.Parse(preQty); ppn.PREDICTION_QTY = decimal.Round(fpreQty, 2); string preAlert = dgv1.Rows[i].Cells["预警系数"].Value.ToString().Trim(); //decimal fpreAlert = decimal.Parse(preAlert); //ppn.PREDICTION_ALERT = decimal.Round(fpreAlert, 2); //ppn.PREDICTION_ALERT = fpreAlert; //ppn.COEFFICIENT_ERP = fcoe; ppn.DESCRIPTION = ""; ppn.PREDICT_CREATOR = LoginUser; ppn.ECPROJECTID = ecprojectid; ppn.SYSTEMID = int.Parse(activity); //if (dgv1.Rows[i].Cells["分段"].Value != null) // ppn.BLOCKID = dgv1.Rows[i].Cells["分段"].Value.ToString(); ppn.PARTID = int.Parse(dgv1.Rows[i].Cells["序号"].Value.ToString()); #region 判断Unit是否是合格格式 //if (dgv1.Rows[i].Cells[2].Value != null) //{ // string punit = dgv1.Rows[i].Cells[2].Value.ToString().Trim().ToLower(); // DataRow[] pone = unitds.Tables[0].Select("name ='"+punit+"'"); // if (pone.Length != 0) // { // ppn.UNIT = punit; // } // else // { // MessageBox.Show("第"+(i+1)+"行单位名称不规范,请检查!","错误提示"); // dgv1.Rows[i].Selected=true; // return; // } //} #endregion if (pp != null) { if (dgv1.Rows[i].Cells["checkbox"].Value != null) { if (fpreQty > 0 || dgv1.Rows[i].Cells["checkbox"].Value.ToString() == "1") { DateTime cdate = pp.CREATEDATE; int count = ppn.Update(); ppn.LAST_FLAG = 0; ppn.PREDICTION_QTY = pp.PREDICTION_QTY; ppn.PREDICTION_ALERT = pp.PREDICTION_ALERT; ppn.CREATEDATE = cdate; int countnew = 0; if (pp.PREDICTION_QTY != fpreQty) { countnew = ppn.Add(); } if (count == 0) { MessageBox.Show("更新失败"); } } } } else { if (dgv1.Rows[i].Cells["checkbox"].Value != null) { if (fpreQty > 0 || dgv1.Rows[i].Cells["checkbox"].Value.ToString() == "1") { ppn.CREATEDATE = DateTime.Today; ppn.LAST_FLAG = 1; int count = ppn.Add(); if (count == 0) { MessageBox.Show("添加失败"); } } } } } #endregion MessageBox.Show("保存材料预估量成功!! ", "温馨提示!"); } catch (Exception err) { MessageBox.Show("错误原因:" + err.Message, "错误提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } QuerydataBindpara(); }
public void listviewBind(string sql) { this.dgv1.AutoGenerateColumns = false; this.dgv1.Rows.Clear(); DataSet ds = MEOsub.QueryPartMiscProcListEPR(sql); DataView dv = ds.Tables[0].DefaultView; int i = 1; foreach (DataRow dr in dv.Table.Rows) { string projectid = dr[1].ToString(); string partno = dr[2].ToString(); string site = dr[0].ToString(); PartParameter pp = PartParameter.Find(0, projectid, partno, site, "weijun.qu"); decimal preQty = 0; decimal singleW = 0; decimal preAlert = 0; if (pp != null) { preQty = pp.PREDICTION_QTY; singleW = pp.WEIGHT_SINGLE; preAlert = pp.PREDICTION_ALERT; } PartRelative pr = new PartRelative(); pr.ERP_PART_NO = partno; pr.STA_PART_NO = partno; pr.SITE = site; pr.PROJECTID = projectid; pr.ACTIVITYSEQ = Convert.ToInt32(Str_activity); string isStandPart = ""; string isMerged = ""; if (pr.IFStandardPart()) { isStandPart = "是"; } if (pr.IFmerged1()) { isMerged = "是"; } string StnPartno = PartRelative.FindRelativeStnPartno(partno, projectid, Convert.ToInt32(Str_activity), site); DataGridViewRow r = new DataGridViewRow(); r.CreateCells(dgv1); r.Cells[1].Value = i.ToString(); r.Cells[2].Value = dr[0].ToString(); r.Cells[3].Value = dr[2].ToString(); r.Cells[4].Value = dr[3].ToString(); r.Cells[5].Value = dr[4].ToString(); dgv1.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; r.Cells[6].Value = pp == null ? string.Empty : pp.PREDICTION_QTY.ToString(); r.Cells[7].Value = pp == null ? string.Empty : pp.WEIGHT_SINGLE.ToString(); r.Cells[8].Value = isMerged; r.Cells[9].Value = isStandPart; r.Cells[10].Value = StnPartno; //r.Cells[8].Value = MeoNo; //r.Cells[9].Value = MeoQty.ToString(); //r.Cells[10].Value = Str_MeoPcs; //r.Cells[11].Value = Str_Meotime; //r.Cells[12].Value = restQty.ToString(); //r.Cells[13].Value = MssQty.ToString(); this.dgv1.Rows.Add(r); i++; } }
/// <summary> /// 查找材料以及库存 /// </summary> public void QuerydataBind() { //string ProjectId = cmb_project.SelectedValue.ToString(); site = cmb_site.SelectedValue.ToString(); string partno = cmb_partno.Text.Trim().ToString(); string PartName = cmb_partname.Text.Trim().ToString(); string parttype = tb_type.Text.Trim().ToString(); string partmat = tb_mat.Text.Trim().ToString(); string partlevel = tb_level.Text.Trim().ToString(); string partcert = tb_cert.Text.Trim().ToString(); //string spec4 = tb_spec4.Text.Trim().ToString(); string spec1 = tb_spec1.Text.Trim().ToString(); string spec2 = tb_spec2.Text.Trim().ToString(); string spec3 = tb_spec3.Text.Trim().ToString(); string spec4 = tb_spec4.Text.Trim().ToString(); StringBuilder sb = new StringBuilder(); string spec_namestr = PartParameter.GetSpecName(activity); string pluscolum = string.Empty; //if (cb_showqty.Checked == true) // pluscolum = ",'' 项目可用库存量,'' 项目采购数量,'' 项目预留数量"; //if (ProjectId != string.Empty) sb.Append(" AND PROJECTID = '" + ProjectId + "'"); if (site != string.Empty) { sb.Append(" AND CONTRACT = '" + site + "'"); } if (partno != string.Empty) { sb.Append(" AND part_no like '%" + partno + "%'"); } if (PartName != string.Empty) { sb.Append(" AND part_spec like'%" + PartName + "%'"); } if (parttype != string.Empty) { sb.Append(" AND part_type like'%" + parttype + "%'"); } if (spec1 != string.Empty) { sb.Append(" AND part_spec1 like '%" + spec1 + "%'"); } if (spec2 != string.Empty) { sb.Append(" AND part_spec2 like '%" + spec2 + "%'"); } if (spec3 != string.Empty) { sb.Append(" AND part_spec3 like'%" + spec3 + "%'"); } if (spec4 != string.Empty) { sb.Append(" AND part_spec4 like'%" + spec4 + "%'"); } if (partmat != string.Empty) { sb.Append(" AND part_mat like '%" + partmat + "%'"); } if (partcert != string.Empty) { sb.Append(" AND part_cert like'%" + partcert + "%'"); } if (partlevel != string.Empty) { sb.Append(" AND part_level like'%" + partlevel + "%'"); } //string sqlSelect = "SELECT '','',pp.*,'' FROM PLM.MM_PART_TAB pp WHERE 1=1 and parentid= " + activity; string sqlSelect = "select t.ID 序号,t.part_no 零件号,t.part_type 零件类别,t.part_spec 零件规格," + spec_namestr + "t.part_mat 材质,t.part_cert 证书,t.part_unit 单位,t.part_unitdensity 单位密度,t.part_densityunit 密度单位,t.part_level 等级,t.parentid,t.contract 域" + ",t.supplycircle 采购周期,t.replace_code 替代码" + pluscolum + " from mm_part_tab t WHERE 1=1 and parentid= " + activity; string wheresql = sb.ToString(); sqlSelect = sqlSelect + wheresql + " order by t.parentid,t.part_type"; listviewBind(sqlSelect); }
private void tvMType_NodeMouseDoubleClick(object sender, TreeNodeMouseClickEventArgs e) { #region 根据不同材料设置不同的材料属性 if (e.Node.Name == "activity") { activity = e.Node.Tag.ToString(); int specnum = PartParameter.GetSpecCou(activity); if (specnum != 0) { if (specnum > 0) { lspec1.Visible = true; tb_spec1.Visible = true; lspec2.Visible = false; tb_spec2.Visible = false; lspec3.Visible = false; tb_spec3.Visible = false; lspec4.Visible = false; tb_spec4.Visible = false; lspec1.Text = PartParameter.GetSpecName(activity, "1").Trim(); //relocation(); } if (specnum > 1) { lspec2.Visible = true; tb_spec2.Visible = true; lspec3.Visible = false; tb_spec3.Visible = false; lspec4.Visible = false; tb_spec4.Visible = false; lspec2.Text = PartParameter.GetSpecName(activity, "2").Trim(); //relocation(); } if (specnum > 2) { lspec3.Visible = true; tb_spec3.Visible = true; lspec4.Visible = false; tb_spec4.Visible = false; lspec3.Text = PartParameter.GetSpecName(activity, "3").Trim(); //relocation(); } if (specnum > 3) { lspec4.Visible = true; tb_spec4.Visible = true; lspec4.Text = PartParameter.GetSpecName(activity, "4").Trim(); } } else { lspec1.Visible = false; tb_spec1.Visible = false; lspec2.Visible = false; tb_spec2.Visible = false; lspec3.Visible = false; tb_spec3.Visible = false; lspec4.Visible = false; tb_spec4.Visible = false; //relocation(); } //BindPartNobyAct(); //cmb_partno.Text = site; //if (sub2pro == "") //{ // sub2pro = "03"; //} //cmb_site.SelectedValue = sub2pro; //QuerydataBind(); } #endregion }
/// <summary> /// 根据货物所占百分比画饼图 /// </summary> /// <param name="objgraphics">Graphics类对象</param> /// <param name="M_str_sqlstr">SQL语句</param> /// <param name="M_str_table">表名</param> /// <param name="M_str_Num">数据表中货物数</param> /// <param name="M_str_tbGName">数据表中货物名称</param> /// <param name="M_str_title">饼图标题</param> public void drawPic(Graphics objgraphics, string M_str_sqlstr, string M_str_table, string M_str_Num, string M_str_tbGName, string M_str_title) { DataSet myds = PartParameter.QueryPartPara(M_str_sqlstr); float M_flt_total = 0.0f, M_flt_tmp; int M_int_iloop; for (M_int_iloop = 0; M_int_iloop < myds.Tables[0].Rows.Count; M_int_iloop++) { M_flt_tmp = Convert.ToSingle(myds.Tables[0].Rows[M_int_iloop][M_str_Num]); M_flt_total += M_flt_tmp; } Font fontlegend = new Font("verdana", 9), fonttitle = new Font("verdana", 10, FontStyle.Bold); //设置字体 int M_int_width = 275; //白色背景宽 const int Mc_int_bufferspace = 15; int M_int_legendheight = fontlegend.Height * (myds.Tables[0].Rows.Count + 1) + Mc_int_bufferspace; int M_int_titleheight = fonttitle.Height + Mc_int_bufferspace; int M_int_height = M_int_width + M_int_legendheight + M_int_titleheight + Mc_int_bufferspace;//白色背景高 int M_int_pieheight = M_int_width; Rectangle pierect = new Rectangle(0, M_int_titleheight, M_int_width, M_int_pieheight); //加上各种随机色 Bitmap objbitmap = new Bitmap(M_int_width, M_int_height);//创建一个bitmap实例 objgraphics = Graphics.FromImage(objbitmap); ArrayList colors = new ArrayList(); Random rnd = new Random(); for (M_int_iloop = 0; M_int_iloop < myds.Tables[0].Rows.Count; M_int_iloop++) { colors.Add(new SolidBrush(Color.FromArgb(rnd.Next(255), rnd.Next(255), rnd.Next(255)))); } objgraphics.FillRectangle(new SolidBrush(Color.White), 0, 0, M_int_width, M_int_height); //画一个白色背景 objgraphics.FillRectangle(new SolidBrush(Color.LightYellow), pierect); //画一个亮黄色背景 //以下为画饼图(有几行row画几个) float M_flt_currentdegree = 0.0f; for (M_int_iloop = 0; M_int_iloop < myds.Tables[0].Rows.Count; M_int_iloop++) { objgraphics.FillPie((SolidBrush)colors[M_int_iloop], pierect, M_flt_currentdegree, Convert.ToSingle(myds.Tables[0].Rows[M_int_iloop][M_str_Num]) / M_flt_total * 360); M_flt_currentdegree += Convert.ToSingle(myds.Tables[0].Rows[M_int_iloop][M_str_Num]) / M_flt_total * 360; } //以下为生成主标题 SolidBrush blackbrush = new SolidBrush(Color.Black); StringFormat stringFormat = new StringFormat(); stringFormat.Alignment = StringAlignment.Center; stringFormat.LineAlignment = StringAlignment.Center; objgraphics.DrawString(M_str_title, fonttitle, blackbrush, new Rectangle(0, 0, M_int_width, M_int_titleheight), stringFormat); objgraphics.DrawRectangle(new Pen(Color.Black, 2), 0, M_int_height - M_int_legendheight, M_int_width, M_int_legendheight); for (M_int_iloop = 0; M_int_iloop < myds.Tables[0].Rows.Count; M_int_iloop++) { objgraphics.FillRectangle((SolidBrush)colors[M_int_iloop], 5, M_int_height - M_int_legendheight + fontlegend.Height * M_int_iloop + 5, 10, 10); objgraphics.DrawString(((String)myds.Tables[0].Rows[M_int_iloop][M_str_tbGName]) + " —— " + Convert.ToString(Convert.ToSingle(myds.Tables[0].Rows[M_int_iloop][M_str_Num]) * 100 / M_flt_total) + "%", fontlegend, blackbrush, 20, M_int_height - M_int_legendheight + fontlegend.Height * M_int_iloop + 1); } objgraphics.DrawString("总货物数是:" + Convert.ToString(M_flt_total), fontlegend, blackbrush, 5, M_int_height - fontlegend.Height); string P_str_imagePath = Application.StartupPath.Substring(0, Application.StartupPath.Substring(0, Application.StartupPath.LastIndexOf("\\")).LastIndexOf("\\")); P_str_imagePath += @"\Image\image\" + DateTime.Now.ToString("yyyyMMddhhmss") + ".jpg"; objbitmap.Save(P_str_imagePath, ImageFormat.Jpeg); objgraphics.Dispose(); objbitmap.Dispose(); }
public void CheckImportData() { #region 首先检查要导入的Excel数据中ERP代码是否在ERP系统中存在 string txtfilename = System.Windows.Forms.Application.StartupPath + "\\错误信息.txt"; StreamWriter sw = new StreamWriter(txtfilename, false, Encoding.GetEncoding("gb2312")); int flag = 0; try { for (int i = 0; i < dgv2.Rows.Count - 1; i++) { string partno = dgv2.Rows[i].Cells[4].Value.ToString(); if (!string.IsNullOrEmpty(partno)) { InventoryPart invpartnew = InventoryPart.FindInvInfor(partno, mSite); if (invpartnew == null) { System.Diagnostics.Trace.WriteLine("第" + (i + 1) + "行材料编码 " + partno + " 在ERP中所选择域无此材料编码,请联系ERP操作员,在ERP中添加。"); sw.WriteLine("第" + (i + 1) + "行材料编码 " + partno + " 在ERP中所选择域无此材料编码,请联系ERP操作员,在ERP中添加。", "温馨提示"); flag = 1; } } else { System.Diagnostics.Trace.WriteLine("第" + (i + 1) + "行材料编码 " + partno + " 在没有填写,在ERP中添加活查询后填写。"); sw.WriteLine("第" + (i + 1) + "行材料编码 " + partno + " 在没有填写,在ERP中添加活查询后填写。", "温馨提示"); flag = 1; } if (!string.IsNullOrEmpty(dgv2.Rows[i].Cells[6].Value.ToString())) { string rqty = dgv2.Rows[i].Cells[6].Value.ToString(); if (BaseClass.validateNum(rqty) == false) { System.Diagnostics.Trace.WriteLine("请确认第" + (i + 1) + "行" + partno + " 预估数量输入数字!!!"); sw.WriteLine("请确认第" + (i + 1) + "行" + partno + " 预估数量输入数字!!!", "温馨提示"); flag = 1; } } if (!string.IsNullOrEmpty(dgv2.Rows[i].Cells[7].Value.ToString())) { string rqty = dgv2.Rows[i].Cells[7].Value.ToString(); if (BaseClass.validateNum(rqty) == false) { System.Diagnostics.Trace.WriteLine("请确认第" + (i + 1) + "行 " + partno + " 第一批生产需求数量输入数字!!!"); sw.WriteLine("请确认第" + (i + 1) + "行 " + partno + " 第一批生产需求数量输入数字!!!", "温馨提示"); flag = 1; } } else { System.Diagnostics.Trace.WriteLine("请确认第" + (i + 1) + "行 " + partno + " 第一批生产需求数量没有输入数字!!!"); sw.WriteLine("请确认第" + (i + 1) + "行 " + partno + " 第一批生产需求数量没有输入数字!!!", "温馨提示"); flag = 1; } if (!string.IsNullOrEmpty(dgv2.Rows[i].Cells[9].Value.ToString())) { string rqty = dgv2.Rows[i].Cells[9].Value.ToString(); if (BaseClass.validateNum(rqty) == false) { System.Diagnostics.Trace.WriteLine("请确认第" + (i + 1) + "行 " + partno + " 第一批生产需求数量输入数字!!!"); sw.WriteLine("请确认第" + (i + 1) + "行 " + partno + " 第一批生产需求数量输入数字!!!", "温馨提示"); flag = 1; } } else { System.Diagnostics.Trace.WriteLine("请确认第" + (i + 1) + "行 " + partno + " 第二批生产需求数量没有输入数字!!!"); sw.WriteLine("请确认第" + (i + 1) + "行 " + partno + " 第二批生产需求数量没有输入数字!!!", "温馨提示"); flag = 1; } } if (flag == 1) { sw.Close(); MessageBox.Show("要导入的预估文件数据有误,请检查!"); System.Diagnostics.Process.Start("explorer.exe", txtfilename); return; } #endregion DialogResult dgresult = MessageBox.Show("确定要将预估结果进行导入吗?", "操作确认", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dgresult == DialogResult.No) { return; } #region 首先将上次的预估结果保存为历史记录(按照预估人,专业,区域进行覆盖) PartParameter.DeleteEstimate(mSite, ProjectId, DisciplineId); #endregion ImportDataHanlder ImportData = new ImportDataHanlder(ImportParaData); ImportData.BeginInvoke(null, null); } catch (Exception et) { MessageBox.Show(et.Message); } finally { MessageBox.Show("预估数据导入成功!!!", "操作提示"); } }
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 button4_Click(object sender, EventArgs e) { string site = cmb_site.SelectedValue.ToString(); string partno = cmb_partno.Text.Trim().ToString(); string partspec = cmb_partname.Text.Trim().ToString(); string parttype = tb_type.Text.Trim().ToString(); string partmat = tb_mat.Text.Trim().ToString(); string partlevel = tb_level.Text.Trim().ToString(); string partcert = tb_cert.Text.Trim().ToString(); string purchasec = tb_pc.Text.Trim().ToString(); string spec1 = tb_spec1.Text.Trim().ToString(); string spec2 = tb_spec2.Text.Trim().ToString(); string spec3 = tb_spec3.Text.Trim().ToString(); string spec4 = tb_spec4.Text.Trim().ToString(); string partunit = tb_unit.Text.Trim().ToString(); string partunitdestiny = tb_unitdestiny.Text.Trim().ToString(); string partdestinyunit = txt_destinyunit.Text.Trim().ToString(); //if (ProjectId == string.Empty) //{ // MessageBox.Show("请选择项目!"); // return; //} if (partno == string.Empty) { MessageBox.Show("请填写零件编号!"); return; } if (Part.Exist(partno)) { MessageBox.Show("此零件编号已经存在,请检查!"); return; } if (partspec == string.Empty) { MessageBox.Show("请填写零件规格!"); return; } if (parttype == string.Empty) { MessageBox.Show("请填写零件类型!"); return; } if (partmat == string.Empty) { MessageBox.Show("请填写零件材质!"); return; } if (partcert == string.Empty) { MessageBox.Show("请填写零件证书!"); return; } if (partlevel == string.Empty) { MessageBox.Show("请填写零件等级!"); return; } try { DataSet unitds = PartParameter.QueryPartPara("select name from mm_unit_tab"); //string partno = dgv1.Rows[i].Cells["零件号"].Value.ToString().Trim(); //PartParameter pp = PartParameter.Find(ProjectId, partno, site, LoginUser); Part ppn = new Part(); ppn.PART_NO = partno; ppn.CONTRACT = site; ppn.PARENTID = int.Parse(activity); ppn.PART_CERT = partcert; if (partunitdestiny != string.Empty) { ppn.PART_UNITDENSITY = decimal.Parse(partunitdestiny); } if (partdestinyunit != string.Empty) { ppn.PART_DENSITYUNIT = partdestinyunit; } ppn.PART_LEVEL = partlevel; ppn.PART_SPEC = partspec; ppn.PART_SPEC1 = spec1; ppn.PART_SPEC2 = spec2; ppn.PART_SPEC3 = spec3; ppn.PART_SPEC4 = spec4; ppn.CREATOR = LoginUser; ppn.PART_UNIT = partunit; ppn.PART_MAT = partmat; ppn.PART_TYPE = parttype; if (purchasec != string.Empty) { ppn.SUPPLYCIRCLE = int.Parse(purchasec); } else { ppn.SUPPLYCIRCLE = 10; } #region 判断Unit是否是合格格式 DataRow[] pone = unitds.Tables[0].Select("name ='" + partunit + "'"); if (pone.Length != 0) { ppn.PART_UNIT = partunit; } else { MessageBox.Show("单位名称不规范,请检查!", "错误提示"); tb_unit.Focus(); return; } #endregion int count = ppn.Add(); if (count == 0) { MessageBox.Show("添加失败"); return; } MessageBox.Show("保存零件成功!! ", "温馨提示!"); QuerydataBind(); #region //int cou = PartParameter.GetSpecCou(activity); //DataGridViewRow newrow = new DataGridViewRow(); //dgv1.Rows.Insert(0, newrow); //newrow.CreateCells(dgv1); //newrow.Cells[11 + cou].Value = site; //if (cou > 0) //{ // newrow.Cells[4].Value = spec1; //} //if (cou > 1) //{ // newrow.Cells[5].Value = spec2; //} //if (cou > 2) //{ // newrow.Cells[6].Value = spec3; //} //if (cou > 3) //{ // newrow.Cells[7].Value = spec4; //} //newrow.Cells[2].Value = parttype; //newrow.Cells[3].Value = partspec; //newrow.Cells[4+cou].Value = partmat; //newrow.Cells[5 + cou].Value = partcert; //newrow.Cells[6 + cou].Value = partunit; ////newrow.Cells["密度单位"].Value = partunit; //newrow.Cells[9 + cou].Value = partlevel; //newrow.Cells[7 + cou].Value = partunitdestiny; //newrow.Cells[10 + cou].Value = activity; //dgv1.Rows.Add(newrow); #endregion } catch (Exception err) { MessageBox.Show("错误原因:" + err.Message, "错误提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } }