/// <summary> /// 根据发票编号查找收款纪录 /// </summary> /// <param name="id"></param> /// <returns></returns> public static Pay Find(string invoice_no) { Pay pay = new Pay(); string sql = string.Format("select * from tb_pay where invoice_no={0}", invoice_no); DataRow dr = DataControl.GetDataRow(sql); try { pay.Date_written = dr["date_written"].ToString(); pay.Company_name = dr["company_name"].ToString(); pay.Company_no = dr["company_no"].ToString(); pay.Payer_full = dr["payer_full"].ToString(); pay.Payer_accounts = dr["payer_accounts"].ToString(); pay.Payer_bank = dr["payer_bank"].ToString(); pay.Get_full = dr["get_full"].ToString(); pay.Get_accounts = dr["get_accounts"].ToString(); pay.Get_bank = dr["get_bank"].ToString(); pay.Total_price = dr["total_price"].ToString(); pay.Total_price_no =Convert.ToDouble(dr["total_price_no"].ToString()); pay.Resp_people = dr["resp_people"].ToString(); pay.Payee_company = dr["payee_company"].ToString(); return pay; } catch { return null; } }
/// <summary> /// 更新收款纪录 /// </summary> /// <param name="leder"></param> /// <returns></returns> public static int Update(Pay pay) { return Pay_DLL.Update(pay); }
/// <summary> /// 添加收款纪录 /// </summary> /// <param name="leder"></param> /// <returns></returns> public static int Add(Pay pay) { return Pay_DLL.Add(pay); }
/// <summary> /// 更新付款信息 /// </summary> /// <param name="leder"></param> /// <returns></returns> public static int Update(Pay pay) { string sql = string.Format("update tb_pay set payee_company='{0}'date_written='{1}',company_name='{2}',company_no='{3}',payer_full='{4}',payer_accounts='{5}',payer_bank='{6}',get_full='{7}',get_accounts='{8}',get_bank='{9}',total_price='{10}',total_price_no={11},resp_people='{12}' where ID={13}",pay.Payee_company, pay.Date_written,pay.Company_name, pay.Company_no, pay.Payer_full, pay.Payer_accounts,pay.Payer_bank,pay.Get_full,pay.Get_accounts,pay.Get_bank,pay.Total_price,pay.Total_price_no,pay.Resp_people,pay.Invoice_no); return DataControl.executecmd(sql); }
/// <summary> /// 添加付款信息 /// </summary> /// <param name="leder"></param> /// <returns></returns> public static int Add(Pay pay) { string sql = string.Format("insert into tb_pay values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}',{11},'{12}','{13}')", pay.Invoice_no,pay.Date_written,pay.Company_name,pay.Company_no,pay.Payer_full,pay.Payer_accounts,pay.Payer_bank,pay.Get_full,pay.Get_accounts,pay.Get_bank,pay.Total_price,pay.Total_price_no,pay.Resp_people,pay.Payee_company); return DataControl.executecmd(sql); }