/// <summary> /// 追加保存 /// </summary> /// <param name="model"></param> public void ZjSave(PqQyszModel model) { using (IDbConnection conn = new DapperConnection().DbConnection) { IDbTransaction transaction = conn.BeginTransaction(); try { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE dbo.pq_qysz SET jsrq=@jsrq WHERE pqbh=@pqbh"); conn.Execute(strSql.ToString(), model, transaction); strSql.Clear(); model.SjdList = JsonConvert.DeserializeObject <List <Sjd> >(model.sjd); for (int i = 0; i < model.jsrq.Subtract(model.ksrq).TotalDays + 1; i++) { DateTime rq = model.ksrq.AddDays(i); PqTjrqModel rqModel = new PqTjrqModel(); rqModel.pqbh = model.pqbh; rqModel.qybh = model.qybh; rqModel.rq = model.ksrq.AddDays(i); rqModel.tjrs = model.SjdList.Sum(x => x.tjrs); rqModel.yybh = model.yybh; rqModel.flag = GetFlag(model.ksrq.AddDays(i), model.xxr); strSql.Append("insert into pq_tjrq("); strSql.Append("pqbh,yybh,qybh,rq,tjrs,flag)"); strSql.Append(" values ("); strSql.Append("@pqbh,@yybh,@qybh,@rq,@tjrs,@flag)"); conn.Execute(strSql.ToString(), rqModel, transaction); strSql.Clear(); foreach (var item in model.SjdList) { PqTjsjModel sjModel = new PqTjsjModel(); sjModel.yybh = model.yybh; sjModel.pqbh = model.pqbh; sjModel.qybh = model.qybh; sjModel.rq = rqModel.rq; sjModel.tjrs = item.tjrs; sjModel.kssj = Convert.ToDateTime(rqModel.rq.ToString("yyyy-MM-dd") + " " + item.kssj); sjModel.jssj = Convert.ToDateTime(rqModel.rq.ToString("yyyy-MM-dd") + " " + item.jssj); strSql.Append("insert into pq_tjsj("); strSql.Append("pqbh,yybh,qybh,rq,kssj,jssj,tjrs)"); strSql.Append(" values ("); strSql.Append("@pqbh,@yybh,@qybh,@rq,@kssj,@jssj,@tjrs)"); conn.Execute(strSql.ToString(), sjModel, transaction); strSql.Clear(); } } transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw; } } }
/// <summary> /// 保存 /// </summary> /// <param name="model"></param> /// <param name="pjtc"></param> /// <param name="pjtcrs"></param> public void Save(PqQyszModel model, string[] pjtc, string[] pjtcrs, string[] pjtcXxr, string[] pjtcSfxz) { using (IDbConnection conn = new DapperConnection().DbConnection) { IDbTransaction transaction = conn.BeginTransaction(); try { StringBuilder strSql = new StringBuilder(); if (!string.IsNullOrEmpty(model.pqbh)) { strSql.Append("DELETE FROM dbo.pq_tjrq WHERE pqbh=@pqbh;"); strSql.Append("DELETE FROM dbo.pq_tjsj WHERE pqbh=@pqbh;"); strSql.Append("DELETE FROM dbo.pq_pjtc WHERE pqbh=@pqbh;"); strSql.Append("DELETE FROM dbo.pq_pjtcgz WHERE pqbh=@pqbh;"); strSql.Append("UPDATE dbo.pq_qysz SET ksrq=@ksrq,jsrq=@jsrq,jzsj=@jzsj,xxr=@xxr,tqts=@tqts,sjd=@sjd,tjrs=@tjrs,tjrs_dy=@tjrs_dy WHERE pqbh=@pqbh"); } else { model.pqbh = GetPqbh(); strSql.Append("insert into pq_qysz(pqbh,yybh,qybh,ksrq,jsrq,cjsj,jzsj,xxr,tqts,sjd,tjrs,tjrs_dy) values (@pqbh,@yybh,@qybh,@ksrq,@jsrq,@cjsj,@jzsj,@xxr,@tqts,@sjd,@tjrs,@tjrs_dy);"); } conn.Execute(strSql.ToString(), model, transaction); strSql.Clear(); //foreach (var item in pjtcList) //{ // strSql.Append("insert into pq_pjtc("); // strSql.Append("pqbh,tcbh,tjrs)"); // strSql.Append(" values ("); // strSql.Append("@pqbh,@tcbh,@tjrs)"); // item.pqbh = model.pqbh; // conn.Execute(strSql.ToString(), item, transaction); // strSql.Clear(); //} if (pjtc != null && pjtcrs != null) { for (int i = 0; i < pjtc.Length; i++) { var fzbh = GetFzbh(); var tjrs = Convert.ToInt32(pjtcrs[i]); var xxr = pjtcXxr[i]; var sfxz = Convert.ToInt32(pjtcSfxz[i]); strSql.Append("insert into pq_pjtcgz("); strSql.Append("pqbh,fzbh,tjrs,xxr,sfxz)"); strSql.Append(" values ("); strSql.Append("@pqbh,@fzbh,@tjrs,@xxr,@sfxz)"); conn.Execute(strSql.ToString(), new { pqbh = model.pqbh, fzbh = fzbh, tjrs = tjrs, xxr = xxr, sfxz = sfxz }, transaction); strSql.Clear(); foreach (var item in pjtc[i].Split(',')) { strSql.Append("insert into pq_pjtc("); strSql.Append("pqbh,tcbh,fzbh)"); strSql.Append(" values ("); strSql.Append("@pqbh,@tcbh,@fzbh)"); conn.Execute(strSql.ToString(), new { pqbh = model.pqbh, fzbh = fzbh, tcbh = item }, transaction); strSql.Clear(); } } } for (int i = 0; i < model.jsrq.Subtract(model.ksrq).TotalDays + 1; i++) { DateTime rq = model.ksrq.AddDays(i); PqTjrqModel rqModel = new PqTjrqModel(); rqModel.pqbh = model.pqbh; rqModel.qybh = model.qybh; rqModel.rq = model.ksrq.AddDays(i); rqModel.tjrs = model.SjdList.Sum(x => x.tjrs); rqModel.yybh = model.yybh; rqModel.flag = GetFlag(model.ksrq.AddDays(i), model.xxr); strSql.Append("insert into pq_tjrq("); strSql.Append("pqbh,yybh,qybh,rq,tjrs,flag)"); strSql.Append(" values ("); strSql.Append("@pqbh,@yybh,@qybh,@rq,@tjrs,@flag)"); conn.Execute(strSql.ToString(), rqModel, transaction); strSql.Clear(); foreach (var item in model.SjdList) { PqTjsjModel sjModel = new PqTjsjModel(); sjModel.yybh = model.yybh; sjModel.pqbh = model.pqbh; sjModel.qybh = model.qybh; sjModel.rq = rqModel.rq; sjModel.tjrs = item.tjrs; sjModel.kssj = Convert.ToDateTime(rqModel.rq.ToString("yyyy-MM-dd") + " " + item.kssj); sjModel.jssj = Convert.ToDateTime(rqModel.rq.ToString("yyyy-MM-dd") + " " + item.jssj); strSql.Append("insert into pq_tjsj("); strSql.Append("pqbh,yybh,qybh,rq,kssj,jssj,tjrs)"); strSql.Append(" values ("); strSql.Append("@pqbh,@yybh,@qybh,@rq,@kssj,@jssj,@tjrs)"); conn.Execute(strSql.ToString(), sjModel, transaction); strSql.Clear(); } } transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw; } } }