public ActionResult ProductStation() { using (YLMES_newEntities ys = new YLMES_newEntities()) { List <PM_ProductLine> list = ys.PM_ProductLine.ToList(); ViewBag.ck = list; } return(View()); }
public ActionResult Permissions() { using (YLMES_newEntities ys = new YLMES_newEntities()) { List <PM_FunctionList> list = ys.PM_FunctionList.ToList(); ViewBag.ck = list; } return(View()); }
//删除工位类型 public string DlProductStation(string StationID) { using (YLMES_newEntities ys = new YLMES_newEntities()) { SqlParameter[] parms = new SqlParameter[2]; parms[0] = new SqlParameter("@Type", "delete"); parms[1] = new SqlParameter("@StationID", Convert.ToInt32(StationID)); int i = ys.Database.ExecuteSqlCommand("exec SP_PM_ProductStation @Type,@StationID", parms); } return("true"); }
//添加工位 public string ADDProductStation() { string CreatedBy = Session["name"].ToString(); using (YLMES_newEntities ys = new YLMES_newEntities()) { SqlParameter[] parms = new SqlParameter[2]; parms[0] = new SqlParameter("@Type", "ADD"); parms[1] = new SqlParameter("@CreatedBy", CreatedBy.ToString()); int i = ys.Database.ExecuteSqlCommand("exec SP_PM_ProductStation @Type,'','','','','','','','',@CreatedBy", parms); } return("true"); }
//权限修改 public string UpRole(string FunctionName, int Status, string UserName) { using (YLMES_newEntities ys = new YLMES_newEntities()) { SqlParameter[] parms = new SqlParameter[4]; parms[0] = new SqlParameter("@type", "EDIT"); parms[1] = new SqlParameter("@UserName", UserName); parms[2] = new SqlParameter("@FunctionName", FunctionName); parms[3] = new SqlParameter("@Status", Status); int i = ys.Database.ExecuteSqlCommand("exec PM_EditAccessSetup @type,@UserName,@FunctionName,@Status,''", parms); } return("true"); }
//修改生产线信息 public string UpProduct(string line, string lineID) { string CreatedBy = Session["name"].ToString(); using (YLMES_newEntities ys = new YLMES_newEntities()) { SqlParameter[] parms = new SqlParameter[4]; parms[0] = new SqlParameter("@Type", "Update"); parms[1] = new SqlParameter("@line", line); parms[2] = new SqlParameter("@lineID", Int32.Parse(lineID)); parms[3] = new SqlParameter("@CreatedBy", CreatedBy.ToString()); int i = ys.Database.ExecuteSqlCommand("exec SP_PM_ProductLine @Type,@lineID,@line,@CreatedBy", parms); } return("true"); }
//修改工位类型 public string UpProductStation(string Line, string StationID, string Station, string StationType) { string CreatedBy = Session["name"].ToString(); using (YLMES_newEntities ys = new YLMES_newEntities()) { SqlParameter[] parms = new SqlParameter[6]; parms[0] = new SqlParameter("@Type", "Update"); parms[1] = new SqlParameter("@StationID", Convert.ToInt32(StationID)); parms[2] = new SqlParameter("@Station", Station); parms[3] = new SqlParameter("@Line", Line); parms[4] = new SqlParameter("@StationType", StationType); parms[5] = new SqlParameter("@CreatedBy", CreatedBy.ToString()); int i = ys.Database.ExecuteSqlCommand("exec SP_PM_ProductStation @Type,@StationID,@Station,'',@Line,'','','',@StationType,@CreatedBy", parms); } return("true"); }
//搜索工位类型 public ActionResult SeProductStation(string Name, int page, int limit) { Dictionary <string, Object> hasmap; using (YLMES_newEntities ys = new YLMES_newEntities()) { SqlParameter[] parms = new SqlParameter[2]; parms[0] = new SqlParameter("@Type", "check"); parms[1] = new SqlParameter("@Station", Name); var list = ys.Database.SqlQuery <SP_PM_ProductStation_Result>("exec SP_PM_ProductStation @Type,'',@Station", parms).ToList(); hasmap = new Dictionary <string, Object>(); PageList <SP_PM_ProductStation_Result> pageList = new PageList <SP_PM_ProductStation_Result>(list, page, limit); int count = list.Count(); hasmap.Add("code", 0); hasmap.Add("msg", ""); hasmap.Add("count", count); hasmap.Add("data", pageList); } return(Json(hasmap, JsonRequestBehavior.AllowGet)); }
//查询未有权限 public ActionResult ByNoExistsRoot(string UserName, string FunctionName, int page, int limit) { Dictionary <string, Object> hasmap; using (YLMES_newEntities ys = new YLMES_newEntities()) { SqlParameter[] parms = new SqlParameter[4]; parms[0] = new SqlParameter("@type", "Type"); parms[1] = new SqlParameter("@UserName", UserName); parms[2] = new SqlParameter("@FunctionName", FunctionName); parms[3] = new SqlParameter("@typeid", int.Parse("0")); var list = ys.Database.SqlQuery <PM_EditAccessSetup_Result>("exec PM_EditAccessSetup @type,@UserName,@FunctionName,'',@typeid", parms).ToList(); hasmap = new Dictionary <string, Object>(); PageList <PM_EditAccessSetup_Result> pageList = new PageList <PM_EditAccessSetup_Result>(list, page, limit); int count = list.Count(); hasmap.Add("code", 0); hasmap.Add("msg", ""); hasmap.Add("count", count); hasmap.Add("data", pageList); } return(Json(hasmap, JsonRequestBehavior.AllowGet)); }