private MVoucher BindVoucherDetail(MVoucher voucher)
{
string sql = string.Format("select *,(select top 1 [SubjectName] from [Finance_SubjectsRecord] where [SubjectCode]=vdr.[SubjectCode]) as SubjectName from [Finance_VoucherDetailRecord] vdr where [VId] = {0}", voucher.VId);
DataTable dt = _dbHelper.ExecuteDataTable(sql);
List <MVoucherDetail> detail = Utility.Convert <MVoucherDetail>(dt);
voucher.VoucherDetails = detail.ToArray();
return(voucher);
}
public int SaveVoucher(MVoucher voucher)
{
string sql = string.Format("select * from [Finance_VoucherRecord] where [VId] = {0}", voucher.VId);
DataTable dt = _dbHelper.ExecuteDataTable(sql);
object newId = null;
DataRow dr = dt.NewRow();
if (dt.Rows.Count > 0)
{
dr = dt.Rows[0];
newId = Convert.ToInt32(dr["VId"]);
}
else
{
MCompany com = _company.GetCompanyWithCurrentUser();
dr["CompanyId"] = com.CompanyId;
dr["Creator"] = _context.GetContext().CurrentUser.UserName;
dr["CreateTime"] = DateTime.Now;
dt.Rows.Add(dr);
}
dr["CertWord"] = voucher.CertWord;
dr["CertWordSn"] = voucher.CertWordSn;
dr["VoucherTime"] = voucher.VoucherTime;
dr["AttachedInvoices"] = voucher.AttachedInvoices;
int res = _dbHelper.UpdateDatatable(dt, sql);
if (newId == null)
{
newId = _dbHelper.ExecuteScalar("SELECT IDENT_CURRENT('Finance_VoucherRecord')");
}
if (res > 0)
{
res += SaveVoucherDetail(Convert.ToInt32(newId), voucher.VoucherDetails);
}
return(res);
}
public IHttpActionResult SaveVoucher(MVoucher voucher)
{
return(Ok(_voucherService.SaveVoucher(voucher)));
}
