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)); }