/// <summary>
/// 存样
/// </summary>
/// <param name="cupBoardNumber"></param>
/// <param name="saveUser"></param>
/// <param name="sampleCode"></param>
/// <returns></returns>
public bool SaveCupBoard(int cupBoardNumber, string saveUser, string sampleCode)
{
CmcsCupCoardSave saveBoard = CommonDAO.GetInstance().SelfDber.Entity <CmcsCupCoardSave>("where CupCoardNumber=:CupCoardNumber and IsUse=1", new { CupCoardNumber = cupBoardNumber });
if (saveBoard == null)
{
saveBoard = new CmcsCupCoardSave();
saveBoard.CupCoardNumber = cupBoardNumber;
saveBoard.SaveCount++;
saveBoard.IsUse = 1;
saveBoard.UpdateTime = DateTime.Now;
CommonDAO.GetInstance().SelfDber.Insert(saveBoard);
}
else
{
saveBoard.SaveCount++;
saveBoard.UpdateTime = DateTime.Now;
CommonDAO.GetInstance().SelfDber.Update(saveBoard);
}
CmcsCupCoardSaveDetail saveDetail = new CmcsCupCoardSaveDetail();
saveDetail.CupCoardSaveId = saveBoard.Id;
saveDetail.SampleCode = sampleCode;
saveDetail.SaveUser = saveUser;
saveDetail.IsTake = 0;
saveDetail.SaveTime = DateTime.Now;
return(CommonDAO.GetInstance().SelfDber.Insert(saveDetail) > 0);
}
/// <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>
public int InitCupBoard()
{
int res = 0;
for (int i = 1; i <= 420; i++)
{
CmcsCupCoardSave saveBoard = CommonDAO.GetInstance().SelfDber.Entity <CmcsCupCoardSave>("where CupCoardNumber=:CupCoardNumber", new { CupCoardNumber = i });
if (saveBoard == null)
{
saveBoard = new CmcsCupCoardSave();
saveBoard.CupCoardNumber = i;
saveBoard.IsUse = 1;
saveBoard.UpdateTime = DateTime.Now;
res += CommonDAO.GetInstance().SelfDber.Insert(saveBoard);
}
}
return(res);
}
/// <summary>
/// 取样
/// </summary>
/// <param name="cupBoardNumber"></param>
/// <param name="takeUser"></param>
/// <param name="sampleCode"></param>
/// <returns></returns>
public bool TakeCupBoard(int cupBoardNumber, string takeUser, string sampleCode)
{
CmcsCupCoardSave saveBoard = CommonDAO.GetInstance().SelfDber.Entity <CmcsCupCoardSave>("where CupCoardNumber=:CupCoardNumber and IsUse=1", new { CupCoardNumber = cupBoardNumber });
if (saveBoard != null)
{
saveBoard.SaveCount--;
saveBoard.UpdateTime = DateTime.Now;
CommonDAO.GetInstance().SelfDber.Update(saveBoard);
}
CmcsCupCoardSaveDetail saveDetail = CommonDAO.GetInstance().SelfDber.Entity <CmcsCupCoardSaveDetail>("where SampleCode=:SampleCode and IsTake=0", new { SampleCode = sampleCode });
if (saveDetail != null)
{
saveDetail.TakeUser = takeUser;
saveDetail.IsTake = 1;
saveDetail.TakeTime = DateTime.Now;
return(CommonDAO.GetInstance().SelfDber.Update(saveDetail) > 0);
}
return(false);
}
