/// <summary>
/// 写入编码
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void btnWriteCode_Click(object sender, EventArgs e)
{
GridButtonXEditControl btn = sender as GridButtonXEditControl;
if (btn == null)
{
return;
}
CmcsRCMakeDetail rCMakeDetail = btn.EditorCell.GridRow.DataItem as CmcsRCMakeDetail;
if (rCMakeDetail == null)
{
return;
}
czyHandlerDAO.UpdateSendPle(rCMakeDetail, SelfVars.LoginUser.UserName);
if (!string.IsNullOrEmpty(rCMakeDetail.BarrelCode))
{
WriteRf(rCMakeDetail.BarrelCode);
}
else
{
MessageBoxEx.Show("请先点击[生成]按钮生成样罐编码", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
/// <summary>
/// 打印编码
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void btnPrintCode_Click(object sender, EventArgs e)
{
GridButtonXEditControl btn = sender as GridButtonXEditControl;
if (btn == null)
{
return;
}
CmcsRCMakeDetail rCMakeDetail = btn.EditorCell.GridRow.DataItem as CmcsRCMakeDetail;
if (rCMakeDetail == null)
{
return;
}
if (!string.IsNullOrEmpty(rCMakeDetail.BarrelCode))
//_CodePrinter.Print(rCMakeDetail.BarrelCode);
{
FrmMakeWeight_Print print = new FrmMakeWeight_Print(rCMakeDetail.BarrelCode);
print.ShowDialog();
}
else
{
MessageBoxEx.Show("请先点击[生成]按钮生成样罐编码", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
/// <summary>
/// 写入编码
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void btnWriteCode_Click(object sender, EventArgs e)
{
GridButtonXEditControl btn = sender as GridButtonXEditControl;
if (btn == null)
{
return;
}
CmcsRCMakeDetail rCMakeDetail = btn.EditorCell.GridRow.DataItem as CmcsRCMakeDetail;
if (rCMakeDetail == null)
{
return;
}
if (!string.IsNullOrEmpty(rCMakeDetail.SampleCode))
{
WriteRf(rCMakeDetail.SampleCode);
}
else
{
MessageBoxEx.Show("请先点击[生成]按钮生成样罐编码", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
/// <summary>
/// 同步样品信息到集中管控入厂煤制样明细表
/// </summary>
/// <param name="makeDetail"></param>
private bool SyncToRCMakeDetail(EquQZDZYJDetail makeDetail)
{
CmcsRCMake rCMake = commonDAO.SelfDber.Entity <CmcsRCMake>("where MakeCode=:MakeCode and IsDeleted=0", new { MakeCode = makeDetail.MakeCode });
if (rCMake != null)
{
// 修改制样结束时间
rCMake.MakeType = eMakeType.机械制样.ToString();
rCMake.GetDate = DateTime.Now;
rCMake.MakeDate = makeDetail.StartTime;
commonDAO.SelfDber.Update(rCMake);
CmcsRCMakeDetail rCMakeDetail = commonDAO.SelfDber.Entity <CmcsRCMakeDetail>("where MakeId=:MakeId and SampleType=:SampleType and IsDeleted=0", new { MakeId = rCMake.Id, SampleType = makeDetail.YPType });
if (rCMakeDetail != null)
{
rCMakeDetail.LastModificAtionTime = DateTime.Now;
rCMakeDetail.CreationTime = DateTime.Now;
rCMakeDetail.SampleWeight = makeDetail.YPWeight;
rCMakeDetail.SampleCode = makeDetail.BarrelCode;
return(commonDAO.SelfDber.Update(rCMakeDetail) > 0);
}
}
return(false);
}
/// <summary>
/// 确定
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSubmit_Click(object sender, EventArgs e)
{
string barrelCode = txtInputSampleCode.Text.Trim();
if (String.IsNullOrWhiteSpace(barrelCode))
{
return;
}
this.RCMakeDetail = commonDAO.SelfDber.Entity <CmcsRCMakeDetail>("where SampleCode=:SampleCode order by CreateDate desc", new { SampleCode = barrelCode });
// 根据采样桶编码查找该采样单下所有采样桶记录
if (this.RCMakeDetail != null)
{
CmcsCupCoardSaveDetail saveDetail = commonDAO.SelfDber.Entity <CmcsCupCoardSaveDetail>("where SampleCode=:SampleCode ", new { SampleCode = barrelCode });
if (saveDetail != null)
{
ShowMessage("该样品已存样，存样位置：" + saveDetail.TheSave.CupCoardNumber + "柜", eOutputType.Warn);
return;
}
else
{
CmcsCupCoardSaveDetail saveDetailReady = commonDAO.SelfDber.Entity <CmcsCupCoardSaveDetail>("where SampleCode like :SampleCode||'%' ", new { SampleCode = barrelCode.Substring(0, barrelCode.Length - 3) });
if (saveDetailReady != null && saveDetailReady.TheSave != null)
{
CurrentCupBoardNumber = saveDetailReady.TheSave.CupCoardNumber;
Hardwarer.Iocer.Output(CurrentCupBoardNumber);
//Thread.Sleep(1000);
//if (Hardwarer.Iocer.IsOpenSuccess)
//{
ShowMessage(CurrentCupBoardNumber + "号柜门已打开，请放入样品关好柜门", eOutputType.Normal);
czyHandlerDAO.SaveCupBoard(CurrentCupBoardNumber, SelfVars.LoginUser.UserName, barrelCode);
//}
}
else
{
CmcsCupCoardSave saveCupBoard = commonDAO.SelfDber.Entity <CmcsCupCoardSave>(" where IsUse=1 order by dbms_random.value()");
if (saveCupBoard != null)
{
CurrentCupBoardNumber = saveCupBoard.CupCoardNumber;
Hardwarer.Iocer.Output(CurrentCupBoardNumber);
//Thread.Sleep(1000);
//if (Hardwarer.Iocer.IsOpenSuccess)
//{
ShowMessage(CurrentCupBoardNumber + "号柜门已打开，请放入样品关好柜门", eOutputType.Normal);
czyHandlerDAO.SaveCupBoard(CurrentCupBoardNumber, SelfVars.LoginUser.UserName, barrelCode);
//}
}
}
}
}
else
{
txtInputSampleCode.ResetText();
ShowMessage("制样子码：" + barrelCode + " 不存在", eOutputType.Error);
}
}
/// <summary>
/// 重置
/// </summary>
private void Restet()
{
this.CurrentCupBoardNumber = 0;
this.RCMakeDetail = null;
txtInputSampleCode.ResetText();
rtxtOutputInfo.ResetText();
// 方便客户快速使用，获取焦点
txtInputSampleCode.Focus();
}
/// <summary>
/// 同步样品信息到集中管控入厂煤制样明细表
/// </summary>
/// <param name="makeDetail"></param>
private bool SyncToRCMakeDetail(ZY_Record_Tb makeDetail)
{
CmcsRCMake rCMake = commonDAO.SelfDber.Entity <CmcsRCMake>("where MakeCode=:MakeCode", new { MakeCode = makeDetail.SampleID });
if (rCMake != null)
{
// 修改制样结束时间
rCMake.MakeStyle = eMakeType.机器制样.ToString();
if (rCMake.MakeEndTime < makeDetail.EndTime)
{
rCMake.MakeEndTime = makeDetail.EndTime;
}
if (rCMake.MakeStartTime != rCMake.CreateDate && rCMake.MakeStartTime > makeDetail.StartTime)
{
rCMake.GetDate = DateTime.Now;
rCMake.MakeStartTime = makeDetail.StartTime;
}
if (rCMake.MakeStartTime < makeDetail.StartTime)
{
rCMake.MakeStartTime = makeDetail.StartTime;
}
if (rCMake.MakeEndTime < makeDetail.EndTime)
{
rCMake.MakeEndTime = makeDetail.EndTime;
}
commonDAO.SelfDber.Update(rCMake);
CmcsRCMakeDetail rCMakeDetail = commonDAO.SelfDber.Entity <CmcsRCMakeDetail>("where MakeId=:MakeId and SampleType=:SampleType", new { MakeId = rCMake.Id, SampleType = makeDetail.SampleType });
if (rCMakeDetail != null)
{
rCMakeDetail.OperDate = DateTime.Now;
rCMakeDetail.CreateDate = DateTime.Now;
rCMakeDetail.Weight = makeDetail.SamepleWeight;
rCMakeDetail.SampleType = makeDetail.SampleType; //AutoMakerDAO.GetInstance().GetKYMakeType(makeDetail.SampleType.ToString());
//rCMakeDetail.BarrelCode = makeDetail.PackCode;
return(commonDAO.SelfDber.Update(rCMakeDetail) > 0);
}
else
{
rCMakeDetail = new CmcsRCMakeDetail();
rCMakeDetail.MakeId = rCMake.Id;
rCMakeDetail.OperDate = DateTime.Now;
rCMakeDetail.CreateDate = DateTime.Now;
rCMakeDetail.Weight = makeDetail.SamepleWeight;
rCMakeDetail.SampleType = makeDetail.SampleType; //AutoMakerDAO.GetInstance().GetKYMakeType(makeDetail.SampleType.ToString());
rCMakeDetail.BarrelCode = makeDetail.PackCode;
return(commonDAO.SelfDber.Insert(rCMakeDetail) > 0);
}
}
else
{
return(true);
}
}
/// <summary>
/// 更改验证状态
/// </summary>
/// <param name="makeDetailId"></param>
/// <param name="isCheck"></param>
/// <param name="CheckUser"></param>
/// <returns></returns>
public bool ChangeCheckStatus(string makeDetailId, bool isCheck, string CheckUser)
{
CmcsRCMakeDetail rCMakeDetail = Dbers.GetInstance().SelfDber.Get <CmcsRCMakeDetail>(makeDetailId);
if (rCMakeDetail != null)
{
rCMakeDetail.IsCheck = isCheck ? 1 : 0;
//rCMakeDetail.CheckUser = CheckUser;
return(Dbers.GetInstance().SelfDber.Update(rCMakeDetail) > 0);
}
return(false);
}
/// <summary>
/// 获取明细信息
/// </summary>
/// <returns></returns>
public IList <CmcsRCMakeDetail> GetDetails()
{
IList <CmcsRCMakeDetail> details = new List <CmcsRCMakeDetail>();
foreach (GridRow gridRow in superGridControl1.PrimaryGrid.Rows)
{
CmcsRCMakeDetail entity = gridRow.DataItem as CmcsRCMakeDetail;
if (entity != null)
{
details.Add(entity);
}
}
return(details);
}
/// <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="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="sender"></param>
/// <param name="e"></param>
void btnNewCode_Click(object sender, EventArgs e)
{
GridButtonXEditControl btn = sender as GridButtonXEditControl;
if (btn == null)
{
return;
}
CmcsRCMakeDetail rCMakeDetail = btn.EditorCell.GridRow.DataItem as CmcsRCMakeDetail;
if (rCMakeDetail == null)
{
return;
}
if (!string.IsNullOrEmpty(rCMakeDetail.SampleCode) && MessageBoxEx.Show("样罐编码已存在，确定要重新生成？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
// 生成随机样罐编码
//string newBarrelCode = commonDAO.CreateNewMakeBarrelCode(DateTime.Now);
string newBarrelCode = commonDAO.CreateNewMakeBarrelCodeByMakeCode(rCMakeDetail.TheRCMake.MakeCode, rCMakeDetail.SampleType);
// 称重校验
if (IsUseWeight)
{
if (wber.Status && wber.Weight > 0 && wber.Weight > WbMinWeight)
{
rCMakeDetail.SampleCode = newBarrelCode;
rCMakeDetail.SampleWeight = wber.Weight;
czyHandlerDAO.UpdateMakeDetailWeightAndBarrelCode(rCMakeDetail.Id, wber.Weight, newBarrelCode);
}
else
{
MessageBoxEx.Show("未检测到重量", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
// 不称重校验
else
{
rCMakeDetail.SampleCode = newBarrelCode;
czyHandlerDAO.UpdateMakeDetailWeightAndBarrelCode(rCMakeDetail.Id, 0, newBarrelCode);
}
}
/// <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();
}
}
}
}
/// <summary>
/// 根据制样明细Id查找化验记录
/// </summary>
/// <param name="rCMakeDetailId">制样明细Id</param>
/// <returns></returns>
public CmcsRCAssay GetRCAssayByMakeCode(string rCMakeDetailId)
{
CmcsRCMakeDetail rCMakeDetail = Dbers.GetInstance().SelfDber.Get <CmcsRCMakeDetail>(rCMakeDetailId);
if (rCMakeDetail != null)
{
// 三级编码化验查询
if (rCMakeDetail.SampleType == eMakeSampleType.Type1 || rCMakeDetail.SampleType == eMakeSampleType.Type3)
{
return(Dbers.GetInstance().SelfDber.Entity <CmcsRCAssay>("where AssayType=:AssayType and MakeId=:MakeId order by CreateDate desc", new { AssayType = eAssayType.级编码化验.ToString(), MakeId = rCMakeDetail.MakeId }));
}
// 不同类型的化验查询
//else if(rCMakeDetail.SampleType==eMakeSampleType.Type2)
}
return(null);
}
/// <summary>
/// 生成制样明细
/// </summary>
/// <param name="rcMake"></param>
/// <returns></returns>
public List <CmcsRCMakeDetail> CreateRcMakeDetail(CmcsRCMake rcMake)
{
IList <CodeContent> maketype = commonDAO.GetCodeContentByKind("样品类型");
foreach (CodeContent item in maketype)
{
CmcsRCMakeDetail makedetail = commonDAO.SelfDber.Entity <CmcsRCMakeDetail>("where MakeId=:MakeId and SampleType=:SampleType", new { MakeId = rcMake.Id, SampleType = item.Content });
if (makedetail == null)
{
makedetail = new CmcsRCMakeDetail();
makedetail.MakeId = rcMake.Id;
makedetail.SampleType = item.Content;
makedetail.BarrelCode = commonDAO.CreateNewMakeBarrelCodeByMakeCode(rcMake.MakeCode, item.Content);
commonDAO.SelfDber.Insert(makedetail);
}
}
return(commonDAO.SelfDber.Entities <CmcsRCMakeDetail>("where MakeId=:MakeId", new { MakeId = rcMake.Id }));
}
/// <summary>
/// 根据制样明细Id查找化验记录
/// </summary>
/// <param name="rCMakeDetailId">制样明细Id</param>
/// <returns></returns>
public CmcsRCAssay GetRCAssayByMakeCode(string rCMakeDetailId)
{
CmcsRCMakeDetail rCMakeDetail = Dbers.GetInstance().SelfDber.Get <CmcsRCMakeDetail>(rCMakeDetailId);
if (rCMakeDetail != null)
{
string AssayTypes = CommonDAO.GetInstance().GetAppletConfigString("化验样品类型");
// 三级编码化验查询
//if (rCMakeDetail.SampleType == eMakeSampleType.Type1 || rCMakeDetail.SampleType == eMakeSampleType.Type3)
if (AssayTypes.Contains(rCMakeDetail.SampleType))
{
return(Dbers.GetInstance().SelfDber.Entity <CmcsRCAssay>("where MakeId=:MakeId and IsDeleted=0 order by CreateDate desc", new { MakeId = rCMakeDetail.MakeId }));
}
// 不同类型的化验查询
//else if(rCMakeDetail.SampleType==eMakeSampleType.Type2)
}
return(null);
}
/// <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="sender"></param>
/// <param name="e"></param>
private void btn_CreateMakeDetail_Click(object sender, EventArgs e)
{
if (!CheckInPut())
{
return;
}
IList <CmcsRCMakeDetail> details = new List <CmcsRCMakeDetail>();
//入厂煤制样明细
foreach (CodeContent item in CommonDAO.GetInstance().GetCodeContentByKind("监督样制样样品类型"))
{
CmcsRCMakeDetail rCMakeDetail = new CmcsRCMakeDetail();
rCMakeDetail.BarrelCode = CommonDAO.GetInstance().CreateNewMakeBarrelCodeByMakeCode(txt_MakeCode.Text, item.Content);
rCMakeDetail.SampleType = item.Content;
rCMakeDetail.BarrelTime = DateTime.Now;
details.Add(rCMakeDetail);
}
this.cmcsMakeDetail = details;
}
/// <summary>
/// 写入编码
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void btnWriteCode_Click(object sender, EventArgs e)
{
GridButtonXEditControl btn = sender as GridButtonXEditControl;
if (btn == null)
{
return;
}
CmcsRCMakeDetail rCMakeDetail = btn.EditorCell.GridRow.DataItem as CmcsRCMakeDetail;
if (rCMakeDetail == null)
{
return;
}
if (!string.IsNullOrEmpty(rCMakeDetail.BarrelCode))
{
WriteRf(rCMakeDetail.BarrelCode);
}
}
/// <summary>
/// 获取制样从表明细记录
/// </summary>
/// <param name="MakeCode">制样码</param>
/// <returns></returns>
public CmcsRCMakeDetail GetRCMakeDetail(string barrelCode, out string message)
{
CmcsRCMakeDetail rcMakeDetail = null;
try
{
rcMakeDetail = Dbers.GetInstance().SelfDber.Entity <CmcsRCMakeDetail>(" where SampleCode=:SampleCode and IsDeleted=0 order by CreateDate desc", new { SampleCode = barrelCode });
if (rcMakeDetail == null)
{
message = "未找到【" + barrelCode + "】制样登记记录";
return(null);
}
}
catch (Exception ex)
{
message = "程序异常！" + ex.Message;
return(null);
}
message = "扫码成功";
return(rcMakeDetail);
}
/// <summary>
/// 加载制样明细记录
/// </summary>
private void LoadRCMakeDetail()
{
string makeId = string.Empty;
bool res = false;
List <CmcsRCMakeDetail> rCMakeDetails = czyHandlerDAO.GetRCMakeDetails(txtInputMakeCode.Text.Trim(), ref makeId, ref res, out resMessage);
if (res)
{
if (rCMakeDetails.Count == 0)
{
//没有制样明细记录就自动生成出样记录
foreach (CodeContent codeContent in CommonDAO.GetInstance().GetCodeContentByKind("样品类型"))
{
CmcsRCMakeDetail cmcsrcmakedetail = new CmcsRCMakeDetail()
{
MakeId = makeId,
SampleCode = string.Empty,
BackupCode = string.Empty,
CheckWeight = 0,
SampleType = codeContent.Code,
SampleWeight = 0,
};
if (Dbers.GetInstance().SelfDber.Insert <CmcsRCMakeDetail>(cmcsrcmakedetail) > 0)
{
rCMakeDetails.Add(cmcsrcmakedetail);
}
}
}
ShowMessage(resMessage, eOutputType.Normal);
}
else
{
ShowMessage(resMessage, eOutputType.Error);
}
superGridControl1.PrimaryGrid.DataSource = rCMakeDetails;
}
void SaveAndUpdate(CmcsRCMake rCMake, IList <CmcsRCMakeDetail> details)
{
CmcsRCMake oldmake = Dbers.GetInstance().SelfDber.Get <CmcsRCMake>(rCMake.Id);
if (oldmake != null)
{
Dbers.GetInstance().SelfDber.Update(rCMake);
CreateAssay(rCMake);
}
else
{
Dbers.GetInstance().SelfDber.Insert(rCMake);
CreateAssay(rCMake);
}
List <CmcsRCMakeDetail> olds = Dbers.GetInstance().SelfDber.Entities <CmcsRCMakeDetail>(" where MakeId=:MakeId", new { MakeId = rCMake.Id });
foreach (CmcsRCMakeDetail old in olds)
{
CmcsRCMakeDetail del = details.Where(a => a.Id == old.Id).FirstOrDefault();
if (del == null)
{
Dbers.GetInstance().SelfDber.Delete <CmcsRCMakeDetail>(old.Id);
}
}
foreach (var detail in details)
{
detail.MakeId = rCMake.Id;
CmcsRCMakeDetail insertorupdate = olds.Where(a => a.Id == detail.Id).FirstOrDefault();
if (insertorupdate == null)
{
Dbers.GetInstance().SelfDber.Insert(detail);
}
else
{
Dbers.GetInstance().SelfDber.Update(detail);
}
}
}
/// <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="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="sender"></param>
/// <param name="e"></param>
void btnNewCode_Click(object sender, EventArgs e)
{
GridButtonXEditControl btn = sender as GridButtonXEditControl;
if (btn == null)
{
return;
}
CmcsRCMakeDetail rCMakeDetail = btn.EditorCell.GridRow.DataItem as CmcsRCMakeDetail;
if (rCMakeDetail == null)
{
return;
}
if (!string.IsNullOrEmpty(rCMakeDetail.BarrelCode) && MessageBoxEx.Show("样罐编码已存在，确定要重新生成？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
// 生成随机样罐编码
string newBarrelCode = commonDAO.CreateNewMakeBarrelCode(DateTime.Now);
// 称重校验
#region 原称重代码，取电子秤数据
//if (IsUseWeight)
//{
// if (wber.Status && wber.Weight > 0 && wber.Weight > WbMinWeight)
// {
// rCMakeDetail.BarrelCode = newBarrelCode;
// rCMakeDetail.Weight = wber.Weight;
// czyHandlerDAO.UpdateMakeDetailWeightAndBarrelCode(rCMakeDetail.Id, wber.Weight, newBarrelCode);
// }
// else
// MessageBoxEx.Show("未检测到重量", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
//}
//// 不称重校验
//else
//{
// rCMakeDetail.BarrelCode = newBarrelCode;
// czyHandlerDAO.UpdateMakeDetailWeightAndBarrelCode(rCMakeDetail.Id, 0, newBarrelCode);
//}
#endregion
#region 临时的手动称重，接入电子秤后可还原
if (IsUseWeight)
{
czyHandlerDAO.UpdateMakeDetailWeightAndBarrelCode(rCMakeDetail.Id, rCMakeDetail.Weight, newBarrelCode);
}
// 不称重校验
else
{
rCMakeDetail.BarrelCode = newBarrelCode;
czyHandlerDAO.UpdateMakeDetailWeightAndBarrelCode(rCMakeDetail.Id, 0, newBarrelCode);
}
//rCMakeDetail.TheRCMake
List <CmcsRCMakeDetail> rCMakeDetails = commonDAO.SelfDber.Entities <CmcsRCMakeDetail>(" where MakeId=:MakeId order by CreateDate asc", new { MakeId = rCMakeDetail.TheRCMake.Id });
superGridControl1.PrimaryGrid.DataSource = rCMakeDetails;
#endregion
}
/// <summary>
/// 同步样品信息到集中管控入厂煤制样明细表
/// </summary>
/// <param name="makeDetail"></param>
private bool SyncToRCMakeDetail(ZY_Record_Tb makeDetail)
{
CmcsRCMake rCMake = commonDAO.SelfDber.Entity <CmcsRCMake>("where MakeCode=:MakeCode", new { MakeCode = makeDetail.SampleID });
if (rCMake != null)
{
// 修改制样结束时间
rCMake.MakeType = eMakeType.机械制样.ToString();
//if (rCMake.MakeDate < makeDetail.EndTime) rCMake.MakeDate = makeDetail.EndTime;
//if (rCMake.MakeDate != rCMake.CreationTime && rCMake.MakeDate > makeDetail.StartTime)
//{
// //rCMake.GetDate = makeDetail.StartTime;
// rCMake.MakeDate = makeDetail.EndTime;
// //取归批时间
// string sql = string.Format(@"select a.backbatchdate from
// fultbinfactorybatch a
// left join cmcstbrcsampling b on a.id=b.infactorybatchid
// left join cmcstbmake c on b.id=c.samplingid
// where c.id='{0}'", rCMake.Id);
// DataTable dt = commonDAO.SelfDber.ExecuteDataTable(sql);
// if (dt != null && dt.Rows.Count>0)
// {
// rCMake.GetDate = Convert.ToDateTime(dt.Rows[0]["backbatchdate"]);
// }
//}
rCMake.MakeDate = makeDetail.StartTime;
//取归批时间
string sql = string.Format(@"select a.backbatchdate from
fultbinfactorybatch a
left join cmcstbrcsampling b on a.id=b.infactorybatchid
left join cmcstbmake c on b.id=c.samplingid
where c.id='{0}'" , rCMake.Id);
DataTable dt = commonDAO.SelfDber.ExecuteDataTable(sql);
if (dt != null && dt.Rows.Count > 0)
{
rCMake.GetDate = Convert.ToDateTime(dt.Rows[0]["backbatchdate"]);
}
commonDAO.SelfDber.Update(rCMake);
CmcsRCMakeDetail rCMakeDetail = commonDAO.SelfDber.Entity <CmcsRCMakeDetail>("where MakeId=:MakeId and SampleType=:SampleType", new { MakeId = rCMake.Id, SampleType = MakeTypeChange(makeDetail.SampleType) });
if (rCMakeDetail != null)
{
rCMakeDetail.LastModificAtionTime = DateTime.Now;
rCMakeDetail.CreationTime = DateTime.Now;
rCMakeDetail.SampleWeight = makeDetail.SamepleWeight;
rCMakeDetail.SampleType = MakeTypeChange(makeDetail.SampleType);
rCMakeDetail.SampleCode = makeDetail.PackCode;
return(commonDAO.SelfDber.Update(rCMakeDetail) > 0);
}
else
{
rCMakeDetail = new CmcsRCMakeDetail();
rCMakeDetail.MakeId = rCMake.Id;
rCMakeDetail.LastModificAtionTime = DateTime.Now;
rCMakeDetail.CreationTime = DateTime.Now;
rCMakeDetail.SampleWeight = makeDetail.SamepleWeight;
rCMakeDetail.SampleType = MakeTypeChange(makeDetail.SampleType); //AutoMakerDAO.GetInstance().GetKYMakeType(makeDetail.SampleType.ToString());
rCMakeDetail.SampleCode = makeDetail.PackCode;
return(commonDAO.SelfDber.Insert(rCMakeDetail) > 0);
}
}
else
{
return(true);
}
}
private void ClearBarrelCode()
{
txtInputSampleCode.ResetText();
this.RCMakeDetail = null;
}
private void makeImage(object sender, PrintPageEventArgs e)
{
Font fontTitle = new Font("黑体", instance.FontSize, FontStyle.Bold, GraphicsUnit.Pixel);
CmcsBuyFuelTransport entity = this.cmcsSupplier;
CmcsRCMakeDetail makedetail = Dbers.GetInstance().SelfDber.Entities <CmcsRCMakeDetail>(" where BarrelCode=:BarrelCode", new { BarrelCode = barrelCode }).FirstOrDefault();
if (makedetail == null)
{
return;
}
Graphics g;
Bitmap result = new Bitmap(600, 600);
if (e == null)
{
g = Graphics.FromImage(result);
g.FillRectangle(new SolidBrush(System.Drawing.Color.White), 0, 0, result.Width, result.Height);
}
else
{
g = e.Graphics;
}
// 行间距 30
float TopValue = 0;
Bitmap bmp = null;
QRCodeEncoder qrCodeEncoder = new QRCodeEncoder();
qrCodeEncoder.QRCodeEncodeMode = QRCodeEncoder.ENCODE_MODE.BYTE;
qrCodeEncoder.QRCodeScale = instance.ImgSize;
qrCodeEncoder.QRCodeVersion = 0;
qrCodeEncoder.QRCodeErrorCorrect = QRCodeEncoder.ERROR_CORRECTION.M;
bmp = qrCodeEncoder.Encode(barrelCode);
string printValue = "";
g.DrawImage(bmp, instance.ImgLeftPadding, instance.ImgTopPadding);
TopValue = instance.ImgTopPadding + bmp.Height + instance.CharToImg;
TopValue = instance.CharToImg;
float leftValue = instance.ImgLeftPadding + bmp.Width + instance.CharLeftPadding;
printValue = "样品编码：" + makedetail.BarrelCode;
TopValue = DrawContent(fontTitle, g, TopValue, printValue, leftValue);
printValue = "样品类型：" + makedetail.SampleType;
TopValue = DrawContent(fontTitle, g, TopValue, printValue, leftValue);
printValue = "装罐时间：" + makedetail.CreateDate.ToString("yyyyMMdd");
TopValue = DrawContent(fontTitle, g, TopValue, printValue, leftValue);
printValue = "样 重：" + (makedetail.Weight == 0 ? "0.00" : makedetail.Weight.ToString()) + " g";
TopValue = DrawContent(fontTitle, g, TopValue, printValue, leftValue);
if (e == null)
{
this.pictureBox1.Image = result;
g.Dispose();
}
}
/// <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);
}
