public string Added(FormCollection form) { var stateInfo = GeneralHandler.StateSuccess; if (AddedByCheck(form, out stateInfo)) { DawnAuthExtentMDL dataInfo = new DawnAuthExtentMDL(); dataInfo.ExteTime = DateTime.Now; dataInfo.ExteStatus = 1; dataInfo.ExteCode = form["txtCode"].Trim(); dataInfo.ExteCodeName = form["txtCodeName"].Trim(); dataInfo.ExteMark = form["txtMark"].Trim(); dataInfo.ExteMarkName = form["txtMarkName"].Trim(); dataInfo.ExteMemo = form["txtMemo"].Trim(); bool added = DawnAuthExtentBLL.Exists(string.Format("exte_code='{0}' and exte_mark='{1}'", dataInfo.ExteCode, dataInfo.ExteMark)); if (added) { stateInfo = GeneralHandler.StateAdded; } else { DawnAuthExtentBLL.Insert(dataInfo); } } return(stateInfo); }
public string Synced(FormCollection form) { var stateInfo = GeneralHandler.StateSuccess; if (GetSyncDataByCheck(form, out stateInfo)) { string txtSetCode = form["txtSetCode"] as string; string txtSetName = form["txtSetName"] as string; int sltSyncItem = TypeHelper.TypeToInt32(form["sltSyncItem"], 2); string txtFieldTable = form["txtFieldTable"] as string; string txtFieldMark = form["txtFieldMark"] as string; string txtFieldName = form["txtFieldName"] as string; string txtFieldMemo = form["txtFieldMemo"] as string; string txtFieldWhere = form["txtFieldWhere"] as string; string txtConnSource = form["txtConnSource"] as string; string txtConnData = form["txtConnData"] as string; string txtConnUser = form["txtConnUser"] as string; string txtConnPwd = form["txtConnPwd"] as string; System.Data.DataTable dt = Session["ExtentSyncData"] as System.Data.DataTable;//直接获取会话数据 try { if (dt.Rows.Count > 0) { if (sltSyncItem == 2) { DawnAuthExtentBLL.DeleteWhere(string.Format("exte_status=2 and exte_code='{0}'", txtSetCode)); } System.Text.StringBuilder sb = new System.Text.StringBuilder(); //DawnAuthExtentMDL dataInfo; DawnAuthExtentMDL dataInfo = new DawnAuthExtentMDL(); foreach (System.Data.DataRow dr in dt.Rows) { //dataInfo = new DawnAuthExtentMDL(); dataInfo.ExteTime = DateTime.Now; dataInfo.ExteStatus = 2; dataInfo.ExteCode = txtSetCode; dataInfo.ExteCodeName = txtSetName; dataInfo.ExteMark = dr[txtFieldMark].ToString(); dataInfo.ExteMarkName = dr[txtFieldName].ToString(); dataInfo.ExteMemo = txtFieldMemo == "null" ? "无" : dr[txtFieldMemo].ToString(); DawnAuthExtentBLL.Insert(dataInfo); } dataInfo = null; } else { stateInfo = "请先执行【获取数据】操作后,再执行【开始同步】操作。"; } Session["ExtentSyncData"] = null; } catch (Exception ex) { Session["ExtentSyncData"] = null; stateInfo = ex.Message; GeneralHandler.InsertByError(ex); } } return(stateInfo); }
public string Delete(string id) { var stateInfo = GeneralHandler.StateSuccess; if (!string.IsNullOrEmpty(id)) { DawnAuthExtentBLL.Delete(int.Parse(id)); } return(stateInfo); }
/// <summary> /// 管理员权限扩展 /// </summary> /// <param name="id">管理员编号</param> /// <param name="pager">页码</param> /// <returns>执行结果</returns> public ActionResult BindExtent(string id, string pager) { if (string.IsNullOrEmpty(id) || TypeHelper.TypeToInt32(id, -1) < 0) { return(RedirectToAction("List")); } ViewBag.UserId = id; ViewBag.PageCurrent = pager; return(View(DawnAuthExtentBLL.SelectByCodeList())); }
/// <summary> /// 权限扩展数据列表 /// </summary> /// <param name="id">数据表单</param> /// <returns>执行结果</returns> public ActionResult Search(FormCollection form) { string strWhere = null; var pgParam = "Nothing,Nothing"; //扩展编码 var txtCode = form["txtCode"] as string; if (!string.IsNullOrEmpty(txtCode) && ValidHelper.EngIsEngAndNum(txtCode)) { pgParam += string.Format(",txtCode,{0}", txtCode); if (strWhere == null) { strWhere = string.Format("charindex('{0}',exte_code)>0", txtCode); } else { strWhere += string.Format(" and charindex('{0}',exte_code)>0", txtCode); } } //扩展标识 var txtMark = form["txtMark"] as string; if (!string.IsNullOrEmpty(txtMark) && ValidHelper.EngIsEngAndNum(txtMark)) { pgParam += string.Format(",txtMark,{0}", txtMark); if (strWhere == null) { strWhere = string.Format("charindex('{0}',exte_mark)>0", txtMark); } else { strWhere += string.Format(" and charindex('{0}',exte_mark)>0", txtMark); } } var dataPager = new PagerHelperCHS(); dataPager.PageSize = GeneralHandler.PageSize; if (form.Count > 1) { dataPager.PageCurrent = TypeHelper.TypeToInt32(form["pager"], 1); } else { dataPager.PageCurrent = TypeHelper.TypeToInt32(form["id"], 1); } int pageCount, recordCount; var dataList = DawnAuthExtentBLL.SelectPSPisAllPurposeRowNumber(dataPager.PageSize, dataPager.PageCurrent, "exte_time desc,exte_code", strWhere, out pageCount, out recordCount); dataPager.PageCount = pageCount; dataPager.RecordCount = recordCount; dataPager.PageRecordCount = dataList.Count; ViewBag.Pager = dataPager; ViewBag.PagerParam = pgParam; return(View("List", dataList)); }
/// <summary> /// 权限扩展数据列表 /// </summary> /// <param name="id">页码</param> /// <returns>执行结果</returns> public ActionResult List(string id) { var pager = new PagerHelperCHS(); pager.PageSize = GeneralHandler.PageSize; pager.PageCurrent = TypeHelper.TypeToInt32(id, 1); int pageCount, recordCount; var dataList = DawnAuthExtentBLL.SelectPSPisAllPurposeRowNumber(pager.PageSize, pager.PageCurrent, null, out pageCount, out recordCount); pager.PageCount = pageCount; pager.RecordCount = recordCount; pager.PageRecordCount = dataList.Count; ViewBag.Pager = pager; ViewBag.PagerParam = null; return(View(dataList)); }
public string GetExtentMark(FormCollection form) { string exteCode = form["exteCode"] as string; int userId = TypeHelper.TypeToInt32(form["userId"], 0); if (string.IsNullOrEmpty(exteCode) || userId < 1) { return(GeneralHandler.FNoneInfo); } var dataList = DawnAuthExtentBLL.ISelect(string.Format("exte_code='{0}'", exteCode)); if (dataList == null || dataList.Count < 1) { return(GeneralHandler.FNoneInfo); } var mapExtent = UserHandler.GetUserExtent(userId, exteCode); int indexVal = 0; StringBuilder sb = new StringBuilder(); foreach (var item in dataList) { indexVal++; sb.Append("<li class=\"field-item bi\">"); sb.AppendFormat("<label class=\"fixed240\">{0}</label>", item.ExteMarkName); var findFun = string.Format(",{0},", item.ExteMark); if (mapExtent != null && mapExtent.Contains(findFun)) { sb.AppendFormat("<input class=\"switch-on\" type=\"button\" id=\"btn{0}\" onclick=\"dataUnSave({0},{1},'{2}','{3}');\" />", indexVal, userId, exteCode, item.ExteMark); } else { sb.AppendFormat("<input class=\"switch-off\" type=\"button\" id=\"btn{0}\" onclick=\"dataSave({0},{1},'{2}','{3}');\" />", indexVal, userId, exteCode, item.ExteMark); } sb.AppendFormat("<span class=\"margin-left-10\">{0}</span>", item.ExteMemo); sb.Append("</li>"); } return(sb.ToString()); }
/// <summary> /// 获得权限扩展编码数据列表 /// </summary> /// <returns>数据集合</returns> public static IList <SelectListItem> GetSelectList() { var list = new List <SelectListItem>() { new SelectListItem() { Value = "-1", Text = "--请选择--" } }; var dataList = DawnAuthExtentBLL.SelectByCodeList(); if (dataList.Rows.Count > 0) { foreach (DataRow dr in dataList.Rows) { SelectListItem sli = new SelectListItem(); sli.Text = dr["exte_code_name"].ToString(); sli.Value = dr["exte_code"].ToString(); list.Add(sli); } } return(list); }