/// <summary>
/// 汇总付款明细
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int collectPayDetails(Model.ReceiptPay model, int method, string sdate, string edate)
{
int rpid = 0;
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
conn.Open();//打开数据连接
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
#region 插入付款通知======================
rpid = new DAL.ReceiptPay().Add(model, conn, trans);
#endregion
#region 修改收款明细中的rpd_rpid==========================
if (rpid > 0)
{
string sql = "update MS_ReceiptPayDetail set rpd_rpid=@rpid,rpd_method=@newmethod where rpd_type=0 and rpd_flag3=2 and rpd_flag2=2 and rpd_flag1=2 and isnull(rpd_rpid,0)=0 and rpd_cid=@cid and isnull(rpd_method,0)=@method and isnull(rpd_cbid,0)=@cbid";
if (!string.IsNullOrEmpty(sdate))
{
sql += " and datediff(d,rpd_foreDate,'" + sdate + "')<=0";
}
if (!string.IsNullOrEmpty(edate))
{
sql += " and datediff(d,rpd_foreDate,'" + edate + "')>=0";
}
List <SqlParameter> paras1 = new List <SqlParameter>();
paras1.Add(new SqlParameter("@rpid", rpid));
paras1.Add(new SqlParameter("@cid", model.rp_cid));
paras1.Add(new SqlParameter("@method", method));
paras1.Add(new SqlParameter("@newmethod", model.rp_method));
paras1.Add(new SqlParameter("@cbid", model.rp_cbid));
DbHelperSQL.ExecuteSql(conn, trans, sql, paras1.ToArray());
trans.Commit();
}
#endregion
}
catch (Exception err)
{
trans.Rollback(); //回滚事务
rpid = 0;
}
}
}
return(rpid);
}
/// <summary>
/// 增加收款明细
/// </summary>
public int Add(Model.ReceiptPayDetail model, Model.ReceiptPay rp)
{
int rpid = 0, rpdid = 0;
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
conn.Open();//打开数据连接
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
#region 插入收款通知======================
if (rp != null)
{
rpid = new DAL.ReceiptPay().Add(rp, conn, trans);
}
#endregion
#region 插入收付款明细==========================
model.rpd_rpid = rpid;
rpdid = Add(model, conn, trans);
if (rpdid > 0)
{
trans.Commit();
}
#endregion
}
catch
{
trans.Rollback(); //回滚事务
rpdid = 0;
}
}
}
return(rpdid);
}
public ReceiptPay()
{
dal = new DAL.ReceiptPay();
}
