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