public Tuple <dynamic, DataTable> GetBillAdjustElement(BILL_ADJUSTEntity Data)
{
string sql = $@"SELECT A.*,B.NAME BRANCHNAME "
+ "FROM BILL_ADJUST A,BRANCH B "
+ "WHERE A.BRANCHID=B.ID ";
if (!Data.BILLID.IsEmpty())
{
sql += (" AND A.BILLID= " + Data.BILLID);
}
DataTable billAdjust = DbHelper.ExecuteTable(sql);
billAdjust.NewEnumColumns <普通单据状态>("STATUS", "STATUSMC");
string sqlitem = $@"SELECT M.*,D.NAME MERCHANTNAME,F.NAME TERMNAME " +
" FROM BILL_ADJUST_ITEM M ,CONTRACT C,MERCHANT D,FEESUBJECT F" +
" where M.CONTRACTID=C.CONTRACTID and C.MERCHANTID = D.MERCHANTID and M.TERMID=F.TRIMID";
if (!Data.BILLID.IsEmpty())
{
sqlitem += (" and M.BILLID= " + Data.BILLID);
}
DataTable billAdjustitem = DbHelper.ExecuteTable(sqlitem);
return(new Tuple <dynamic, DataTable>(billAdjust.ToOneLine(), billAdjustitem));
}
public string SaveBillAdjust(BILL_ADJUSTEntity SaveData)
{
var v = GetVerify(SaveData);
if (SaveData.BILLID.IsEmpty())
{
SaveData.BILLID = NewINC("BILL_ADJUST");
}
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.Verify();
using (var Tran = DbHelper.BeginTransaction())
{
SaveData.BILL_ADJUST_ITEM?.ForEach(item =>
{
GetVerify(item).Require(a => a.TERMID);
GetVerify(item).Require(a => a.CONTRACTID);
});
DbHelper.Save(SaveData);
Tran.Commit();
}
return(SaveData.BILLID);
}
public UIResult SearchBill_Adjust(BILL_ADJUSTEntity Data)
{
var res = service.JsglService.GetBillAdjustElement(Data);
return(new UIResult(
new
{
billAdjust = res.Item1,
billAdjustItem = res.Item2
}
));
}
public void DeleteBillAdjust(List <BILL_ADJUSTEntity> DeleteData)
{
foreach (var item in DeleteData)
{
BILL_ADJUSTEntity 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 ExecBillAdjust(BILL_ADJUSTEntity Data)
{
BILL_ADJUSTEntity billAdjust = DbHelper.Select(Data);
if (billAdjust.STATUS == ((int)普通单据状态.审核).ToString())
{
throw new LogicException("单据(" + Data.BILLID + ")已经审核不能再次审核!");
}
using (var Tran = DbHelper.BeginTransaction())
{
Exec_BILL_ADJUST exec_billadjust = new Exec_BILL_ADJUST()
{
p_BILLID = Data.BILLID,
p_VERIFY = employee.Id
};
DbHelper.ExecuteProcedure(exec_billadjust);
Tran.Commit();
}
return(billAdjust.BILLID);
}
public void ExecData(BILL_ADJUSTEntity Data)
{
service.JsglService.ExecBillAdjust(Data);
}
public string Save(BILL_ADJUSTEntity SaveData)
{
return(service.JsglService.SaveBillAdjust(SaveData));
}
