/// <summary>
/// 根据ID查找记录
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static Ledger Find(string id)
{
Ledger ledger = new Ledger();
string sql = string.Format("select * from tb_ledger where ser_number='{0}'", id);
DataRow dr = DataControl.GetDataRow(sql);
try
{
//a.Account = Convert.ToDateTime(dr["AddDate"].ToString());
ledger.Res_person = dr["res_person"].ToString();
ledger.Ser_number = dr["ser_number"].ToString();
ledger.Title = dr["title"].ToString();
ledger.Appl_for = dr["appl_for"].ToString();
ledger.Gro_location = dr["gro_location"].ToString();
ledger.Purpose = dr["purpose"].ToString();
ledger.Build_appropriate =Convert.ToBoolean(dr["build_appropriate"].ToString());
ledger.Listing_transf = Convert.ToBoolean(dr["listing_transf"].ToString());
ledger.Sale_transf = Convert.ToBoolean(dr["sale_transf"].ToString());
ledger.Treaty_transf = Convert.ToBoolean(dr["treaty_transf"].ToString());
ledger.Retrieve_area = Convert.ToBoolean(dr["retrieve_area"].ToString());
ledger.Swapping = Convert.ToBoolean(dr["swapping"].ToString());
ledger.Change_transf = Convert.ToBoolean(dr["change_transf"].ToString());
ledger.Build_area = dr["build_area"].ToString();
ledger.Total_area = dr["total_area"].ToString();
ledger.Net_area = dr["net_area"].ToString();
ledger.Business = Convert.ToBoolean(dr["business"].ToString());
ledger.Industry = Convert.ToBoolean(dr["industry"].ToString());
ledger.House = Convert.ToBoolean(dr["house"].ToString());
ledger.Other = Convert.ToBoolean(dr["other"].ToString());
ledger.Total_price = Convert.ToInt32(dr["total_price"].ToString());
ledger.Account_paid = Convert.ToInt32(dr["account_paid"].ToString());
ledger.Debt = Convert.ToInt32(dr["debt"].ToString());
ledger.Approval_number = dr["approval_number"].ToString();
ledger.Approve_time = dr["approve_time"].ToString();
ledger.Note = dr["note"].ToString();
return ledger;
}
catch
{
return null;
}
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="leder"></param>
/// <returns></returns>
public static int Add(Ledger leder)
{
//string sql = string.Format("insert into tb_ledger values('{0}','{1}','{2}','{3}','{4}','{5}',{6},{7},{8},{9},{10},{11,{12},'{13}','{14}','{15}',{16},{17},{18},{19},{20},{21},{22},'{23}','{24}','{25}')", leder.Res_person, leder.Ser_number, leder.Title, leder.Appl_for, leder.Gro_location, leder.Purpose,Convert.ToInt32(leder.Build_appropriate), Convert.ToInt32(leder.Listing_transf),Convert.ToInt32(leder.Sale_transf), Convert.ToInt32(leder.Treaty_transf),Convert.ToInt32(leder.Retrieve_area), Convert.ToInt32(leder.Swapping), Convert.ToInt32(leder.Change_transf),leder.Build_area, leder.Total_area, leder.Net_area, Convert.ToInt32(leder.Business), Convert.ToInt32(leder.Industry), Convert.ToInt32(leder.House),Convert.ToInt32(leder.Other), leder.Total_price, leder.Account_paid, leder.Debt, leder.Approval_number, leder.Approve_time, leder.Note);
string sql = string.Format("insert into tb_ledger values('{0}','{1}','{2}','{3}','{4}','{5}',{6},{7},{8},{9},{10},{11},{12},'{13}','{14}','{15}',{16},{17},{18},{19},{20},{21},{22},'{23}','{24}','{25}')", leder.Res_person, leder.Ser_number, leder.Title, leder.Appl_for, leder.Gro_location, leder.Purpose, Convert.ToInt32(leder.Build_appropriate), Convert.ToInt32(leder.Listing_transf), Convert.ToInt32(leder.Sale_transf), Convert.ToInt32(leder.Treaty_transf), Convert.ToInt32(leder.Retrieve_area), Convert.ToInt32(leder.Swapping), Convert.ToInt32(leder.Change_transf),leder.Build_area,leder.Total_area,leder.Net_area,Convert.ToInt32(leder.Business),Convert.ToInt32(leder.Industry),Convert.ToInt32(leder.House),Convert.ToInt32(leder.Other),leder.Total_price,leder.Account_paid,leder.Debt,leder.Approval_number,leder.Approve_time,leder.Note);
return DataControl.executecmd(sql);
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="leder"></param>
/// <returns></returns>
public static int Update(Ledger leder)
{
string sql = string.Format("update tb_ledger set res_person='{0}'ser_number='{1}',title='{2}',appl_for='{3}',gro_location='{4}',purpose='{5}'build_appropriate= {6} listing_transf={7} treaty_transf={8} retrieve_transf={9} swapping={10} change_transf={11} build_area={12} total_area={13} net_area={14} business={15} industry={16} house={17} other={18} total_price={19} account_paid={20} debt={21} approval_number={22} approve_time={23} note={24} where ID={25}", leder.Res_person, leder.Ser_number, leder.Title, leder.Appl_for, leder.Gro_location, leder.Purpose, leder.Build_appropriate, leder.Listing_transf, leder.Treaty_transf, leder.Retrieve_area, leder.Swapping, leder.Change_transf, leder.Build_area, leder.Total_area, leder.Net_area, leder.Business, leder.Industry, leder.House, leder.Other, leder.Total_price, leder.Account_paid, leder.Debt, leder.Approval_number, leder.Approve_time, leder.Note);
return DataControl.executecmd(sql);
}
public static int orderPirce(string ser_number,double totleprice)
{
try
{
Ledger ledger = new Ledger();
ledger = Find(ser_number);
double dept = ledger.Debt - totleprice;
double yj = ledger.Account_paid + totleprice;
string sql = string.Format("update tb_ledger set account_paid={0},debt={1} where ser_number={2}", yj, dept, ser_number);
return DataControl.executecmd(sql);
}
catch (Exception ed)
{
return -1;
}
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="leder"></param>
/// <returns></returns>
public static int Add(Ledger leder)
{
return Ledger_DLL.Add(leder);
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="leder"></param>
/// <returns></returns>
public static int Update(Ledger leder)
{
return Ledger_DLL.Update(leder);
}
