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