private void GetShopInfo(HttpContext context, string btn) { if (btn != "show") { context.Response.Write("{\"status\":\"0.2\",\"msg\":\"对不起,您没有操作权限!\"}"); return; } try { int depId = RequestHelper.GetInt("id", 0); BLL.System.sys_Department bll = new BLL.System.sys_Department(); DataTable dt = bll.GetShopInfo(depId).Tables[0]; if (dt.Rows.Count == 0) { context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起,该条数据已被其他人删除!\"}"); return; } string rowsStr = Utils.ToJson(dt); StringBuilder jsonStr = new StringBuilder(); jsonStr.Append("{\"status\":\"1\",\"msg\":\"数据获取成功!\",\"info\":" + rowsStr + "}"); context.Response.Write(jsonStr); } catch (Exception e) { context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起,系统出错:" + Utils.HtmlEncode(e.Message) + "\"}"); return; } }
private void GetList(HttpContext context, string btn) { if (btn != "show") { context.Response.Write("{\"status\":\"0.2\",\"msg\":\"对不起,您没有操作权限!\"}"); return; } try { int supId = RequestHelper.GetInt("supId", 1); string filterFlag = RequestHelper.GetString("filterFlag"); BLL.System.sys_Department bll = new BLL.System.sys_Department(); StringBuilder strWhere = new StringBuilder(); List <SqlParameter> parameterList = new List <SqlParameter>(); SqlParameter tempParameter = new SqlParameter(); if (filterFlag == "") { strWhere.Append(" and SupId=@SupId"); tempParameter = new SqlParameter("@SupId", SqlDbType.Int, 4); tempParameter.Value = supId; parameterList.Add(tempParameter); } else { var depName = RequestHelper.GetString("depName"); var QDCode = RequestHelper.GetString("QDCode"); if (depName != "") { strWhere.Append(" and a.DepName like '%'+ @DepName +'%'"); tempParameter = new SqlParameter("@DepName", SqlDbType.NVarChar); tempParameter.Value = depName; parameterList.Add(tempParameter); } if (QDCode != "") { strWhere.Append(" and a.QDCode like '%'+ @QDCode +'%'"); tempParameter = new SqlParameter("@QDCode", SqlDbType.NVarChar); tempParameter.Value = QDCode; parameterList.Add(tempParameter); } } DataTable dt = bll.GetList(strWhere.ToString(), parameterList).Tables[0]; string rowsStr = Utils.ToJson(dt); StringBuilder jsonStr = new StringBuilder(); jsonStr.Append("{\"status\":\"1\",\"msg\":\"数据获取成功!\",\"info\":"); jsonStr.Append("{\"total\":" + dt.Rows.Count + ",\"rows\":"); jsonStr.Append(rowsStr); jsonStr.Append("}}"); context.Response.Write(jsonStr); } catch (Exception e) { context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起,系统出错:" + Utils.HtmlEncode(e.Message) + "\"}"); return; } }
private void GetDepTypeCombobox(HttpContext context, string btn) { string emptyStr = "[{\"ID\":\"0\",\"DepTypeName\":\"无\"}]"; if (btn != "show") { context.Response.Write(emptyStr); return; } try { BLL.System.sys_Department bll = new BLL.System.sys_Department(); DataTable dt = bll.GetDepTypeList().Tables[0]; if (dt != null && dt.Rows.Count > 0) { string rowsStr = Utils.ToJson(dt); context.Response.Write(rowsStr); } else { context.Response.Write(emptyStr); } } catch { context.Response.Write(emptyStr); } }
private void GetDepTree_Repair(HttpContext context, string btn) { if (btn != "show") { context.Response.Write("[]"); return; } try { string SupId = RequestHelper.GetString("SupId").Trim(); string DepId = RequestHelper.GetString("DepId").Trim(); StringBuilder strWhere = new StringBuilder(); if (DepId != "") { strWhere.Append(" (','+SupList like '%," + DepId + ",%' or ID=" + DepId + ") "); } string treeJsonStr = "[]"; BLL.System.sys_Department bll = new BLL.System.sys_Department(); DataTable dt = bll.GetList(strWhere.ToString()).Tables[0]; if (dt != null && dt.Rows.Count > 0) { treeJsonStr = DtToTreeJson(dt, "ID", "DepName", "SupId", "SortId", SupId, SupId); } context.Response.Write(treeJsonStr); } catch { context.Response.Write("[]"); } }
private void DelData(HttpContext context, string btn) { if (btn != "btnDel") { context.Response.Write("{\"status\":\"0.2\",\"msg\":\"对不起,您没有操作权限!\"}"); return; } string idStr = RequestHelper.GetString("idStr"); string nameStr = RequestHelper.GetString("nameStr"); if (idStr == "") { context.Response.Write("{\"status\":\"0\",\"msg\":\"请选择需要删除的记录!\"}"); return; } BLL.System.sys_Department bll = new BLL.System.sys_Department(); Model.System.sys_LoginUser loginUserModel = BaseWeb.GetLoginInfo(); string operaMessage = ""; string status = "0"; string operaAction = ""; string operaMemo = ""; try { if (bll.DeleteList(PageValidate.SafeLongFilter(idStr, 0), out operaMessage)) { status = "1"; operaAction = Enums.ActionEnum.Delete.ToString(); operaMemo = "删除部门:" + nameStr + "(" + idStr + ")"; //写入操作日志 BaseWeb.AddOpera(loginUserModel, int.Parse(RequestHelper.GetQueryString("MenuId")), operaAction, operaMemo); } context.Response.Write("{\"status\":\"" + status + "\",\"msg\":\"" + operaMessage + "\"}"); return; } catch (Exception e) { context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起,系统出错:" + Utils.HtmlEncode(e.Message) + "\"}"); return; } }
private void GetDepTree(HttpContext context, string btn) { if (btn != "show") { context.Response.Write("[]"); return; } try { int depId = RequestHelper.GetInt("id", 1); string treeJsonStr = "[]"; BLL.System.sys_Department bll = new BLL.System.sys_Department(); DataTable dt = bll.GetListByCache_sys_Department().Tables[0]; if (dt != null && dt.Rows.Count > 0) { treeJsonStr = DtToTreeJson(dt, "ID", "DepName", "SupId", "SortId", "0", "0"); } context.Response.Write(treeJsonStr); } catch { context.Response.Write("[]"); } }
private void SaveData(HttpContext context, string btn) { if (btn != "btnSave") { context.Response.Write("{\"status\":\"0.2\",\"msg\":\"对不起,您没有操作权限!\"}"); return; } string id = RequestHelper.GetString("id"); string supId = RequestHelper.GetString("supId"); string depName = RequestHelper.GetString("depName"); string depType = RequestHelper.GetString("depType"); string QDCode = RequestHelper.GetString("QDCode"); string depTel = RequestHelper.GetString("depTel"); string sortId = RequestHelper.GetString("sortId"); string flagUse = RequestHelper.GetString("flagUse"); //string ctrlDep = RequestHelper.GetString("ctrlDep"); if (supId == "") { context.Response.Write("{\"status\":\"0\",\"msg\":\"上级部门编码不能为空!\"}"); return; } if (depName == "") { context.Response.Write("{\"status\":\"0\",\"msg\":\"部门名称不能为空!\"}"); return; } Model.System.sys_LoginUser loginUserModel = BaseWeb.GetLoginInfo(); BLL.System.sys_Department bll = new BLL.System.sys_Department(); Model.System.sys_Department model = new Model.System.sys_Department(); model.ID = Utils.StrToInt(id, 0); model.DepName = depName; model.DepTel = depTel; model.DepTypeId = Utils.StrToInt(depType, 1); model.QDCode = QDCode; model.SortId = Utils.StrToInt(sortId, 1); model.SupId = Utils.StrToInt(supId, 1); model.FlagUse = Utils.StrToBool(flagUse, true); model.OperaName = loginUserModel.PerName; model.OperaTime = DateTime.Now; DataTable dt = bll.GetList(int.Parse(supId)).Tables[0]; model.SupList = dt.Rows[0]["SupList"].ToString() + model.SupId + ","; model.LevelId = Utils.ObjToInt(dt.Rows[0]["levelId"], 1) + 1; //List<Model.System.sys_DepartmentCtrl> ctrlModelList=new List<Model.System.sys_DepartmentCtrl> (); //Model.System.sys_DepartmentCtrl ctrlModel = new Model.System.sys_DepartmentCtrl(); //string[] ctrlDepIdArray = ctrlDep.Split(','); //string[] ctrlDepIdArrayNew= ctrlDepIdArray.Intersect(ctrlDepIdArray).ToArray(); //int ctrlDepId = 0; //foreach (string s in ctrlDepIdArrayNew) //{ // ctrlDepId = Utils.StrToInt(s, 0); // if (ctrlDepId != 0) // { // ctrlModel = new Model.System.sys_DepartmentCtrl(); // ctrlModel.CtrlDepId = ctrlDepId; // ctrlModelList.Add(ctrlModel); // } //} //model.sys_DepartmentCtrls = ctrlModelList; string operaMessage = ""; string status = "0"; string operaAction = ""; string operaMemo = ""; try { if (id == "") { model.ID = bll.Add(model, out operaMessage); if (model.ID > 0) { status = "1"; operaAction = Enums.ActionEnum.Add.ToString(); operaMemo = "新增部门:" + model.DepName + "(" + model.ID + ")"; //写入操作日志 BaseWeb.AddOpera(loginUserModel, int.Parse(RequestHelper.GetQueryString("MenuId")), operaAction, operaMemo); } } else { if (bll.Update(model, out operaMessage)) { status = "1"; operaAction = Enums.ActionEnum.Edit.ToString(); operaMemo = "修改部门:" + model.DepName + "(" + model.ID + ")"; //写入操作日志 BaseWeb.AddOpera(loginUserModel, int.Parse(RequestHelper.GetQueryString("MenuId")), operaAction, operaMemo); } } context.Response.Write("{\"status\":\"" + status + "\",\"msg\":\"" + operaMessage + "\"}"); return; } catch (Exception e) { context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起,系统出错:" + Utils.HtmlEncode(e.Message) + "\"}"); return; } }