/// <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);
}
