// GET: Schedule public ActionResult Index() { PqJbszModel model = jbszService.GetModel(GLYadmin.YYID); model = model == null ? new PqJbszModel() : model; return(View(model)); }
public PqJbszModel GetModel(string tjjgid) { using (IDbConnection conn = new DapperConnection().DbConnection) { string sql = "SELECT * FROM dbo.pq_jbsz WHERE tjjgid=@tjjgid"; PqJbszModel model = conn.Query <PqJbszModel>(sql, new { tjjgid = tjjgid }).FirstOrDefault(); return(model); } }
public int Add(PqJbszModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into pq_jbsz("); strSql.Append("tjjgid,zdjd,skyl,qtyl,tjyl,xxr,tsky,ztyy,qdyl)"); strSql.Append(" values ("); strSql.Append("@tjjgid,@zdjd,@skyl,@qtyl,@tjyl,@xxr,@tsky,@ztyy,@qdyl)"); strSql.Append(";select @@IDENTITY"); using (IDbConnection conn = new DapperConnection().DbConnection) { int id = Convert.ToInt32(conn.ExecuteScalar(strSql.ToString(), model)); return(id); } }
public ActionResult Index(PqJbszModel request) { PqJbszModel model = jbszService.GetModel(GLYadmin.YYID); request.tjjgid = GLYadmin.YYID; request.skyl = request.zdjd - request.qtyl - request.tjyl - request.qdyl; request.xxr = string.IsNullOrEmpty(Request["xxr"]) ? "" : Request["xxr"].Replace(",", "|"); if (model == null) { jbszService.Add(request); } else { jbszService.Update(request); } return(Json(new { code = 200, msg = "成功" })); }
public bool Update(PqJbszModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update pq_jbsz set "); strSql.Append("zdjd=@zdjd,"); strSql.Append("skyl=@skyl,"); strSql.Append("qtyl=@qtyl,"); strSql.Append("tjyl=@tjyl,"); strSql.Append("xxr=@xxr,"); strSql.Append("tsky=@tsky,"); strSql.Append("ztyy=@ztyy,"); strSql.Append("qdyl=@qdyl"); strSql.Append(" where tjjgid=@tjjgid"); using (IDbConnection conn = new DapperConnection().DbConnection) { int num = conn.Execute(strSql.ToString(), model); return(num > 0); } }
public ActionResult QyDetail(string bh = "") { var qyModel = qyjbxxService.GetModel(bh, GLYadmin.YYID); if (qyModel == null) { return(Content("参数错误")); } var qypqModel = qypqszService.GetModelByQybh(bh, GLYadmin.YYID);//渠道排期基本设置 if (qypqModel == null) { PqJbszModel jbszModel = jbszService.GetModel(GLYadmin.YYID); jbszModel = jbszModel == null ? new PqJbszModel() : jbszModel; qypqModel = new PqQyszModel(); qypqModel.qybh = bh; qypqModel.yybh = qyModel.yybh; } var plszjlModel = plszjlService.GetModelByQybh(bh); plszjlModel = plszjlModel == null ? new PqPlszjlModel() : plszjlModel; plszjlModel.mxList = JsonConvert.DeserializeObject <List <PlszMxModel> >(plszjlModel.mx); if (plszjlModel.mxList.Count == 0) { plszjlModel.mxList.Add(new PlszMxModel { kssj = "07:30", jssj = "08:30", tjrs = 10 }); plszjlModel.mxList.Add(new PlszMxModel { kssj = "08:30", jssj = "09:30", tjrs = 10 }); } ViewBag.qy = qyModel; ViewBag.jbsz = qypqModel; //基本设置 ViewBag.plszjl = plszjlModel; //批量设置 return(View()); }