/// <summary>
/// 逻辑删除数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Delete(string Code)
{
bool result = false;
Raw_Main r = new Raw_Main();
List<Raw_Main> list = instance.GetListByWhere(" AND RawMain_Code='" + Code + "'");
if (list.Count > 0)
{
Raw_Main model = list[0];
model.Stat = 1;
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
}
return result;
}
public bool AddRawMain(Raw_Main main)
{
//姚淞文
main.RawMain_Creator = SessionConfig.UserCode;
//状态设置
main.AuditStat = OperationTypeEnum.AudtiOperaTypeEnum.Auditing.ToString();
Verify_TemplateConfig model = auditInstance.GetVerifyTemplateFirstNode(OperationTypeEnum.AuditTemplateEnum.RawMain_M001.ToString());
if (model != null)
{
main.AuditCurAudit = model.VT_VerifyNode_Code;
auditInstance.InsertNextAuditRecord(OperationTypeEnum.AuditTemplateEnum.RawMain_M001.ToString(), model.VT_VerifyNode_Code, main.RawMain_Code);
}
return Insert(main);
}
public bool UpdateList(List<Raw_Detail> rawDetailList, Raw_Main main)
{
bool flag = true;
List<Raw_Detail> oldSIList = GetByRawMainCode(main.RawMain_Code);
try
{
foreach (Raw_Detail r in oldSIList)
{
var temp = rawDetailList.FirstOrDefault(o => o.RDetail_ID == r.RDetail_ID);
//如果存在则更新
if (temp != null)
{
Update(temp);
rawDetailList.Remove(temp);
}//不存在则删除
else
{
Delete(temp);
}
}
foreach (Raw_Detail detail in rawDetailList)
{
//如果有编码生成，则在此处完成
instance.Add(detail);
}
}
catch
{
flag = false;
}
return flag;
}
public bool UpdateDetailAndInv(List<Raw_Detail> rawDetailList, Raw_Main main)
{
bool flag = true;
List<Raw_Detail> oldSIList = GetByRawMainCode(main.RawMain_Code);
try
{
foreach (Raw_Detail r in oldSIList)
{
var temp = rawDetailList.FirstOrDefault(o => o.RDetail_ID == r.RDetail_ID);
//如果存在则更新
if (temp != null)
{
Update(temp);
rawDetailList.Remove(temp);
}//不存在则删除
else
{
Delete(r);
}
}
foreach (Raw_Detail detail in rawDetailList)
{
//采购的毛坯数量
int num= detail.RDetail_Num;
detail.RawMain_Code = main.RawMain_Code;
detail.RDetail_OwnDate = DateTime.Now;
detail.CreateTime = DateTime.Now;
//如果有编码生成，则在此处完成
var re=instance.Add(detail);
}
}
catch(Exception e)
{
flag = false;
}
return flag;
}
/// <summary>
/// 检验入库
/// </summary>
/// <param name="main"></param>
public void UpdateRaw(Raw_Main main)
{
#region 毛坯入库
Raw_Main mainRaw = instance.GetByKey(main.RawMain_ID);
main.RawMain_Checker = SessionConfig.UserCode;
instance.Update(mainRaw);
List<Raw_Detail> list = rdInstance.GetByRawMainCode(main.RawMain_Code);
foreach (var detail in list)
{
detail.RDetail_OCmd = DateTime.Now;
rdInstance.Update(detail);
var dlist = pcInstance.GetMapListForCheck(detail.RDetail_Command, detail.RDetail_PartNo);
foreach (var code in dlist)
{
code.PMap_RawStat = "In";
code.PMap_RawDate = DateTime.Now;
code.PMap_RawMainCode = detail.RawMain_Code;
pcInstance.UpdateProdMap(code);
}
Prod_Command cmd = cmdInstance.GetModel(string.Format(" AND Cmd_Code='{0}'", detail.RDetail_Command));
//采购的毛坯数量
int num = detail.RDetail_Num;
Raw_Inv rInv = new Raw_Inv();
//库存记录参考的入库记录
rInv.RI_RefRawCode = detail.RawMain_Code;
rInv.RI_RefDetailCode = detail.RDetail_Code;
rInv.RI_Code = rnvInstance.GenerateRawInvCode();
rInv.RI_CmdCode = detail.RDetail_Command;
rInv.RI_CompCode = detail.RDetail_PartNo;
rInv.RI_RawCode = main.RawMain_Code;
//rInv.RI_CompName=detail.RDetail_PartNo
rInv.RI_InOperator = SessionConfig.UserCode;
rInv.RI_InTime = DateTime.Now;
rInv.RI_AvailableNum = num;
rInv.RI_Sum = num;
rInv.RI_UsedNum = 0;
//Prod_Command command = cmdInstance.GetModel(string.Format(" AND Cmd_Code='{0}'", detail.RDetail_Command));
rInv.RI_Customer = cmd.Cmd_Dep_Name;
var re=rnvInstance.Add(rInv);
#region 指令数量回写
Prod_CmdDetail cmdDetail = pcInstance.GetModel(string.Format(" AND CmdDetail_ID='{0}'",detail.RDetail_DCommand));
//采购入库数量回写
cmdDetail.CmdDetail_DNum = cmdDetail.CmdDetail_DNum + num;
pcInstance.Update(cmdDetail);
int count=Common.C_Class.Utils.TypeConverter.ObjectToInt(cmd.Cmd_Udef3);
cmd.Cmd_Udef3 = (count+num).ToString();
cmdInstance.Update(cmd);
#endregion
}
#endregion
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(Raw_Main model)
{
bool result = false;
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
return result;
}
public bool TrashRaw(Raw_Main model)
{
model.AuditStat = OperationTypeEnum.AudtiOperaTypeEnum.Litter.ToString();
return Update(model);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Insert(Raw_Main model)
{
bool result = false;
try
{
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return result;
}