private void BindLevel() { this.lueLevel.EditValue = string.Empty; IVTestDataEntity IVTestDateObject = new IVTestDataEntity(); DataSet dsLeve = IVTestDateObject.GetBasicData("ProductGrade", "", "", ""); if (string.IsNullOrEmpty(IVTestDateObject.ErrorMsg)) { if (dsLeve != null) { this.lueLevel.Properties.DataSource = dsLeve.Tables[0]; this.lueLevel.Properties.DisplayMember = "COLUMN_NAME"; this.lueLevel.Properties.ValueMember = "COLUMN_CODE"; this.lueLevel.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("COLUMN_NAME")); } else { this.lueLevel.Properties.DataSource = null; } } else { MessageService.ShowError(IVTestDateObject.ErrorMsg); this.lueLevel.Properties.DataSource = null; return; } }
private void btnQuery_Click(object sender, EventArgs e) { string sSN, sRCodeName, sRCodeKey, sRCategoryCode, sRCategoryKey, sRoomKey, sLevelCode, sLevelName, sRemark; string sFactoryV, sFccode2V, sCustomCodeV, sCheckTimeV, sWorkNumV, sProIDV, sLotColorV, sGradCodeV, sGradV, sWorkStationV, sShiftKey; sSN = ""; sRCodeName = ""; sRCodeKey = ""; sRCategoryCode = ""; sRCategoryKey = ""; sRoomKey = ""; sLevelCode = ""; sLevelName = ""; sRemark = ""; sFactoryV = ""; sFccode2V = ""; sCustomCodeV = ""; sCheckTimeV = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); sWorkNumV = ""; sProIDV = ""; sLotColorV = ""; sGradV = ""; sWorkStationV = ""; sGradCodeV = ""; sShiftKey = ""; sRoomKey = lueFactoryRoom.EditValue.ToString(); sSN = txtLotNumber.Text.Trim(); sRCategoryCode = lueRCategory.Text.Trim(); if (lueRCategory.EditValue != null) { sRCategoryKey = lueRCategory.EditValue.ToString(); } sRCodeName = lue_NG_Code.Text.Trim(); if (lue_NG_Code.EditValue != null) { sRCodeKey = lue_NG_Code.EditValue.ToString(); } if (lueLevel.EditValue != null) { sLevelCode = lueLevel.EditValue.ToString(); } sLevelName = lueLevel.Text.Trim(); sRemark = cobRemark.Text.Trim(); if (string.IsNullOrEmpty(sRoomKey)) { MessageService.ShowMessage(StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.LotOutQuantityAssurance.Msg001}"));//厂别未选择,请确认! //MessageService.ShowMessage("厂别未选择,请确认!"); return; } if (string.IsNullOrEmpty(sSN)) { MessageService.ShowMessage(StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.LotOutQuantityAssurance.Msg002}"));//组件序号为空,请确认! //MessageService.ShowMessage("组件序号为空,请确认!"); return; } IVTestDataEntity IVTestDateObject = new IVTestDataEntity(); DataSet dsCustCheck = new DataSet(); if (chCustomCode.Checked == true) { dsCustCheck = IVTestDateObject.GetCustCheckData("", sSN, sRoomKey); } else { dsCustCheck = IVTestDateObject.GetCustCheckData(sSN, "", sRoomKey); } if (string.IsNullOrEmpty(IVTestDateObject.ErrorMsg)) { if (dsCustCheck.Tables[0].Rows.Count < 1) { MessageService.ShowMessage(StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.LotOutQuantityAssurance.Msg003}"));//组件未过终检,不能抽检,请确认! //MessageService.ShowMessage("组件未过终检,不能抽检,请确认!"); return; } else { sFactoryV = lueFactoryRoom.Text.Trim(); sFccode2V = dsCustCheck.Tables[0].Rows[0]["CC_FCODE2"].ToString(); sCustomCodeV = dsCustCheck.Tables[0].Rows[0]["CUSTOMCODE"].ToString(); sWorkNumV = dsCustCheck.Tables[0].Rows[0]["WORKNUMBER"].ToString(); sProIDV = dsCustCheck.Tables[0].Rows[0]["PRO_ID"].ToString(); sLotColorV = dsCustCheck.Tables[0].Rows[0]["LOT_COLOR"].ToString(); sGradCodeV = dsCustCheck.Tables[0].Rows[0]["PRO_LEVEL"].ToString(); sShiftKey = dsCustCheck.Tables[0].Rows[0]["SHIFT_KEY"].ToString(); sWorkStationV = dsCustCheck.Tables[0].Rows[0]["SHIFT_NAME"].ToString(); } } else { MessageService.ShowError(IVTestDateObject.ErrorMsg); return; } DataSet dsGraed = IVTestDateObject.GetBasicData("ProductGrade", sGradCodeV, "", ""); sGradV = dsGraed.Tables[0].Rows[1]["COLUMN_NAME"].ToString(); DataSet dsConsigmentData = new DataSet(); if (chCustomCode.Checked == true) { dsConsigmentData = IVTestDateObject.GetConsigmentDataBySN("", "", sSN, sRoomKey); } else { dsConsigmentData = IVTestDateObject.GetConsigmentDataBySN(sSN, "", "", sRoomKey); } if (string.IsNullOrEmpty(IVTestDateObject.ErrorMsg)) { if (dsConsigmentData.Tables[0].Rows.Count > 0) { MessageService.ShowMessage(StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.LotOutQuantityAssurance.Msg004}"));//组件已包装,不能抽检,请确认! //MessageService.ShowMessage("组件已包装,不能抽检,请确认!"); return; } } else { MessageService.ShowError(IVTestDateObject.ErrorMsg); return; } string sql = string.Empty; sql = "UPDATE WIP_CUSTCHECK SET ISFLAG='0'"; sql += " WHERE ISFLAG='1' AND CC_DATA_GROUP='O'"; sql += " AND ROOM_KEY='" + sRoomKey + "'"; if (chCustomCode.Checked == true) { sql += " AND CUSTOMCODE='" + sSN + "'"; } else { sql += " AND CC_FCODE1='" + sSN + "'"; } DataSet dsUOQA = IVTestDateObject.UpdateData(sql, "UpdateOQA"); if (!string.IsNullOrEmpty(IVTestDateObject.ErrorMsg)) { MessageService.ShowError(IVTestDateObject.ErrorMsg); return; } DataSet dsSEQ = new DataSet(); if (chCustomCode.Checked == true) { dsSEQ = IVTestDateObject.GetCustCheckSEQ("", sSN, sRoomKey); } else { dsSEQ = IVTestDateObject.GetCustCheckSEQ(sSN, "", sRoomKey); } if (!string.IsNullOrEmpty(IVTestDateObject.ErrorMsg)) { MessageService.ShowError(IVTestDateObject.ErrorMsg); return; } int nSEQ = int.Parse(dsSEQ.Tables[0].Rows[0]["SEQ"].ToString()); string sUID = PropertyService.Get(PROPERTY_FIELDS.USER_NAME); string key = FanHai.Hemera.Share.Common.CommonUtils.GenerateNewKey(0); sql = "INSERT INTO WIP_CUSTCHECK(CUSTCHECK_KEY,CC_DATA_GROUP,CUSTOMCODE,l_ID,CHECK_TIME,CC_FCODE1,WORKNUMBER,PRO_ID,LOT_COLOR,PRO_LEVEL,CREATER,CREATE_TIME,ISFLAG,ROOM_KEY,SHIFT_KEY,SHIFT_NAME,REMARK,REASON_CODE_NAME,REASON_CODE_KEY,REASON_CODE_CATEGORY_NAME,REASON_CODE_CATEGORY_KEY)"; sql += " VALUES('" + key + "','O','" + sCustomCodeV + "','" + nSEQ.ToString() + "',GETDATE(),'" + sFccode2V + "','" + sWorkNumV + "'"; sql += ",'" + sProIDV + "','" + sLotColorV + "','" + sGradCodeV + "','" + sUID + "',GETDATE(),'1','" + sRoomKey + "','" + sShiftKey + "'"; sql += ",'" + sWorkStationV + "','" + sRemark + "','" + sRCodeName + "','" + sRCategoryKey + "','" + sRCategoryCode + "','" + sRCategoryKey + "')"; DataSet dsAddOQA = IVTestDateObject.AddData(sql, "AddOQA"); if (!string.IsNullOrEmpty(IVTestDateObject.ErrorMsg)) { MessageService.ShowError(IVTestDateObject.ErrorMsg); return; } int nAddOQA = int.Parse(dsAddOQA.ExtendedProperties["rows"].ToString()); if (nAddOQA < 1) { MessageService.ShowMessage(StringParser.Parse("${res:FanHai.Hemera.Addins.WIP.LotOutQuantityAssurance.Msg005}"));//添加OQA数据失败! //MessageService.ShowMessage("添加OQA数据失败!", "提示"); return; } txtLotNumber.SelectAll(); txtLotNumber.Focus(); dsOQA.Tables[0].Rows.Add(sFactoryV, sFccode2V, sCustomCodeV, sCheckTimeV, sWorkNumV, sProIDV, sLotColorV, sGradV, sWorkStationV, sRCategoryCode, sRCodeName, sUID, sRemark); gcOQAData.DataSource = null; gcOQAData.DataSource = dsOQA.Tables[0]; lblTot.Text = "TOT:" + dsOQA.Tables[0].Rows.Count.ToString(); //清除查询数据集 dsQueryOQA.Clear(); }