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