/// <summary>
/// get all accotherpayable
/// <summary>
/// <param name=out emsg>return error message</param>
///<returns>details of all accotherpayable</returns>
public BindingCollection <modAccOtherPayable> GetIList(string accname, string objectname, out string emsg)
{
try
{
BindingCollection <modAccOtherPayable> modellist = new BindingCollection <modAccOtherPayable>();
//Execute a query to read the categories
string sql = string.Format("select id,acc_name,seq,acc_date,object_name,currency,exchange_rate,start_mny,adding_mny,paid_mny,form_id,form_type,remark,update_user,update_time from acc_other_payable where acc_name='{0}' and object_name='{1}' order by id", accname, objectname);
decimal totalstart = 0;
decimal totaladding = 0;
decimal totalpaid = 0;
modAccOtherPayable model;
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
while (rdr.Read())
{
model = new modAccOtherPayable();
model.Id = dalUtility.ConvertToInt(rdr["id"]);
model.AccName = dalUtility.ConvertToString(rdr["acc_name"]);
model.Seq = dalUtility.ConvertToInt(rdr["seq"]);
model.AccDate = dalUtility.ConvertToDateTime(rdr["acc_date"]);
model.ObjectName = dalUtility.ConvertToString(rdr["object_name"]);
model.Currency = dalUtility.ConvertToString(rdr["currency"]);
model.ExchangeRate = dalUtility.ConvertToDecimal(rdr["exchange_rate"]);
model.StartMny = dalUtility.ConvertToDecimal(rdr["start_mny"]);
model.AddingMny = dalUtility.ConvertToDecimal(rdr["adding_mny"]);
model.PaidMny = dalUtility.ConvertToDecimal(rdr["paid_mny"]);
model.FormId = dalUtility.ConvertToString(rdr["form_id"]);
model.FormType = dalUtility.ConvertToString(rdr["form_type"]);
model.Remark = dalUtility.ConvertToString(rdr["remark"]);
model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]);
model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]);
modellist.Add(model);
}
}
model = new modAccOtherPayable();
model.AccName = accname;
model.ObjectName = "合计";
model.Currency = "人民币";
model.ExchangeRate = 1;
model.StartMny = totalstart;
model.AddingMny = totaladding;
model.PaidMny = totalpaid;
model.EndMny = totalstart + totaladding - totalpaid;
modellist.Add(model);
emsg = null;
return(modellist);
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
/// <summary>
/// get table record
/// <summary>
/// <param name=accname>accname</param>
/// <param name=seq>seq</param>
/// <param name=objectname>objectname</param>
/// <param name=out emsg>return error message</param>
///<returns>get a record detail of accotherpayable</returns>
public modAccOtherPayable GetItem(string accname, int?seq, string objectname, out string emsg)
{
try
{
//Execute a query to read the categories
string sql = string.Format("select id,acc_name,seq,acc_date,object_name,currency,exchange_rate,start_mny,adding_mny,paid_mny,form_id,form_type,remark,update_user,update_time from acc_other_payable where acc_name='{0}' and seq={1} and object_name='{2}' order by acc_name,seq,object_name", accname, seq, objectname);
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
if (rdr.Read())
{
modAccOtherPayable model = new modAccOtherPayable();
model.Id = dalUtility.ConvertToInt(rdr["id"]);
model.AccName = dalUtility.ConvertToString(rdr["acc_name"]);
model.Seq = dalUtility.ConvertToInt(rdr["seq"]);
model.AccDate = dalUtility.ConvertToDateTime(rdr["acc_date"]);
model.ObjectName = dalUtility.ConvertToString(rdr["object_name"]);
model.Currency = dalUtility.ConvertToString(rdr["currency"]);
model.ExchangeRate = dalUtility.ConvertToDecimal(rdr["exchange_rate"]);
model.StartMny = dalUtility.ConvertToDecimal(rdr["start_mny"]);
model.AddingMny = dalUtility.ConvertToDecimal(rdr["adding_mny"]);
model.PaidMny = dalUtility.ConvertToDecimal(rdr["paid_mny"]);
model.FormId = dalUtility.ConvertToString(rdr["form_id"]);
model.FormType = dalUtility.ConvertToString(rdr["form_type"]);
model.Remark = dalUtility.ConvertToString(rdr["remark"]);
model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]);
model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]);
emsg = null;
return(model);
}
else
{
emsg = "Error on read data";
return(null);
}
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
/// <summary>
/// update a accotherpayable
/// <summary>
/// <param name=accname>accname</param>
/// <param name=seq>seq</param>
/// <param name=objectname>objectname</param>
/// <param name=mod>model object of accotherpayable</param>
/// <param name=out emsg>return error message</param>
/// <returns>true/false</returns>
public bool Update(string accname, int?seq, string objectname, modAccOtherPayable mod, out string emsg)
{
try
{
string sql = string.Format("update acc_other_payable set id={0},acc_date='{1}',currency='{2}',exchange_rate={3},start_mny={4},adding_mny={5},paid_mny={6},form_id='{7}',form_type='{8}',remark='{9}',update_user='******',update_time=getdate() where acc_name='{11}' and seq={12} and object_name='{13}'", mod.Id, mod.AccDate, mod.Currency, mod.ExchangeRate, mod.StartMny, mod.AddingMny, mod.PaidMny, mod.FormId, mod.FormType, mod.Remark, mod.UpdateUser, accname, seq, objectname);
int i = SqlHelper.ExecuteNonQuery(sql);
if (i > 0)
{
emsg = null;
return(true);
}
else
{
emsg = "Unknown error when ExecuteNonQuery!";
return(false);
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(false);
}
}
/// <summary>
/// insert a accotherpayable
/// <summary>
/// <param name=mod>model object of accotherpayable</param>
/// <param name=out emsg>return error message</param>
/// <returns>true/false</returns>
public bool Insert(modAccOtherPayable mod, out string emsg)
{
try
{
string sql = string.Format("insert into acc_other_payable(acc_name,seq,acc_date,object_name,currency,exchange_rate,start_mny,adding_mny,paid_mny,form_id,form_type,remark,update_user,update_time)values('{0}',{1},'{2}','{3}','{4}',{5},{6},{7},{8},'{9}','{10}','{11}','{12}',getdate())", mod.AccName, mod.Seq, mod.AccDate, mod.ObjectName, mod.Currency, mod.ExchangeRate, mod.StartMny, mod.AddingMny, mod.PaidMny, mod.FormId, mod.FormType, mod.Remark, mod.UpdateUser);
int i = SqlHelper.ExecuteNonQuery(sql);
if (i > 0)
{
emsg = null;
return(true);
}
else
{
emsg = "Unknown error when ExecuteNonQuery!";
return(false);
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(false);
}
}
