public int SaveVoucherAbstracts(MVoucherAbstracts abstracts) { if (abstracts == null) { return(0); } string sql = string.Format("select * from [Finance_VoucherAbstractsRecord] where [AId] = {0}", abstracts.AId); DataTable dt = _dbHelper.ExecuteDataTable(sql); DataRow dr; if (dt.Rows.Count > 0) { dr = dt.Rows[0]; } else { MCompany com = _company.GetCompanyWithCurrentUser(); if (com == null) { return(-1); } dr = dt.NewRow(); dr["CompanyId"] = com.CompanyId; dr["Creator"] = _context.GetContext().CurrentUser.UserName; dr["CreateTime"] = DateTime.Now; dt.Rows.Add(dr); } dr["Abstracts"] = abstracts.Abstracts; return(_dbHelper.UpdateDatatable(dt, sql)); }
public int DeleteVoucherAbstracts(MVoucherAbstracts abstracts) { if (abstracts == null || abstracts.AId <= 0) { return(0); } return(_dbHelper.ExecuteNonQuery(string.Format("delete from [Finance_VoucherAbstractsRecord] where [AId] = {0}", abstracts.AId))); }