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