public string ExecRateAdjust(RATE_ADJUSTEntity Data)
{
RATE_ADJUSTEntity ra = DbHelper.Select(Data);
if (ra.STATUS != ((int)普通单据状态.未审核).ToString())
{
throw new LogicException("单据(" + Data.ID + ")不是未审核状态,不能执行审核操作!");
}
using (var Tran = DbHelper.BeginTransaction())
{
EXEC_RATE_ADJUST proExec = new EXEC_RATE_ADJUST()
{
in_ID = Data.ID,
in_USERID = employee.Id
};
DbHelper.ExecuteProcedure(proExec);
Tran.Commit();
}
//删除审核待办任务
var dcl = new BILLSTATUSEntity
{
BILLID = Data.ID,
MENUID = "10500702",
BRABCHID = Data.BRANCHID,
URL = " SPGL/RATE_ADJUST/Rate_AdjustEdit/" //暂无浏览界面
};
DelDclRw(dcl);
return(ra.ID);
}
public string ExecSaleBillData(SALEBILLEntity Data)
{
SALEBILLEntity mer = DbHelper.Select(Data);
if (mer.STATUS == ((int)普通单据状态.审核).ToString())
{
throw new LogicException("单据(" + Data.BILLID + ")已经审核不能再次审核!");
}
using (var Tran = DbHelper.BeginTransaction())
{
EXEC_SALEBILL execsalebill = new EXEC_SALEBILL()
{
P_BILLID = Data.BILLID,
P_VERIFY = employee.Id
};
DbHelper.ExecuteProcedure(execsalebill);
Tran.Commit();
}
var dcl = new BILLSTATUSEntity
{
BILLID = Data.BILLID,
MENUID = "10500402",
BRABCHID = Data.BRANCHID,
URL = " SPGL/SALEBILL/SaleBillDetail/"
};
DelDclRw(dcl);
return(mer.BILLID);
}
public void DeleteSaleBill(List <SALEBILLEntity> DeleteData)
{
foreach (var con in DeleteData)
{
SALEBILLEntity Data = DbHelper.Select(con);
if (Data.STATUS != ((int)普通单据状态.未审核).ToString())
{
throw new LogicException($"租约({Data.BILLID})已经不是未审核不能删除!");
}
}
using (var Tran = DbHelper.BeginTransaction())
{
foreach (var salebill in DeleteData)
{
var v = GetVerify(salebill);
//校验
var dcl = new BILLSTATUSEntity
{
BILLID = salebill.BILLID,
MENUID = "10500402",
BRABCHID = salebill.BRANCHID,
URL = " SPGL/SALEBILL/SaleBillDetail/"
};
DelDclRw(dcl);
DbHelper.Delete(salebill);
}
Tran.Commit();
}
}
/// <summary>
/// 待处理任务
/// </summary>
/// <param name="billStatus"></param>
public void InsertDclRw(BILLSTATUSEntity billStatus)
{
var v = GetVerify(billStatus);
v.Require(a => a.BILLID);
v.Require(a => a.MENUID);
v.Require(a => a.BRABCHID);
v.Require(a => a.URL);
DbHelper.Save(billStatus);
}
public string SaveSaleBill(SALEBILLEntity SaveData)
{
var v = GetVerify(SaveData);
if (SaveData.BILLID.IsEmpty())
{
SaveData.BILLID = NewINC("SALEBILL");
}
SaveData.STATUS = ((int)普通单据状态.未审核).ToString();
SaveData.REPORTER = employee.Id;
SaveData.REPORTER_NAME = employee.Name;
SaveData.REPORTER_TIME = DateTime.Now.ToString();
SaveData.VERIFY = employee.Id;
v.Require(a => a.BILLID);
v.Require(a => a.BRANCHID);
v.Require(a => a.ACCOUNT_DATE);
v.Require(a => a.CASHIERID);
v.Require(a => a.CLERKID);
v.Verify();
using (var Tran = DbHelper.BeginTransaction())
{
SaveData.SALEBILLITEM?.ForEach(item =>
{
GetVerify(item).Require(a => a.GOODSID);
GetVerify(item).Require(a => a.PAYID);
GetVerify(item).Require(a => a.QUANTITY);
GetVerify(item).Require(a => a.AMOUNT);
});
DbHelper.Save(SaveData);
Tran.Commit();
}
var dcl = new BILLSTATUSEntity
{
BILLID = SaveData.BILLID,
MENUID = "10500402",
BRABCHID = SaveData.BRANCHID,
URL = " SPGL/SALEBILL/SaleBillDetail/"
};
InsertDclRw(dcl);
return(SaveData.BILLID);
}
public string SaveRateAdjust(RATE_ADJUSTEntity SaveData)
{
var v = GetVerify(SaveData);
if (SaveData.ID.IsEmpty())
{
SaveData.ID = NewINC("RATE_ADJUST");
}
SaveData.STATUS = ((int)普通单据状态.未审核).ToString();
SaveData.REPORTER = employee.Id;
SaveData.REPORTER_NAME = employee.Name;
SaveData.REPORTER_TIME = DateTime.Now.ToString();
v.Require(a => a.ID);
v.Require(a => a.BRANCHID);
v.Require(a => a.STARTTIME);
v.Require(a => a.ENDTIME);
v.Verify();
using (var Tran = DbHelper.BeginTransaction())
{
SaveData.RATE_ADJUST_ITEM?.ForEach(item =>
{
item.SHEETID = "1";
GetVerify(item).Require(a => a.GOODSID);
GetVerify(item).Require(a => a.RATE_NEW);
});
DbHelper.Save(SaveData);
Tran.Commit();
}
//增加审核待办任务
var dcl = new BILLSTATUSEntity
{
BILLID = SaveData.ID,
MENUID = "10500702",
BRABCHID = SaveData.BRANCHID,
URL = " SPGL/RATE_ADJUST/Rate_AdjustEdit/" //暂无浏览界面
};
InsertDclRw(dcl);
return(SaveData.ID);
}
public void DeleteRateAdjust(List <RATE_ADJUSTEntity> DeleteData)
{
foreach (var con in DeleteData)
{
RATE_ADJUSTEntity Data = DbHelper.Select(con);
if (Data.STATUS != ((int)普通单据状态.未审核).ToString())
{
throw new LogicException($"单据({Data.ID})不是未审核状态,不能执行删除操作!");
}
}
using (var Tran = DbHelper.BeginTransaction())
{
foreach (var AD in DeleteData)
{
var v = GetVerify(AD);
//校验
DbHelper.Delete(AD);
}
Tran.Commit();
}
//删除审核待办任务
using (var Tran = DbHelper.BeginTransaction())
{
foreach (var AD in DeleteData)
{
var dcl = new BILLSTATUSEntity
{
BILLID = AD.ID,
MENUID = "10500702",
BRABCHID = AD.BRANCHID,
URL = " SPGL/RATE_ADJUST/Rate_AdjustEdit/" //暂无浏览界面
};
DelDclRw(dcl);
}
Tran.Commit();
}
}
public void DelDclRw(BILLSTATUSEntity billStatus)
{
var v = GetVerify(billStatus);
DbHelper.Delete(billStatus);
}
