public string SaveVoucher(VOUCHEREntity SaveData) { var v = GetVerify(SaveData); if (SaveData.VOUCHERID.IsEmpty()) { SaveData.VOUCHERID = NewINC("VOUCHER"); } 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.VOUCHERID); v.Require(a => a.VOUCHERNAME); v.Verify(); using (var Tran = DbHelper.BeginTransaction()) { SaveData.VOUCHER_MAKESQL?.ForEach(item => { GetVerify(item).Require(a => a.SQLINX); }); DbHelper.Save(SaveData); Tran.Commit(); } return(SaveData.VOUCHERID); }
public void DeleteVoucher(List <VOUCHEREntity> DeleteData) { foreach (var item in DeleteData) { VOUCHEREntity 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(); } }
public Tuple <dynamic, DataTable, DataTable, DataTable, DataTable> GetVoucherElement(VOUCHEREntity Data) { string sql = $@"SELECT A.* " + "FROM VOUCHER A " + "WHERE 1=1 "; if (!Data.VOUCHERID.IsEmpty()) { sql += (" AND A.VOUCHERID= " + Data.VOUCHERID); } DataTable voucher = DbHelper.ExecuteTable(sql); voucher.NewEnumColumns <账单类型>("VOUCHERTYPE", "VOUCHERTYPEMC"); voucher.NewEnumColumns <普通单据状态>("STATUS", "STATUSMC"); string sqlvouchersql = $@"SELECT M.*" + " FROM VOUCHER_MAKESQL M" + " where 1=1"; if (!Data.VOUCHERID.IsEmpty()) { sqlvouchersql += (" and M.VOUCHERID= " + Data.VOUCHERID); } DataTable vouchersql = DbHelper.ExecuteTable(sqlvouchersql); string sqlvoucherrecord = $@"SELECT M.*" + " FROM VOUCHER_RECORD M" + " where 1=1"; if (!Data.VOUCHERID.IsEmpty()) { sqlvoucherrecord += (" and M.VOUCHERID= " + Data.VOUCHERID); } DataTable voucherrecord = DbHelper.ExecuteTable(sqlvoucherrecord); string sqlvoucherrecordpzkm = $@"SELECT M.*" + " FROM VOUCHER_RECORD_PZKM M" + " where 1=1"; if (!Data.VOUCHERID.IsEmpty()) { sqlvoucherrecordpzkm += (" and M.VOUCHERID= " + Data.VOUCHERID); } DataTable voucherrecordpzkm = DbHelper.ExecuteTable(sqlvoucherrecordpzkm); string sqlvoucherrecordzy = $@"SELECT M.*" + " FROM VOUCHER_RECORD_ZY M" + " where 1=1"; if (!Data.VOUCHERID.IsEmpty()) { sqlvoucherrecordzy += (" and M.VOUCHERID= " + Data.VOUCHERID); } DataTable voucherrecordzy = DbHelper.ExecuteTable(sqlvoucherrecordzy); return(new Tuple <dynamic, DataTable, DataTable, DataTable, DataTable>(voucher.ToOneLine(), vouchersql, voucherrecord, voucherrecordpzkm, voucherrecordzy)); }