public string SaveBillReturn(BILL_RETURNEntity SaveData)
{
var v = GetVerify(SaveData);
if (SaveData.BILLID.IsEmpty())
{
SaveData.BILLID = NewINC("BILL_RETURN");
}
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.CONTRACTID);
v.Require(a => a.BRANCHID);
v.Verify();
using (var Tran = DbHelper.BeginTransaction())
{
SaveData.BILL_RETURN_ITEM?.ForEach(item =>
{
GetVerify(item).Require(a => a.FINAL_BILLID);
GetVerify(item).Require(a => a.RETURN_MONEY);
});
DbHelper.Save(SaveData);
Tran.Commit();
}
return(SaveData.BILLID);
}
public Tuple <dynamic, DataTable> GetBillReturnElement(BILL_RETURNEntity Data)
{
//此处校验一次只能查询一个单号,校验单号必须存在
string sql = $@"SELECT A.*,B.NAME BRANCHNAME,D.NAME MERCHANTNAME "
+ "FROM BILL_RETURN A,BRANCH B,CONTRACT C,MERCHANT D "
+ "WHERE A.BRANCHID=B.ID and A.CONTRACTID=C.CONTRACTID(+) and C.MERCHANTID = D.MERCHANTID(+) ";
if (!Data.BILLID.IsEmpty())
{
sql += (" AND BILLID= " + Data.BILLID);
}
DataTable billReturn = DbHelper.ExecuteTable(sql);
billReturn.NewEnumColumns <普通单据状态>("STATUS", "STATUSMC");
string sqlitem = $@"SELECT M.*,B.MUST_MONEY,B.RECEIVE_MONEY " +
" FROM BILL_RETURN_ITEM M，BILL B " +
" where M.FINAL_BILLID=B.BILLID(+) ";
if (!Data.BILLID.IsEmpty())
{
sqlitem += (" and M.BILLID= " + Data.BILLID);
}
DataTable billReturnitem = DbHelper.ExecuteTable(sqlitem);
return(new Tuple <dynamic, DataTable>(billReturn.ToOneLine(), billReturnitem));
}
public UIResult SearchBill_Return(BILL_RETURNEntity Data)
{
var res = service.JsglService.GetBillReturnElement(Data);
return(new UIResult(
new
{
billReturn = res.Item1,
billReturnItem = res.Item2
}
));
}
public void DeleteBillReturn(List <BILL_RETURNEntity> DeleteData)
{
foreach (var item in DeleteData)
{
BILL_RETURNEntity Data = DbHelper.Select(item);
if (Data.STATUS == ((int)普通单据状态.审核).ToString())
{
throw new LogicException("已经审核不能删除!");
}
}
using (var Tran = DbHelper.BeginTransaction())
{
foreach (var item in DeleteData)
{
DbHelper.Delete(item);
}
Tran.Commit();
}
}
/// <summary>
/// 保证金返还审核
/// </summary>
/// <param name="Data"></param>
/// <returns></returns>
public string ExecBillReturn(BILL_RETURNEntity Data)
{
BILL_RETURNEntity billReturn = DbHelper.Select(Data);
if (billReturn.STATUS == ((int)普通单据状态.审核).ToString())
{
throw new LogicException("单据(" + Data.BILLID + ")已经审核不能再次审核!");
}
using (var Tran = DbHelper.BeginTransaction())
{
billReturn.VERIFY = employee.Id;
billReturn.VERIFY_NAME = employee.Name;
billReturn.VERIFY_TIME = DateTime.Now.ToString();
billReturn.STATUS = ((int)普通单据状态.审核).ToString();
DbHelper.Save(billReturn);
Tran.Commit();
}
return(billReturn.BILLID);
}
public void ExecData(BILL_RETURNEntity Data)
{
service.JsglService.ExecBillReturn(Data);
}
public string Save(BILL_RETURNEntity SaveData)
{
return(service.JsglService.SaveBillReturn(SaveData));
}
