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