/// <summary> /// 获取U9数据 /// </summary> private bool gainData(string DeliveryNoteID, int DRAW_EXAM_INTERFACE_ID) { try { LWGETWebReference.QualityPaperManagement_v001 LWGET = new LWGETWebReference.QualityPaperManagement_v001(); LWGET.Url = Common.GainURL; string OrganizationID = Common.OrganizationID; string DepartmentName = ""; //部门名称 string BinID = ""; //堆位ID string BinName = ""; //堆位名称 LWGET.UseDefaultCredentials = true; LWGET.RequestHeader = new LWGETWebReference.RequestHeaderType() { SourceID = Common.SourceID }; //返回部门ID //DeliveryNoteID = "DHPOF00077015"; string DepartmentID = LWGET.GetBinForDeliveryNote(OrganizationID, DeliveryNoteID, out DepartmentName, out BinID, out BinName); if (!string.IsNullOrEmpty(DepartmentID)) { //限制只能有一条数据 DataTable dtRLPD = LinQBaseDao.Query("select * from RegisterLoosePaperDistribution where R_DRAW_EXAM_INTERFACE_ID=" + DRAW_EXAM_INTERFACE_ID).Tables[0]; if (dtRLPD.Rows.Count == 0) { RegisterLoosePaperDistribution rpdb = new RegisterLoosePaperDistribution(); rpdb.OrganizationID = OrganizationID; rpdb.DepartmentCode = DepartmentID; rpdb.ExtensionField2 = BinID; rpdb.R_DRAW_EXAM_INTERFACE_ID = DRAW_EXAM_INTERFACE_ID; rpdb.issend = false; if (LinQBaseDao.InsertOne(dc, rpdb)) { return(true); } else { return(false); } } else { return(true); } } else { return(false); } //DepartmentID:050703 BinName:15-25國廢倉 BinID:15-25 DepartmentName:生産部-二十一車間(PM13)-21車間制漿 } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }
/// </summary> /// 新增一条车辆质检记录 /// </summary> /// <param name="qcRecord">QCRecord质检实体</param> /// <param name="rint">新增后自动增长编号</param> /// <returns></returns> public static bool InsertOneCarInfo(RegisterLoosePaperDistribution DRAW_E_INI, out int rint) { rint = 0; bool rbool = true; using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { try { db.RegisterLoosePaperDistribution.InsertOnSubmit(DRAW_E_INI); db.SubmitChanges(); rbool = true; rint = (int)DRAW_E_INI.R_DRAW_EXAM_INTERFACE_ID; } catch { rbool = false; } finally { db.Connection.Close(); } } return(rbool); }
private void btn_CarAdd_Click(object sender, EventArgs e) { try { DRAW_EXAM_INTERFACE d = new DRAW_EXAM_INTERFACE(); QCInfo c = new QCInfo(); RegisterLoosePaperDistribution r = new RegisterLoosePaperDistribution(); Packets p = new Packets(); if (txt_SHIPMENT_NO.Text != "") { d.SHIPMENT_NO = txt_SHIPMENT_NO.Text.Trim(); } else { MessageBox.Show("送货单号不能为空"); return; } if (txt_PO_NO.Text != "") { d.PO_NO = txt_PO_NO.Text.Trim(); } else { MessageBox.Show("采购单号不能为空"); return; } if (cmb_PROD_ID.Text != "") { d.PROD_ID = cmb_PROD_ID.Text.Trim(); } else { MessageBox.Show("货品不能为空"); return; } if (txt_CNTR_NO.Text != "") { d.CNTR_NO = txt_CNTR_NO.Text.Trim(); } else { MessageBox.Show("车牌号不能为空"); return; } DataTable dt = LinQBaseDao.Query("select * from Unusualstandard where Unusualstandard_PROD ='" + cmb_PROD_ID.Text.Trim() + "' ").Tables[0]; if (dt != null && dt.Rows.Count > 0) { d.DEGRADE_MATERIAL_PERCT = Convert.ToDecimal(dt.Rows[0]["Unusualstandard_DEGRADE_MATERIAL_PERCT"]); d.DEGRADE_MOISTURE_PERCT = Convert.ToDecimal(dt.Rows[0]["Unusualstandard_DEGRADE_MOISTURE_PERCT"]); d.DEGRADE_OUTTHROWS_PERCT = Convert.ToDecimal(dt.Rows[0]["DEGRADE_OUTTHROWS_PERCT"]); } //过数表填写数据 d.COMPANY_ID = "9"; d.CREATE_DTTM = d.WEIGHT_DATE = DateTime.Now; d.WEIGHT_TICKET_NO = txt_WEIGHT_TICKET_NO.Text.Trim(); d.REF_NO = txt_REF_NO.Text.Trim(); d.NO_OF_BALES = Convert.ToInt32(txtsendNum.Text.Trim()); d.DRAW_ONE = 0; d.DRAW_TWO = 0; d.DRAW_THREE = 0; d.DRAW_FOUR = 0; d.DRAW_FIVE = 0; d.DRAW_SIX = 0; d.DRAW_7 = 0; d.DRAW_8 = 0; d.DRAW_9 = 0; d.DRAW_10 = 0; d.DRAW_11 = 0; d.DRAW_12 = 0; d.DRAW_13 = 0; d.DRAW_14 = 0; d.IS_FINISHED = "Y"; d.CREATE_BY = Common.USERNAME; //记录人:当前登录人 d.IS_DengJi = "Y"; d.FINISHED_BY = ""; d.FINISHED_DTTM = Convert.ToDateTime("1900 - 01 - 01 00:00:00"); d.RECV_RMA_METHOD = ""; d.TRANS_TO_WPIS_FLAG = "Y"; d.TRANS_TO_WPIS_DTTM = DateTime.Now; d.TRANS_TO_DTS_FLAG = ""; d.TRANS_TO_DTS_DTTM = Convert.ToDateTime("1900 - 01 - 01 00:00:00"); //d.IsSource = "手动"; string[] dtsList = txtchkNum.Text.Split(','); for (int i = 0; i < dtsList.Length; i++) { switch (i) { case 0: d.DRAW_ONE = Convert.ToInt32(dtsList[i]); break; case 1: d.DRAW_TWO = Convert.ToInt32(dtsList[i]); break; case 2: d.DRAW_THREE = Convert.ToInt32(dtsList[i]); break; case 3: d.DRAW_FOUR = Convert.ToInt32(dtsList[i]); break; case 4: d.DRAW_FIVE = Convert.ToInt32(dtsList[i]); break; case 5: d.DRAW_SIX = Convert.ToInt32(dtsList[i]); break; case 6: d.DRAW_7 = Convert.ToInt32(dtsList[i]); break; case 7: d.DRAW_8 = Convert.ToInt32(dtsList[i]); break; case 8: d.DRAW_9 = Convert.ToInt32(dtsList[i]); break; case 9: d.DRAW_10 = Convert.ToInt32(dtsList[i]); break; case 10: d.DRAW_11 = Convert.ToInt32(dtsList[i]); break; case 11: d.DRAW_12 = Convert.ToInt32(dtsList[i]); break; case 12: d.DRAW_13 = Convert.ToInt32(dtsList[i]); break; case 13: d.DRAW_14 = Convert.ToInt32(dtsList[i]); break; } } int result = 0; DRAW_EXAM_INTERFACEDAL.InsertOneCarInfo(d, out result); if (result > 0) { //MessageBox.Show("添加成功!"); //this.Close(); // LoadData(); //查询新增过数ID //质检登记成功填写数据 int result2 = 0; r.OrganizationID = "ChongQingPaper"; r.R_DRAW_EXAM_INTERFACE_ID = result; r.DepartmentCode = txtBuMen_Code.Text.Trim(); r.ExtensionField2 = txtDuiWei_code.Text.Trim(); r.issend = false; RegisterLoosePaperDistributionDAL.InsertOneCarInfo(r, out result2); //质检表填写数据 int result3 = 0; c.QCInfo_Dictionary_ID = 8; c.QCInfo_STATE = 2; c.QCInfo_DEGREE = 1; c.QCInfo_UnpackBefore_MOIST_PER_COUNT = 0; c.QCInfo_UnpackBack_MOIST_COUNT = 0; c.QCInfo_TIME = DateTime.Now; //日期时间 c.QCInfo_Client_ID = Common.CLIENTID; //客户端配置编号 c.QCInfo_UserId = EMEWE.Common.Converter.ToInt(Common.USERID); //记录人:当前登录人 c.QCInfo_DRAW_EXAM_INTERFACE_ID = result; c.QCInfo_PumpingPackets = dtsList.Length; c.QCInfo_DRAW = txtchkNum.Text.Trim(); if (dtsList.Length <= 4) { c.QCInfo_MOIST_Count = dtsList.Length * 8; } else { c.QCInfo_MOIST_Count = 32; } QCInfoDAL.InsertOneCarInfo(c, out result3); if (result > 0) { MessageBox.Show("添加成功!"); int result4 = 0; p.Packets_DTS = txtchkNum.Text.Trim(); p.Packets_this = "1"; p.Packets_QCInfo_DRAW_EXAM_INTERFACE_ID = result; p.Packets_Time = DateTime.Now; PacketsDAL.InsertOneCarInfo(p, out result4); this.Close(); // LoadData(); } } } catch (Exception err) { } }
/// <summary> /// 登记方法 /// </summary> private void QcInfoAdd() { try { if (lvwUserList.SelectedRows.Count > 0) { int id = Convert.ToInt32(lvwUserList.SelectedRows[0].Cells["DRAW_EXAM_INTERFACE_ID"].Value); StringBuilder sbMessage = new StringBuilder(); int QCInfo_Dictionary_ID = 0; int QCInfo_STATE = 0; var dictionary = DictionaryDAL.Query(); foreach (var m in dictionary) { if (m.Dictionary_Name == "质检中") { QCInfo_Dictionary_ID = m.Dictionary_ID; } if (m.Dictionary_Name == "启动") { QCInfo_STATE = m.Dictionary_ID; //数据状态(启动) } } int irnt = 0; #region ykWarning: 和U9交互 纸种为 LSOP1的不和U9交互 ,测试的时候,可以删除U9交互,发布的时候务必要还原。 //#if !DEBUG string PROD_ID = lvwUserList.SelectedRows[0].Cells["PROD_ID"].Value.ToString(); if (isIdebarJoinU9(PROD_ID)) { DataSet ds = LinQBaseDao.Query("select SHIPMENT_NO,CNTR_NO from dbo.DRAW_EXAM_INTERFACE where DRAW_EXAM_INTERFACE_ID=" + id); if (ds.Tables[0].Rows.Count > 0) { string SHIPMENT_NO = ds.Tables[0].Rows[0][0].ToString(); if (!gainData(SHIPMENT_NO, id)) { string CNTR_NO = ds.Tables[0].Rows[0][0].ToString(); MessageBox.Show(CNTR_NO + "从U9获取数据失败,不能登记!"); return; } } else { MessageBox.Show("登记失败!"); return; } } else { DataSet ds = LinQBaseDao.Query("select SHIPMENT_NO,CNTR_NO from dbo.DRAW_EXAM_INTERFACE where DRAW_EXAM_INTERFACE_ID=" + id); if (ds.Tables[0].Rows.Count > 0) { RegisterLoosePaperDistribution rpdb = new RegisterLoosePaperDistribution(); rpdb.R_DRAW_EXAM_INTERFACE_ID = id; rpdb.issend = false; LinQBaseDao.InsertOne(dc, rpdb); } } //#endif #endregion if (YesNoDengJi(id)) { MessageBox.Show("该信息已登记过", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); Bangding_Load(RegistrationWhere());//更新数据 ids.Clear(); return; } var qf = new QCInfo(); qf.QCInfo_Dictionary_ID = QCInfo_Dictionary_ID; qf.QCInfo_STATE = QCInfo_STATE; int k = QCInfoDAL.GetIntDRAWCount(id);//抽样总次数 qf.QCInfo_PumpingPackets = k; #region 周意 规则加上后需要修改 //e ReckonWaterTestCount(qf.QCInfo_ID); qf.QCInfo_UnpackBefore_MOIST_PER_COUNT = OneCQCount + TwoCQCount; qf.QCInfo_UnpackBack_MOIST_COUNT = OneCHCount + TwoCHCount; #endregion qf.QCInfo_DRAW_EXAM_INTERFACE_ID = id; qf.QCInfo_DEGREE = 1; //检测次数 qf.QCInfo_TIME = DateTime.Now; //日期时间 qf.QCInfo_Client_ID = Common.CLIENTID; //客户端配置编号 qf.QCInfo_UserId = EMEWE.Common.Converter.ToInt(Common.USERID); //记录人:当前登录人 //修改抽样表状态 Action <DRAW_EXAM_INTERFACE> ap = n => { //liemrao begin update 20160901 //n.IS_DengJi = Convert.ToChar("Y"); n.IS_DengJi = "Y"; //end update }; Expression <Func <DRAW_EXAM_INTERFACE, bool> > p1 = n => n.DRAW_EXAM_INTERFACE_ID == id; bool rboolDRAW_EXAM_INTERFACEDAL = DRAW_EXAM_INTERFACEDAL.Update(p1, ap); if (rboolDRAW_EXAM_INTERFACEDAL) { if (QCInfoDAL.addQCInfoDAL(qf)) { irnt++; sbMessage.Append(id + ","); Common.WriteLogData("新增", "登记数据抽样编号为:" + id, Common.NAME); //操作日志 #region 抽包 getPackets(qf.QCInfo_ID, id); #endregion } else { //修改抽样表状态 Action <DRAW_EXAM_INTERFACE> ap2 = n => { n.IS_DengJi = null; }; Expression <Func <DRAW_EXAM_INTERFACE, bool> > p2 = n => n.DRAW_EXAM_INTERFACE_ID == id; DRAW_EXAM_INTERFACEDAL.Update(p2, ap2); } } if (!string.IsNullOrEmpty(sbMessage.ToString())) { DialogResult dia = MessageBox.Show("登记数据抽样编号为:" + sbMessage.ToString() + "成功\r\n是否现场抽包?", "系统提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dia.Equals(DialogResult.Yes)) { tChoosePacks.Enabled = false; ChoosePacks(); tChoosePacks.Enabled = true; } } else//没有选中 { MessageBox.Show("请选择列表再开始质检!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } catch { MessageBox.Show("登记失败", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { page = new PageControl(); page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString(); Bangding_Load(RegistrationWhere());//更新数据 } }