/// <summary> /// 临时类转换 /// </summary> /// <param name="rCMakeDetail"></param> /// <returns></returns> private IList <SpotAssay> DataChange(IList <CmcsRCAssay> rCAssay) { IList <SpotAssay> spotAssays = new List <SpotAssay>(); foreach (CmcsRCAssay item in rCAssay) { SpotAssay entity = new SpotAssay(); CmcsRCAssay assay_old = czyHandlerDAO.GetAssayBySpotMakeId(item.MakeId); if (assay_old != null) { entity.AssayCode = assay_old.AssayCode; } entity.SpotAssayCode = item.AssayCode; entity.AssayId = item.Id; entity.AssayPoint = item.AssayPoint; try { entity.BackBatchDate = item.TheRcMake.TheRcSampling.TheInFactoryBatch.BACKBATCHDATE.ToString("yyyy-MM-dd HH:mm:ss"); } catch { entity.BackBatchDate = item.TheRcMake.UseTime.ToString("yyyy-MM-dd HH:mm:ss"); } entity.CheckUser = item.AssayPle; entity.SpotCount = czyHandlerDAO.GetSpotCountBySpotMakeId(item.TheRcMake.Id, item.AssayCode); entity.CheckUser = item.AssayPle; entity.PrintTime = item.PrintTime.ToString("yyyy-MM-dd HH:mm:ss"); spotAssays.Add(entity); } return(spotAssays); }
private void btnSubmit_Click(object sender, EventArgs e) { string Message = string.Empty; if (!cZYHandlerDAO.CheckSpotAssay(AssayCode, ref Message)) { MessageBoxEx.Show(Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (string.IsNullOrWhiteSpace(this.assayTarget)) { MessageBoxEx.Show("请选择化验指标!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } CmcsRCAssay entity = CommonDAO.GetInstance().SelfDber.Entity <CmcsRCAssay>("where AssayCode=:AssayCode order by CreateDate desc", new { AssayCode = AssayCode }); if (cZYHandlerDAO.CreateSpotAssay(entity, SelfVars.LoginUserNames, SelfVars.LoginUserAccounts, this.assayTarget.TrimEnd(','), cmbAssayType.Text, ref this.From.CurrentAssay)) { if (MessageBoxEx.Show("生成抽查样成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning) == DialogResult.OK) { this.Close(); this.DialogResult = DialogResult.OK; } } else { if (MessageBoxEx.Show("生成抽查样失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning) == DialogResult.OK) { this.Close(); this.DialogResult = DialogResult.OK; } } }
/// <summary> /// 保存工业分析仪数据 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int SaveToProximateStdAssay(HYTBPAG_5EMAG6700 entity) { int res = 0; if (entity == null) { return(res); } CmcsRCAssay assay = selfDber.Entity <CmcsRCAssay>("where AssayCode=:AssayCode order by CreateDate", new { AssayCode = entity.SampleName }); if (assay != null && assay.AssayDate.Year < 2000) { assay.AssayDate = entity.Date_Ex; selfDber.Update(assay); } CmcsProximateStdAssay present = selfDber.Entity <CmcsProximateStdAssay>("where PKID=:PKID", new { PKID = entity.PKID }); if (present == null) { present = new CmcsProximateStdAssay(); present.PKID = entity.PKID; present.SampleNumber = entity.SampleName; present.ContainerWeight = entity.EmptyGGWeight; present.SampleWeight = entity.ColeWeight; present.Vad = entity.Vad; present.Mad = entity.Mad; present.Aad = entity.Aad; present.AssayUser = entity.Operator; present.AssayTime = entity.Date_Ex; present.FacilityNumber = entity.MachineCode; present.OrderNumber = entity.ObjCode; present.DataType = "原始数据"; return(selfDber.Insert(present)); } if (present.IsEffective == 1) { return(res); } present.ContainerWeight = entity.EmptyGGWeight; present.SampleWeight = entity.ColeWeight; present.Vad = entity.Vad; present.Mad = entity.Mad; present.Aad = entity.Aad; if (present.IsHandModify != "1") { present.SampleNumber = entity.SampleName; present.AssayUser = entity.Operator; } present.AssayTime = entity.Date_Ex; present.FacilityNumber = entity.MachineCode; present.OrderNumber = entity.ObjCode; present.DataType = "原始数据"; return(selfDber.Update(present)); }
/// <summary> /// 根据化验码获取化验指标 /// </summary> /// <param name="assayCode"></param> /// <returns></returns> public string GetAssayPointByAssayCode(string assayCode) { string assayPoint = string.Empty; CmcsRCAssay rCAssay = Dbers.GetInstance().SelfDber.Entity <CmcsRCAssay>("where AssayCode=:AssayCode", new { AssayCode = assayCode }); if (rCAssay != null) { assayPoint = rCAssay.AssayPoint; } return(assayPoint); }
/// <summary> /// 根据化验编码获取抽查样编码 /// </summary> /// <param name="assayCode"></param> /// <returns></returns> public string GetSpotAssayCodeByAssayCode(string assayCode) { CmcsRCAssay entity = commonDAO.SelfDber.Entity <CmcsRCAssay>("where AssayCode=:AssayCode order by CreateDate desc", new { AssayCode = assayCode }); if (entity != null) { CmcsRCAssay entity_spot = commonDAO.SelfDber.Entity <CmcsRCAssay>("where MakeId=:MakeId and AssayWay='抽查样化验' order by CreateDate desc", new { MakeId = entity.TheRcMake.Id }); if (entity_spot != null) { return(entity_spot.AssayCode); } } return(""); }
/// <summary> /// 重置 /// </summary> private void Restet() { this.CurrentFlowFlag = eFlowFlag.等待扫码; this.currentMakeDetail = null; this.RCAssay = null; txtInputMakeCode.ButtonCustom.Enabled = false; txtInputMakeCode.ResetText(); rtxtMakeCheckInfo.ResetText(); // 方便客户快速使用,获取焦点 txtInputMakeCode.Focus(); }
/// <summary> /// 根据化验码转换制样码 /// </summary> /// <param name="assayCode"></param> /// <returns></returns> public string GetMakeCodeByAssayCode(string assayCode) { string makeCode = string.Empty; CmcsRCAssay rCAssay = Dbers.GetInstance().SelfDber.Entity <CmcsRCAssay>("where AssayCode=:AssayCode", new { AssayCode = assayCode }); if (rCAssay != null) { CmcsRCMake rCMake = Dbers.GetInstance().SelfDber.Get <CmcsRCMake>(rCAssay.MakeId); if (rCMake != null) { makeCode = rCMake.MakeCode; } } return(makeCode); }
/// <summary> /// 制样明细码转换化验码 /// </summary> /// <param name="makeCode"></param> /// <returns></returns> public string MakeDetailCodeToAssayCode(string makeDetailCode) { CmcsRCMakeDetail makeDetail = Dbers.GetInstance().SelfDber.Entity <CmcsRCMakeDetail>("where BarrelCode=:BarrelCode order by CreateDate desc", new { BarrelCode = makeDetailCode }); if (makeDetail != null) { CmcsRCAssay assay = Dbers.GetInstance().SelfDber.Entity <CmcsRCAssay>("where MakeId=:MakeId", new { MakeId = makeDetail.MakeId }); if (assay != null) { return(assay.AssayCode); } } return(string.Empty); }
/// <summary> /// 制样码转换化验码 /// </summary> /// <param name="makeCode"></param> /// <returns></returns> public string MakeCodeToAssayCode(string makeCode) { CmcsRCMake make = Dbers.GetInstance().SelfDber.Entity <CmcsRCMake>("where MakeCode=:MakeCode", new { MakeCode = makeCode }); if (make == null) { return(string.Empty); } CmcsRCAssay assay = Dbers.GetInstance().SelfDber.Entity <CmcsRCAssay>("where MakeId=:MakeId", new { MakeId = make.Id }); if (assay != null) { return(assay.AssayCode); } return(string.Empty); }
/// <summary> /// 根据制样明细码获取化验码 /// </summary> /// <param name="makeCode"></param> /// <returns></returns> public string GetAssayCodeByMakeDetailCode(string makedetailCode) { string assayCode = string.Empty; CmcsRCMakeDetail makedetail = CommonDAO.GetInstance().SelfDber.Entity <CmcsRCMakeDetail>("where BarrelCode=:BarrelCode order by CreateDate desc", new { BarrelCode = makedetailCode }); if (makedetail != null) { string makeid = makedetail.TheRCMake.Id; CmcsRCAssay assay = CommonDAO.GetInstance().SelfDber.Entity <CmcsRCAssay>("where MakeId=:MakeId", new { MakeId = makeid }); if (assay != null) { assayCode = assay.AssayCode; } } return(assayCode); }
/// <summary> /// 键入Enter检测有效性 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void txtMakeCheckCode_KeyUp(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { if (ReadRwer.Status) { txtInputMakeCode.Text = ReadRf(); } // 根据输入制样码查找制样明细记录 if (!String.IsNullOrEmpty(txtInputMakeCode.Text.Trim())) { this.currentMakeDetail = czyHandlerDAO.GetRCMakeDetail(txtInputMakeCode.Text.Trim(), out resMessage); if (this.currentMakeDetail != null) { ShowMessage("扫码成功,样品类型:" + this.currentMakeDetail.SampleType + " 样罐编码:" + this.currentMakeDetail.SampleCode, eOutputType.Normal); this.RCAssay = czyHandlerDAO.GetRCAssayByMakeCode(this.currentMakeDetail.Id); if (this.RCAssay != null) { txtInputMakeCode.ButtonCustom.Enabled = true; // 需要称重校验 if (IsUseWeight) { this.CurrentFlowFlag = eFlowFlag.等待校验; ShowMessage("将样品放入台秤完成校验", eOutputType.Normal); } // 不需要称重校验,直接打印化验码 else { PrintAssayCode(); } } else { ShowMessage("未找到化验记录,无法打印化验码", eOutputType.Error); txtInputMakeCode.ResetText(); } } else { ShowMessage(resMessage, eOutputType.Error); txtInputMakeCode.ResetText(); } } } }
public bool CreateAssay(CmcsRCMake rCMake) { // 入厂煤化验 CmcsRCAssay rCAssay = CommonDAO.GetInstance().SelfDber.Entity <CmcsRCAssay>("where MakeId=:MakeId and AssayWay='监督样化验'", new { MakeId = rCMake.Id }); if (rCAssay == null) { // 入厂煤煤质 CmcsFuelQuality fuelQuality = new CmcsFuelQuality() { Id = Guid.NewGuid().ToString(), Mt = Convert.ToDecimal(dbiMt.Value) }; if (CommonDAO.GetInstance().SelfDber.Insert(fuelQuality) > 0) { rCAssay = new CmcsRCAssay() { MakeId = rCMake.Id, AssayType = eAssayType.级编码化验.ToString(), AssayWay = eAssayType.监督样化验.ToString(), AssayCode = CommonDAO.GetInstance().CreateNewAssayCode(rCMake.CreateDate), FuelQualityId = fuelQuality.Id, AssayPle = "", WfStatus = 0, BackBatchDate = rCMake.UseTime, AssayPoint = this.assayTarget.TrimEnd(',') }; return(CommonDAO.GetInstance().SelfDber.Insert(rCAssay) > 0); } } else { rCAssay.AssayPoint = this.assayTarget.TrimEnd(','); CmcsFuelQuality fuelQuality = rCAssay.TheFuelQuality; if (fuelQuality != null) { fuelQuality.Mt = Convert.ToDecimal(dbiMt.Value); CommonDAO.GetInstance().SelfDber.Update(fuelQuality); } return(CommonDAO.GetInstance().SelfDber.Update(rCAssay) > 0); } return(false); }
/// <summary> /// 更改制样送样人 /// </summary> /// <param name="rCMakeDetail"></param> /// <param name="userName"></param> /// <returns></returns> public bool UpdateSendPle(CmcsRCMakeDetail rCMakeDetail, string userName) { CmcsRCAssay assay = Dbers.GetInstance().SelfDber.Entity <CmcsRCAssay>("where MakeId=:MakeId order by CreateDate desc", new { MakeId = rCMakeDetail.MakeId }); if (assay != null) { assay.SendPle = userName; //更新制样人 CmcsRCMake make = Dbers.GetInstance().SelfDber.Entity <CmcsRCMake>("where SamplingId=:SamplingId order by CreateDate desc", new { SamplingId = rCMakeDetail.TheRCMake.SamplingId }); if (make != null) { make.MakePle = userName; make.MakeEndTime = DateTime.Now; Dbers.GetInstance().SelfDber.Update(make); } return(Dbers.GetInstance().SelfDber.Update(assay) > 0); } return(false); }
/// <summary> /// 根据制样码加载化验码及制样明细 /// </summary> /// <param name="makeCode"></param> private void LoadCode() { txtInputSpotAssayCode.Text = czyHandlerDAO.GetSpotAssayCodeByAssayCode(txtInputAssayCode.Text); this.CurrentAssay = commonDAO.SelfDber.Entity <CmcsRCAssay>("where AssayCode=:AssayCode", new { AssayCode = this.txtInputSpotAssayCode.Text }); #region DotNetBar this.picEncode.Image = QRCodeBar(this.txtInputSpotAssayCode.Text.Trim()); this.picEncode.Width = 200; this.picEncode.Height = 200; #endregion #region 第三方插件 //this.picEncode.Image = QRCode(this.txtInputAssayCode.Text.Trim(), 4); //picEncode.Width = this.picEncode.Image.Width; //picEncode.Height = this.picEncode.Image.Height; #endregion LoadDetail(); }
/// <summary> /// 检测是否能生成抽查样 /// </summary> /// <param name="assayCode"></param> /// <param name="message"></param> /// <returns></returns> public bool CheckSpotAssay(string assayCode, ref string message) { CmcsRCAssay assay = CommonDAO.GetInstance().SelfDber.Entity <CmcsRCAssay>("where AssayCode=:AssayCode order by CreateDate desc", new { AssayCode = assayCode }); if (assay == null) { message = "未找到此化验编码对应的化验记录!"; return(false); } if (assay.TheRcMake == null) { message = "未找到此化验编码对应的化验记录!"; return(false); } if (assay == null) { message = "未找到此化验编码对应的制样记录!"; return(false); } if (assay.TheRcMake != null && assay.TheRcMake.StayStatus == 1) { message = "此化验编码对应的制样记录为留样,不能进行操作!"; return(false); } if (assay.WfStatus != 2) { message = "此化验编码对应的化验记录必须流程结束后才可以进行此操作!"; return(false); } if (assay.AssayWay == "煤场化验") { message = "此化验编码对应的化验记录为煤场化验,不能进行此操作!"; return(false); } if (assay.AssayWay == "抽查样化验") { message = "此记录是抽查样化验,不能进行抽查样操作!"; return(false); } return(true); }
/// <summary> /// 临时类转换 /// </summary> /// <param name="rCMakeDetail"></param> /// <returns></returns> private SpotAssay DataChange(CmcsRCAssay rCAssay) { SpotAssay entity = new SpotAssay(); CmcsRCAssay assay_old = czyHandlerDAO.GetAssayBySpotMakeId(rCAssay.MakeId); if (assay_old != null) { entity.AssayCode = assay_old.AssayCode; } entity.SpotAssayCode = rCAssay.AssayCode; entity.AssayId = rCAssay.Id; entity.AssayPoint = rCAssay.AssayPoint; entity.BackBatchDate = rCAssay.TheRcMake.TheRcSampling != null?rCAssay.TheRcMake.TheRcSampling.TheInFactoryBatch.BACKBATCHDATE.ToString("yyyyMMdd HH:mm:ss") : rCAssay.TheRcMake.MakeStartTime.ToString("yyyyMMdd HH:mm:ss"); entity.CheckUser = rCAssay.AssayPle; entity.SpotCount = czyHandlerDAO.GetSpotCountBySpotMakeId(rCAssay.TheRcMake.Id, rCAssay.AssayCode); entity.CheckUser = rCAssay.AssayPle; return(entity); }
/// <summary> /// 解绑化验单及化验操作 /// </summary> /// <param name="makeCode"></param> /// <returns></returns> public bool RelieveAssay(CmcsRCMakeDetail makeDetail, string makeCreateUser, string assayCheckUser) { CmcsRCAssay assay = Dbers.GetInstance().SelfDber.Entity <CmcsRCAssay>("where MakeId=:MakeId order by CreateDate desc", new { MakeId = makeDetail.MakeId }); if (assay != null) { assay.IsRelieve = 1; assay.GetPle = assayCheckUser; assay.SendPle = makeCreateUser; if (assay.AssayType == "三级编码化验" && makeDetail.SampleType.ToLower().Contains("6mm")) { assay.SendDate = DateTime.Now; } else if ((assay.AssayType == "复查样化验" || assay.AssayType == "抽查样化验") && makeDetail.SampleType.ToLower().Contains("0.2mm")) { assay.SendDate = DateTime.Now; } if (makeDetail.SampleType.ToLower().Contains("0.2mm") && assay.GetDate.Year < 2000) { assay.GetDate = DateTime.Now; } if (makeDetail.PrintCount == 0) { if (string.IsNullOrEmpty(assay.GetPle)) { assay.GetPle = assayCheckUser; } else { assay.GetPle += "," + assayCheckUser; } } return(Dbers.GetInstance().SelfDber.Update <CmcsRCAssay>(assay) > 0); } return(false); }
/// <summary> /// 生成抽查样 /// </summary> /// <param name="assay">原化验记录</param> /// <param name="UserName">操作人</param> /// <param name="assayPoint">化验指标</param> /// <param name="PreFix">化验类型</param> /// <returns></returns> public bool CreateSpotAssay(CmcsRCAssay entity, string userName, string userAccount, string assayPoint, string PreFix, ref CmcsRCAssay assay) { try { assay = new CmcsRCAssay(); assay.AssayPoint = assayPoint; assay.AssayType = "三级编码化验"; assay.SendDate = GlobalVars.ServerNowDateTime; //assay.AssayDate = GlobalVars.ServerNowDateTime; CmcsRCMake make = entity.TheRcMake; if (make.TheRcSampling != null && make.TheRcSampling.TheInFactoryBatch != null) { assay.InFactoryBatchId = make.TheRcSampling.TheInFactoryBatch.Id; } assay.MakeId = make.Id; assay.IsRelieve = 1; assay.AssayPle = userName; assay.AssayCode = CommonDAO.GetInstance().CreateNewAssayCode(DateTime.Now); assay.AssayWay = PreFix; assay.Remark = "由化验室接样程序手动生成"; assay.ParentId = entity.Id; assay.BackBatchDate = entity.BackBatchDate; CmcsFuelQuality quality_new = new CmcsFuelQuality(); CmcsRCAssay assay_new = CommonDAO.GetInstance().SelfDber.Entity <CmcsRCAssay>("where MakeId=:MakeId order by CreateDate desc", new { MakeId = make.Id }); if (assay_new != null) { quality_new = (CmcsFuelQuality)Clone(assay_new.TheFuelQuality); } quality_new.CreateDate = quality_new.OperDate = DateTime.Now; if (assayPoint.Contains("全水分") || assayPoint.Contains("全指标") || assayPoint.Contains("日常分析")) { quality_new.Mar = 0; } if (assayPoint.Contains("空干基水分") || assayPoint.Contains("全指标") || assayPoint.Contains("日常分析")) { quality_new.Mad = 0; quality_new.FCad = 0; } if (assayPoint.Contains("灰分") || assayPoint.Contains("全指标") || assayPoint.Contains("日常分析")) { quality_new.Aad = 0; quality_new.Ad = 0; quality_new.Aar = 0; quality_new.FCad = 0; } if (assayPoint.Contains("挥发分") || assayPoint.Contains("全指标") || assayPoint.Contains("日常分析")) { quality_new.Vad = 0; quality_new.Vdaf = 0; quality_new.Vd = 0; quality_new.Var = 0; quality_new.FCad = 0; } if (assayPoint.Contains("全硫") || assayPoint.Contains("全指标") || assayPoint.Contains("日常分析")) { quality_new.Stad = 0; quality_new.Star = 0; quality_new.Std = 0; quality_new.Sd = 0; } if (assayPoint.Contains("热值") || assayPoint.Contains("全指标") || assayPoint.Contains("日常分析")) { quality_new.QbAd = 0; quality_new.Qgrad = 0; quality_new.Qgrar = 0; quality_new.Qgrd = 0; quality_new.QCal = 0; quality_new.QJ = 0; } if (assayPoint.Contains("氢值") || assayPoint.Contains("全指标") || assayPoint.Contains("日常分析")) { quality_new.Hd = 0; quality_new.Had = 0; quality_new.Har = 0; } if (assayPoint.Contains("灰熔融") || assayPoint.Contains("全指标")) { quality_new.DT = 0; quality_new.HT = 0; quality_new.FT = 0; quality_new.ST = 0; } quality_new.Id = Guid.NewGuid().ToString(); quality_new.CreateUser = userAccount; quality_new.OperUser = userAccount; assay.FuelQualityId = quality_new.Id; Dbers.GetInstance().SelfDber.Insert(quality_new); Dbers.GetInstance().SelfDber.Insert(assay); return(true); } catch (Exception) { return(false); } }
private void FrmJDYMake_Oper_Load(object sender, EventArgs e) { InitFrom(); superGridControl1.PrimaryGrid.AutoGenerateColumns = false; txt_GetPle.Text = SelfVars.LoginUser.UserName; txt_MakePle.Text = SelfVars.LoginUser.UserName; if (!String.IsNullOrEmpty(id)) { this.cmcsMake = Dbers.GetInstance().SelfDber.Get <CmcsRCMake>(this.id); if (this.cmcsMake != null) { CmcsRCAssay assay = this.cmcsMake.TheRcAssay; if (assay != null) { if (assay.AssayPoint == "全指标") { rbtnAll.Checked = true; } else if (assay.AssayPoint == "日常分析") { rbtnNormal.Checked = true; } else { rbtnHandChoose.Checked = true; string[] assayPoint = assay.AssayPoint.Split(','); System.Windows.Forms.Control.ControlCollection controls = panelAssayTarget.Controls; foreach (Control item in controls) { CheckBoxX check = (CheckBoxX)item; if (assayPoint.Contains(check.Text)) { check.Checked = true; } } } if (assay.TheFuelQuality != null) { dbiMt.Value = Convert.ToDouble(assay.TheFuelQuality.Mt); } } txt_GetPle.Text = cmcsMake.GetPle; txt_MakeCode.Text = cmcsMake.MakeCode; txt_MakePle.Text = cmcsMake.MakePle; txt_SendUnit.Text = cmcsMake.SendUnit; txt_MakePle.Text = cmcsMake.MakePle; dt_UseTime.Value = cmcsMake.UseTime; dt_GetDate.Value = cmcsMake.GetDate; dt_MakeEndTime.Value = cmcsMake.MakeEndTime; dbi_GetBarrelWeight.Value = Convert.ToDouble(cmcsMake.GetBarrelWeight); dt_MakeStartTime.Value = cmcsMake.MakeStartTime; txt_Remark.Text = cmcsMake.Remark; IList <CmcsRCMakeDetail> details = CommonDAO.GetInstance().SelfDber.Entities <CmcsRCMakeDetail>("where MakeId=:MakeId", new { MakeId = this.id }); this.cmcsMakeDetail = details; } } if (!edit) { btnSubmit.Enabled = false; btn_CreateMakeDetail.Enabled = false; CMCS.WeighCheck.SampleMake.Utilities.Helper.ControlReadOnly(panelEx2); CMCS.WeighCheck.SampleMake.Utilities.Helper.ControlReadOnly(superGridControl1); } }
/// <summary> /// 创建采制化三级数据 /// </summary> /// <param name="inFactoryBatch">批次</param> /// <param name="samplingType">采样方式</param> /// <param name="remark">备注</param> /// <param name="assayType">化验方式</param> /// <returns></returns> public CmcsRCSampling GCSamplingMakeAssay(CmcsInFactoryBatch inFactoryBatch, string samplingType, string remark) { bool isSuccess = false; // 入厂煤采样 CmcsRCSampling rCSampling = SelfDber.Entity <CmcsRCSampling>("where InFactoryBatchId=:InFactoryBatchId and SamplingType=:SamplingType and IsDeleted=0", new { InFactoryBatchId = inFactoryBatch.Id, SamplingType = samplingType }); if (rCSampling == null) { rCSampling = new CmcsRCSampling() { InFactoryBatchId = inFactoryBatch.Id, SamplingType = samplingType, SamplingDate = inFactoryBatch.FactArriveDate, SamplingPle = "自动", SampleCode = CreateNewSampleCode(inFactoryBatch.FactArriveDate), Remark = remark }; isSuccess = SelfDber.Insert(rCSampling) > 0; } // 入厂煤制样 CmcsRCMake rCMake = SelfDber.Entity <CmcsRCMake>("where SamplingId=:SamplingId and IsDeleted=0", new { SamplingId = rCSampling.Id }); if (rCMake == null) { rCMake = new CmcsRCMake() { SamplingId = rCSampling.Id, MakeType = "三级编码制样", MakeStyle = "机器制样", MakeDate = rCSampling.SamplingDate, MakeCode = CreateNewMakeCode(rCSampling.SamplingDate), MakePle = "自动", Remark = remark }; isSuccess = SelfDber.Insert(rCMake) > 0; } //入厂煤制样明细 foreach (CodeContent item in CommonDAO.GetInstance().GetCodeContentByKind("样品类型")) { CmcsRCMakeDetail rCMakeDetail = SelfDber.Entity <CmcsRCMakeDetail>("where MakeId=:MakeId and SampleType=:SampleType", new { MakeId = rCMake.Id, SampleType = item.Content }); if (rCMakeDetail == null) { rCMakeDetail = new CmcsRCMakeDetail(); rCMakeDetail.MakeId = rCMake.Id; rCMakeDetail.SampleCode = CreateNewMakeBarrelCodeByMakeCode(rCMake.MakeCode, item.Content); rCMakeDetail.SampleType = item.Content; isSuccess = SelfDber.Insert(rCMakeDetail) > 0; } } // 入厂煤化验 CmcsRCAssay rCAssay = SelfDber.Entity <CmcsRCAssay>("where MakeId=:MakeId and IsDeleted=0", new { MakeId = rCMake.Id }); if (rCAssay == null) { // 入厂煤煤质 CmcsFuelQuality fuelQuality = new CmcsFuelQuality() { Id = Guid.NewGuid().ToString() }; if (SelfDber.Insert(fuelQuality) > 0) { rCAssay = new CmcsRCAssay() { MakeId = rCMake.Id, AssayCode = CreateNewAssayCode(rCMake.CreateDate), InFactoryBatchId = inFactoryBatch.Id, FuelQualityId = fuelQuality.Id, AssayDate = rCMake.MakeDate, Remark = remark, IsAssay = 0, BackBatchDate = inFactoryBatch.BackBatchDate, }; isSuccess = SelfDber.Insert(rCAssay) > 0; } } return(rCSampling); }
/// <summary> /// 生成制样及化验 /// </summary> /// <param name="makeCode"></param> /// <param name="assayType"></param> /// <param name="user"></param> /// <param name="assayTarget"></param> /// <returns></returns> public bool CreateMakeAndAssay(ref string makeCode, string assayType, string user, string assayTarget) { bool isSuccess = false; CmcsRCMake make = Dbers.GetInstance().SelfDber.Entity <CmcsRCMake>("where MakeCode=:MakeCode order by CreateDate desc ", new { MakeCode = makeCode }); if (make != null) { CmcsRCSampling rCSampling = Dbers.GetInstance().SelfDber.Get <CmcsRCSampling>(make.SamplingId); if (rCSampling != null) { // 入厂煤制样 CmcsRCMake rCMake = new CmcsRCMake() { SamplingId = rCSampling.Id, MakeStyle = eMakeType.机器制样.ToString(), MakeType = assayType, MakeStartTime = DateTime.Now, MakeEndTime = DateTime.Now, MakeCode = CommonDAO.GetInstance().CreateNewMakeCode(DateTime.Now), MakePle = user, ParentMakeId = make.Id }; isSuccess = Dbers.GetInstance().SelfDber.Insert(rCMake) > 0; makeCode = rCMake.MakeCode; //入厂煤制样明细 foreach (CodeContent item in CommonDAO.GetInstance().GetCodeContentByKind("制样类型")) { CmcsRCMakeDetail rCMakeDetail = Dbers.GetInstance().SelfDber.Entity <CmcsRCMakeDetail>("where MakeId=:MakeId and SampleType=:SampleType", new { MakeId = rCMake.Id, SampleType = item.Content }); if (rCMakeDetail == null) { rCMakeDetail = new CmcsRCMakeDetail(); rCMakeDetail.MakeId = rCMake.Id; rCMakeDetail.BarrelCode = CommonDAO.GetInstance().CreateNewMakeBarrelCodeByMakeCode(rCMake.MakeCode, item.Content); rCMakeDetail.SampleType = item.Content; isSuccess = Dbers.GetInstance().SelfDber.Insert(rCMakeDetail) > 0; } } // 入厂煤化验 CmcsRCAssay rCAssay = Dbers.GetInstance().SelfDber.Entity <CmcsRCAssay>("where MakeId=:MakeId", new { MakeId = rCMake.Id }); if (rCAssay == null) { // 入厂煤煤质 CmcsFuelQuality fuelQuality = new CmcsFuelQuality() { Id = Guid.NewGuid().ToString() }; if (Dbers.GetInstance().SelfDber.Insert(fuelQuality) > 0) { rCAssay = new CmcsRCAssay() { MakeId = rCMake.Id, AssayType = assayType, AssayWay = assayType, AssayCode = CommonDAO.GetInstance().CreateNewAssayCode(rCMake.CreateDate), InFactoryBatchId = rCSampling.InFactoryBatchId, FuelQualityId = fuelQuality.Id, AssayDate = rCMake.CreateDate, WfStatus = 0, AssayPoint = assayTarget }; isSuccess = Dbers.GetInstance().SelfDber.Insert(rCAssay) > 0; } } } } return(isSuccess); }
/// <summary> /// 创建采制化三级数据 /// </summary> /// <param name="inFactoryBatch">批次</param> /// <param name="samplingType">采样方式</param> /// <param name="remark">备注</param> /// <param name="assayType">化验方式</param> /// <returns></returns> public CmcsRCSampling GCSamplingMakeAssay(CmcsInFactoryBatch inFactoryBatch, string samplingType, string remark) { bool isSuccess = false; // 入厂煤采样 CmcsRCSampling rCSampling = SelfDber.Entity <CmcsRCSampling>("where InFactoryBatchId=:InFactoryBatchId and SamplingType=:SamplingType and IsDeleted=0", new { InFactoryBatchId = inFactoryBatch.Id, SamplingType = samplingType }); if (rCSampling == null) { rCSampling = new CmcsRCSampling() { InFactoryBatchId = inFactoryBatch.Id, SamplingType = samplingType, SamplingDate = DateTime.Now, SamplingPle = "自动", SampleCode = CreateNewSampleCode(inFactoryBatch.FactArriveDate), Remark = remark }; isSuccess = SelfDber.Insert(rCSampling) > 0; } // 入厂煤制样 CmcsRCMake rCMake = SelfDber.Entity <CmcsRCMake>("where SamplingId=:SamplingId and IsDeleted=0", new { SamplingId = rCSampling.Id }); if (rCMake == null) { rCMake = new CmcsRCMake() { SamplingId = rCSampling.Id, MakeType = "机器制样", MakeDate = rCSampling.CreateDate, MakeCode = CreateNewMakeCode(rCSampling.CreateDate), MakePle = "自动", Remark = remark }; isSuccess = SelfDber.Insert(rCMake) > 0; } // 入厂煤化验 CmcsRCAssay rCAssay = SelfDber.Entity <CmcsRCAssay>("where MakeId=:MakeId and IsDeleted=0", new { MakeId = rCMake.Id }); if (rCAssay == null) { // 入厂煤煤质 CmcsFuelQuality fuelQuality = new CmcsFuelQuality() { Id = Guid.NewGuid().ToString() }; if (SelfDber.Insert(fuelQuality) > 0) { rCAssay = new CmcsRCAssay() { MakeId = rCMake.Id, AssayCode = CreateNewAssayCode(rCMake.CreateDate), InFactoryBatchId = inFactoryBatch.Id, FuelQualityId = fuelQuality.Id, AssayDate = rCMake.CreateDate, Remark = remark, IsAssay = 0 }; isSuccess = SelfDber.Insert(rCAssay) > 0; } } return(rCSampling); }