/// <summary> /// 增加一条数据 /// </summary> public int Add(JMP.MDL.jmp_dispatchorder model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into jmp_dispatchorder("); strSql.Append("d_apptyeid,d_ratio,d_state,d_datatime"); strSql.Append(") values ("); strSql.Append("@d_apptyeid,@d_ratio,@d_state,@d_datatime"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@d_apptyeid", SqlDbType.Int, 4), new SqlParameter("@d_ratio", SqlDbType.Decimal, 9), new SqlParameter("@d_state", SqlDbType.Int, 4), new SqlParameter("@d_datatime", SqlDbType.DateTime) }; parameters[0].Value = model.d_apptyeid; parameters[1].Value = model.d_ratio; parameters[2].Value = model.d_state; parameters[3].Value = model.d_datatime; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public JMP.MDL.jmp_dispatchorder GetModel(int d_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select d_id, d_apptyeid, d_ratio, d_state, d_datatime "); strSql.Append(" from jmp_dispatchorder "); strSql.Append(" where d_id=@d_id"); SqlParameter[] parameters = { new SqlParameter("@d_id", SqlDbType.Int, 4) }; parameters[0].Value = d_id; JMP.MDL.jmp_dispatchorder model = new JMP.MDL.jmp_dispatchorder(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["d_id"].ToString() != "") { model.d_id = int.Parse(ds.Tables[0].Rows[0]["d_id"].ToString()); } if (ds.Tables[0].Rows[0]["d_apptyeid"].ToString() != "") { model.d_apptyeid = int.Parse(ds.Tables[0].Rows[0]["d_apptyeid"].ToString()); } if (ds.Tables[0].Rows[0]["d_ratio"].ToString() != "") { model.d_ratio = decimal.Parse(ds.Tables[0].Rows[0]["d_ratio"].ToString()); } if (ds.Tables[0].Rows[0]["d_state"].ToString() != "") { model.d_state = int.Parse(ds.Tables[0].Rows[0]["d_state"].ToString()); } if (ds.Tables[0].Rows[0]["d_datatime"].ToString() != "") { model.d_datatime = DateTime.Parse(ds.Tables[0].Rows[0]["d_datatime"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 调单添加界面 /// </summary> /// <returns></returns> public ActionResult Adddispatchorder() { int did = string.IsNullOrEmpty(Request["did"]) ? 0 : Int32.Parse(Request["did"]); string where = ""; where = did > 0 ? " t_state='1' and t_id =(select d_apptyeid from jmp_dispatchorder where d_id=" + did + " ) and t_topid=0" : " t_state='1' and t_id not in( select d_apptyeid from jmp_dispatchorder ) and t_topid=0"; JMP.BLL.jmp_apptype yybll = new JMP.BLL.jmp_apptype(); DataTable yydt = yybll.GetList(where).Tables[0];//获取应用类型在用信息 List <JMP.MDL.jmp_apptype> yylist = JMP.TOOL.MdlList.ToList <JMP.MDL.jmp_apptype>(yydt); ViewBag.yylist = yylist; JMP.BLL.jmp_dispatchorder bll = new JMP.BLL.jmp_dispatchorder(); JMP.MDL.jmp_dispatchorder mode = new JMP.MDL.jmp_dispatchorder(); if (did > 0) { mode = bll.GetModel(did) == null ? new JMP.MDL.jmp_dispatchorder() : bll.GetModel(did); } ViewBag.mode = mode; return(View()); }
/// <summary> /// 添加或修改调单设置 /// </summary> /// <param name="mo"></param> /// <returns></returns> public JsonResult AddOrUpdatedispatchorder(JMP.MDL.jmp_dispatchorder mo) { object retJson = new { success = 0, msg = "操作失败" }; JMP.BLL.jmp_dispatchorder bll = new JMP.BLL.jmp_dispatchorder(); if (mo.d_id > 0) { JMP.MDL.jmp_dispatchorder mod = new JMP.MDL.jmp_dispatchorder(); mod = bll.GetModel(mo.d_id); mo.d_state = mod.d_state; mo.d_datatime = DateTime.Now; if (bll.Update(mo)) { #region 日志说明 Logger.ModifyLog("修改调单设置", mod, mo); #endregion retJson = new { success = 1, msg = "编辑成功!" }; } else { retJson = new { success = 0, msg = "编辑失败!" }; } } else { mo.d_datatime = DateTime.Now; mo.d_state = 0; int cg = bll.Add(mo); if (cg > 0) { Logger.CreateLog("添加调单设置", mo); retJson = new { success = 1, msg = "添加成功!" }; } else { retJson = new { success = 0, msg = "添加失败!" }; } } return(Json(retJson)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(JMP.MDL.jmp_dispatchorder model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update jmp_dispatchorder set "); strSql.Append(" d_apptyeid = @d_apptyeid , "); strSql.Append(" d_ratio = @d_ratio , "); strSql.Append(" d_state = @d_state , "); strSql.Append(" d_datatime = @d_datatime "); strSql.Append(" where d_id=@d_id "); SqlParameter[] parameters = { new SqlParameter("@d_id", SqlDbType.Int, 4), new SqlParameter("@d_apptyeid", SqlDbType.Int, 4), new SqlParameter("@d_ratio", SqlDbType.Decimal, 9), new SqlParameter("@d_state", SqlDbType.Int, 4), new SqlParameter("@d_datatime", SqlDbType.DateTime) }; parameters[0].Value = model.d_id; parameters[1].Value = model.d_apptyeid; parameters[2].Value = model.d_ratio; parameters[3].Value = model.d_state; parameters[4].Value = model.d_datatime; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }