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