public ActionResult btnWebPortalEdit_Click() { try { if (ModelState.IsValid) { Hashtable hasData = new Hashtable(); hasData["ID"] = Request["tbxID"]; hasData["Name"] = Request["tbxName"]; hasData["Address"] = Request["tbxAddress"]; hasData["FUpdateUser"] = GetIdentityName(); hasData["FUpdateDate"] = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); WebPortalDal.Update(hasData); ShowNotify("成功!"); // 关闭本窗体(触发窗体的关闭事件) PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); return(UIHelper.Result()); } } catch { ShowNotify("失败!"); } return(UIHelper.Result()); }
// // GET: /BasicInfo/WebPortal/ public ActionResult Index() { ViewBag.CoreRoleUserNew = CheckPower("CoreRoleUserNew"); ViewBag.CoreRoleUserDelete = CheckPower("CoreRoleUserDelete"); string sql = string.Empty; DataTable dt1 = WebPortalDal.SearchTable(sql); int Grid1SelectedRowID = 0; if (dt1.Rows.Count > 0) { ViewBag.Grid1DataSource = dt1; ViewBag.Grid1SelectedRowID = dt1.Rows[0]["ID"].ToString(); Grid1SelectedRowID = Convert.ToInt32(dt1.Rows[0]["ID"].ToString()); } else { ViewBag.Grid1DataSource = null; ViewBag.Grid1SelectedRowID = 0; Grid1SelectedRowID = 0; } DataTable dt2 = new DataTable(); int count = 0; BindGrid2(Grid1SelectedRowID, 0, 20, "", out dt2, out count); ViewBag.Grid2DataSource = dt2; ViewBag.Grid2RecordCount = count; return(View()); }
public ActionResult btnWebPortalCreate_Click() { if (ModelState.IsValid) { if (WebPortalDal.WebPortalExist(" and Name='" + Request["tbxHost"] + "'").Rows.Count == 0) { try { Hashtable hasData = new Hashtable(); hasData["FCreateUser"] = Convert.ToInt32(GetIdentityName()); hasData["FCreateDate"] = DateTime.Now; hasData["FIsDelete"] = 0; hasData["Name"] = Request["tbxName"]; hasData["Address"] = Request["tbxAddress"]; WebPortalDal.InsertWebPortal(hasData); ShowNotify("添加成功!"); // 关闭本窗体(触发窗体的关闭事件) PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } catch { ShowNotify("添加失败!"); } } else { ShowNotify("门户名称重复,请更换!"); } } return(UIHelper.Result()); }
public ActionResult Index() { string host = Request.Url.Host.ToString(); LoginPage LoginPage = db.LoginPage.ToList().Where(x => x.Host == host).FirstOrDefault(); if (LoginPage != null) { ViewBag.Message = LoginPage.Title; ViewBag.Logo = "/LoginContent/" + LoginPage.FileName + "/img/pandaLogo.png"; } else { ViewBag.Message = "熊猫智慧水务"; ViewBag.Logo = "/LoginContent/default/img/pandaLogo.png"; } LoadData(); var dt = WebPortalDal.SearchWebP_UserTable(" and a.[Type]=4 and UserID=" + Convert.ToInt32(User.Identity.Name)); if (dt.Rows.Count != 0) { ViewBag.Url = dt.Rows[0]["Address"].ToString(); } else { if (GetUserType().Equals("2")) //如果登录用户是分公司 { var dt1 = WebPortalDal.SearchWebP_UserTable(" and a.[Type]=2 and a.DepID='" + GetUserCompanyNumber() + "'"); if (dt1.Rows.Count != 0) { ViewBag.Url = dt1.Rows[0]["Address"].ToString(); } else { ViewBag.Url = "~/Admin/Default"; } } else if (GetUserType().Equals("3")) //如果登录用户是客户 { var dt2 = WebPortalDal.SearchWebP_UserTable(" and a.[Type]=3 and a.CustomerID='" + GetUserCustomer() + "'"); if (dt2.Rows.Count != 0) { ViewBag.Url = dt2.Rows[0]["Address"].ToString(); } else { ViewBag.Url = "~/Admin/Default"; } } else { ViewBag.Url = "~/Admin/Default"; } } return(View()); }
public ActionResult btnCreate_Click() { if (ModelState.IsValid) { try { string name = ""; if (Request["ddlType"] == "4") { name = Request["tbxUserID"]; } if (Request["ddlType"] == "3") { name = Request["tbxCustomerID"]; } if (Request["ddlType"] == "2") { name = Request["ddlCompany"]; } if (WebPortalDal.Exist(name, Convert.ToInt32(Request["ddlType"])).Rows.Count == 0) { Hashtable hasData = new Hashtable(); hasData["WId"] = Request["tbxWID"]; hasData["UserID"] = Request["tbxUserID"]; hasData["Type"] = Request["ddlType"]; hasData["CustomerID"] = Request["tbxCustomerID"]; hasData["DepID"] = Request["ddlCompany"]; WebPortalDal.Insert(hasData); ShowNotify("添加成功!"); // 关闭本窗体(触发窗体的关闭事件) PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } else { ShowNotify("用户名重复,请更换!"); } } catch { ShowNotify("添加失败!"); } } return(UIHelper.Result()); }
private void BindGrid1(int pageIndex, int pageSize, string selectTest, string actionType, out DataTable table, out int count) { string sql = string.Empty; if (!selectTest.Equals("")) { if (actionType == "trigger2") { sql = sql + " and Name like '%" + selectTest + "%'"; } } Hashtable has = WebPortalDal.Search(pageIndex, pageSize, "FCreateDate", "asc", sql); count = Int32.Parse(has["total"].ToString()); table = (DataTable)has["data"]; }
public ActionResult FZ_Grid1_DoPostBack(JArray Grid1_fields, int Grid1_pageIndex, string ttbSearchMessage, string ttbSearchCustomer, string ttbSearchCompany, int ddlGridPageSize, string actionType, JArray deleteIds) { var ttbSearchMessageUI = UIHelper.TwinTriggerBox("ttbSearchMessage"); string search = string.Empty; if (actionType == "trigger1") { ttbSearchMessageUI.Text(String.Empty); ttbSearchMessageUI.ShowTrigger1(false); ttbSearchMessage = String.Empty; search = ttbSearchMessage; } else if (actionType == "trigger2") { ttbSearchMessageUI.ShowTrigger1(true); search = ttbSearchMessage; } else if (actionType == "delete") { string values = ""; foreach (int ID in deleteIds) { values = values + ID.ToString() + ","; } values = values.Substring(0, values.LastIndexOf(',')); Hashtable hasData = new Hashtable(); hasData["ID"] = values; hasData["FIsDelete"] = 1; hasData["FUpdateDate"] = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ssss")); hasData["FUpdateUser"] = GetIdentityName(); WebPortalDal.DeleteList(hasData); } var grid1UI = UIHelper.Grid("Grid1"); DataTable dt2 = new DataTable(); int count = 0; BindGrid1(Grid1_pageIndex, ddlGridPageSize, search, actionType, out dt2, out count); grid1UI.DataSource(dt2, Grid1_fields); grid1UI.RecordCount(count); grid1UI.PageSize(ddlGridPageSize); return(UIHelper.Result()); }
private void BindGrid2(int grid1SelectedRowID, int pageIndex, int pageSize, string selectTest, out DataTable table, out int count) { int WId = grid1SelectedRowID; string sql = string.Empty; table = new DataTable(); count = 0; if (WId == -1) { table = null; count = 0; } else { sql = sql + " and a.WId=" + WId.ToString(); Hashtable has = WebPortalDal.SearchWebP_User(pageIndex, pageSize, "b.Name", "ASC", sql); count = Int32.Parse(has["total"].ToString()); table = (DataTable)has["data"]; } }
public ActionResult RoleUser_Grid2_DoPostBack(JArray Grid1_fields, JArray Grid2_fields, int Grid2_pageIndex, string ttbSearchMessage, string ttbSearchCustomer, int ddlGridPageSize, string actionType, int selectedRoleId, JArray deleteUserIds) { var ttbSearchMessageUI = UIHelper.TwinTriggerBox("ttbSearchMessage"); var ttbSearchCustomerUI = UIHelper.TwinTriggerBox("ttbSearchCustomer"); if (actionType == "trigger1") { ttbSearchMessageUI.Text(String.Empty); ttbSearchMessageUI.ShowTrigger1(false); ttbSearchMessage = String.Empty; ttbSearchCustomerUI.Text(String.Empty); ttbSearchCustomerUI.ShowTrigger1(false); ttbSearchCustomer = String.Empty; DataTable dt1 = sys_rolesDal.SearchTable(" and RType=0"); if (dt1.Rows.Count > 0) { selectedRoleId = Convert.ToInt32(dt1.Rows[0]["ID"].ToString()); } else { selectedRoleId = 0; } var grid1UI = UIHelper.Grid("Grid1"); grid1UI.DataSource(dt1, Grid1_fields); } else if (actionType == "trigger2") { ttbSearchMessageUI.ShowTrigger1(true); ttbSearchCustomerUI.Text(String.Empty); ttbSearchCustomerUI.ShowTrigger1(false); } else if (actionType == "trigger3") { ttbSearchCustomerUI.ShowTrigger1(true); ttbSearchMessageUI.Text(String.Empty); ttbSearchMessageUI.ShowTrigger1(false); string sql1 = string.Empty; if (!ttbSearchCustomer.Equals("")) { sql1 = " and RType=1 and b.Name='" + ttbSearchCustomer + "'"; } else { sql1 = " and RType=0"; } DataTable dt1 = WebPortalDal.SearchTable(sql1); if (dt1.Rows.Count > 0) { selectedRoleId = Convert.ToInt32(dt1.Rows[0]["ID"].ToString()); } else { selectedRoleId = 0; } var grid1UI = UIHelper.Grid("Grid1"); grid1UI.DataSource(dt1, Grid1_fields); ttbSearchMessage = ""; } else if (actionType == "delete") { // 在操作之前进行权限检查 string values = ""; foreach (int userID in deleteUserIds) { values = values + userID.ToString() + ","; } values = values.Substring(0, values.LastIndexOf(',')); WebPortalDal.DeletWebP_UserList(Convert.ToInt32(values)); } var grid2UI = UIHelper.Grid("Grid2"); DataTable dt2 = new DataTable(); int count = 0; BindGrid2(selectedRoleId, Grid2_pageIndex, ddlGridPageSize, ttbSearchMessage, out dt2, out count); grid2UI.DataSource(dt2, Grid2_fields); grid2UI.RecordCount(count); grid2UI.PageSize(ddlGridPageSize); return(UIHelper.Result()); }