//public ReturnValueInfo DeleteRecord_Sqlite(ProjectQCRecord_pqc_Info model)
//{
// using (DBContext uow = DBContext.Begin())
// {
// try
// {
// ReturnValueInfo rvInfo = new ReturnValueInfo();
// //ReturnValueInfo rvInfoRecord = new ReturnValueInfo();
// if (model.ListProblemRecords != null)
// {
// foreach (ProjectQCProblem_pqcp_Info problemItem in model.ListProblemRecords)
// {
// uow.CurrentSession.Delete(problemItem);
// }
// }
// //rvInfoRecord = this._IProjectQCRecordDA_Sqlite.Delete(model);
// //if (!rvInfoRecord.boolValue || rvInfoRecord.isError)
// //{
// // return rvInfoRecord;
// //}
// rvInfo.boolValue = true;
// return rvInfo;
// }
// catch (Exception ex)
// {
// throw ex;
// }
// }
//}
public bool AddQCBlankRecord(ProjectQCRecord_pqc_Info pqcRecord, CustEnum.RecordType recordType)
{
try
{
using (DBContext uow = DBContext.Begin())
{
int maxRecord = 0;
QCPloblemView_qcpv_Info lastRec = uow.CurrentSession.QueryOver<QCPloblemView_qcpv_Info>().And(d => d.pqc_SPLID == pqcRecord.pqc_SPLID).OrderBy(d => d.pqc_iQCTimes).Desc.Take(1).SingleOrDefault();
if (lastRec != null)
{
maxRecord = lastRec.pqc_iQCTimes;
}
ProjectQCRecord_pqc_Info pqc = new ProjectQCRecord_pqc_Info();
pqc.pqc_RecordID = Guid.NewGuid();
pqc.pqc_iQCQTY = 0;
pqc.pqc_iProdQTY = pqcRecord.pqc_iProdQTY;
pqc.pqc_iQCTimes = maxRecord + 1;
pqc.pqc_cMode = CustEnum.RecordMode.MANUAL.ToString();
pqc.pqc_cType = recordType.ToString();
pqc.pqc_dAddDate = DateTime.Now;
pqc.pqc_SPLID = pqcRecord.pqc_SPLID;
uow.CurrentSession.Save(pqc);
uow.CurrentSession.CreateQuery("update ShiftProjList_spl_Info set spl_iQCTimes=:spl_iQCTimes where spl_RecordID=:spl_RecordID").SetInt32("spl_iQCTimes", pqc.pqc_iQCTimes).SetGuid("spl_RecordID", pqcRecord.pqc_SPLID).ExecuteUpdate();
uow.CurrentSession.Flush();
return true;
}
}
catch (Exception ex)
{
return false;
throw ex;
}
}
public ReturnValueInfo UpdateRecord(ProjectQCRecord_pqc_Info model)
{
throw new NotImplementedException();
}
public ReturnValueInfo QCPass(ProjectQCRecord_pqc_Info pqc, PrintProject_ppj_Info project, ShiftProjList_spl_Info shiftProject)
{
ReturnValueInfo result = new ReturnValueInfo();
try
{
if (pqc == null || pqc.pqc_iQCQTY == 0)
{
result.boolValue = false;
result.messageText = "抽查數量不能為零。";
return result;
}
else
{
if (pqc.pqc_SPLID == null || pqc.pqc_SPLID == Guid.Empty)
{
result.boolValue = false;
result.messageText = "抽查數量不能為零。";
return result;
}
using (DBContext uow = DBContext.Begin())
{
ProjectQCRecord_pqc_Info pqc_old = uow.CurrentSession.Get<ProjectQCRecord_pqc_Info>(pqc.pqc_RecordID);
pqc_old.pqc_iQCQTY = pqc.pqc_iQCQTY;
pqc_old.pqc_dLastDate = DateTime.Now;
pqc_old.pqc_dQCEndTime = DateTime.Now;
uow.CurrentSession.Update(pqc_old);
//CountSPLQCInfo(uow, project, shiftProject);
}
result.boolValue = true;
}
}
catch (Exception ex)
{
result.boolValue = false;
result.messageText = ex.Message;
}
return result;
}
public List<ProjectQCRecord_pqc_Info> SearchRecord(ProjectQCRecord_pqc_Info searchInfo)
{
throw new NotImplementedException();
}
/// <summary>
/// 開始QC
/// </summary>
/// <returns></returns>
public ReturnValueInfo QCBegin(ProjectQCRecord_pqc_Info pqc)
{
ReturnValueInfo result = new ReturnValueInfo();
try
{
if (pqc.pqc_SPLID == Guid.Empty)
{
result.boolValue = false;
result.messageText = "QC記錄沒有設置班次內工程ID，不能開始QC。";
return result;
}
if (pqc.pqc_dQCEndTime != null)
{
result.boolValue = false;
result.messageText = "QC記錄已結束，不能開始。";
}
else
{
using (DBContext uow = DBContext.Begin())
{
ProjectQCRecord_pqc_Info pqc_old = uow.CurrentSession.Get<ProjectQCRecord_pqc_Info>(pqc.pqc_RecordID);
if (pqc.pqc_RecordID == Guid.Empty)
{
pqc_old.pqc_RecordID = Guid.NewGuid();
pqc_old.pqc_dAddDate = DateTime.Now;
}
pqc_old.pqc_dLastDate = DateTime.Now;
if (pqc.pqc_dQCBeginTime == null)
{
pqc_old.pqc_dQCBeginTime = DateTime.Now;
pqc_old.pqc_iProdQTY = pqc.pqc_iProdQTY;
}
pqc_old.pqc_iQCQTY = pqc.pqc_iQCQTY;
uow.CurrentSession.SaveOrUpdate(pqc_old);
}
result.boolValue = true;
}
}
catch (Exception ex)
{
result.boolValue = false;
result.messageText = ex.Message;
}
return result;
}