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());
}
