public ActionResult btnEdit_Click() { try { if (ModelState.IsValid) { int FCustomerID = Convert.ToInt32(Request["tbxCustomerID"]); Hashtable hasData = new Hashtable(); hasData["ID"] = Request["tbxID"]; hasData["G_Name"] = Request["tbxName"]; hasData["FUpdUser"] = GetIdentityName(); hasData["FUpdDate"] = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); Panda_PumpFGDal.Update(hasData); ShowNotify("成功!"); // 关闭本窗体(触发窗体的关闭事件) PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); return(UIHelper.Result()); } } catch { ShowNotify("失败!"); } return(UIHelper.Result()); }
public ActionResult btnCreate_Click() { if (ModelState.IsValid) { try { Hashtable hasData = new Hashtable(); hasData["FCreateUser"] = Convert.ToInt32(GetIdentityName()); hasData["FCreateDate"] = DateTime.Now; hasData["FIsDelete"] = 0; hasData["G_Name"] = Request["tbxName"]; hasData["G_Type"] = Convert.ToInt32(Request["ddlType"]); hasData["FCustomerID"] = Convert.ToInt32(Request["tbxCustomerID"]); hasData["FCompanyNumber"] = Request["ddlCompany"]; Panda_PumpFGDal.Insert(hasData); ShowNotify("添加成功!"); // 关闭本窗体(触发窗体的关闭事件) PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } 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 a.G_Name like '%" + selectTest + "%'"; } else if (actionType == "trigger3") { sql = sql + " and e.Name like '%" + selectTest + "%'"; } else if (actionType == "trigger4") { sql = sql + " and c.Fengongsi like '%" + selectTest + "%'"; } } if (GetUserType().Equals("2")) { sql = sql + " and a.FCompanyNumber='" + GetUserCompanyNumber() + "'"; } else if (GetUserType().Equals("3")) { sql = sql + " and a.FCustomerID=" + GetUserCustomer(); } Hashtable has = Panda_PumpFGDal.SearchPumpFG(pageIndex, pageSize, "G_Type", "asc", sql); count = Int32.Parse(has["total"].ToString()); table = (DataTable)has["data"]; }
public ActionResult GridGPump_DoPostBack(JArray GridGPump_fields, int GridGPump_pageIndex, string ttbSearchMessage, int ddlGridPageSize, string actionType, JArray deleteIds, int groupId) { var ttbSearchMessageUI = UIHelper.TwinTriggerBox("ttbSearchMessage"); if (actionType == "trigger1") { ttbSearchMessageUI.Text(String.Empty); ttbSearchMessageUI.ShowTrigger1(false); ttbSearchMessage = String.Empty; } else if (actionType == "trigger2") { ttbSearchMessageUI.ShowTrigger1(true); } else if (actionType == "delete") { // 在操作之前进行权限检查 if (!CheckPower("CorePumpGDelete")) { CheckPowerFailWithAlert(); return(UIHelper.Result()); } //foreach (int ID in deleteIds) //{ // Panda_PumpFG_P item = db.Panda_PumpFG_P.Find(ID); // db.Panda_PumpFG_P.Remove(item); //} //db.SaveChanges(); string values = ""; foreach (int ID in deleteIds) { values = values + ID.ToString() + ","; } values = values.Substring(0, values.LastIndexOf(',')); Panda_PumpFGDal.DeleteGroupPumpList(values); } var grid1UI = UIHelper.Grid("GridGPump"); DataTable dt2 = new DataTable(); int count = 0; BindGridGPump(GridGPump_pageIndex, ddlGridPageSize, ttbSearchMessage, groupId, out dt2, out count); grid1UI.DataSource(dt2, GridGPump_fields); grid1UI.RecordCount(count); grid1UI.PageSize(ddlGridPageSize); return(UIHelper.Result()); }
public ActionResult GridGPump_Insert(JArray GridGPump_fields, int gridIndex, int gridPageSize, int groupId, string idList) { string[] id = idList.Split(','); Panda_PumpFG_P pump = new Panda_PumpFG_P(); pump.GroupID = groupId; for (int i = 0; i < id.Length; i++) { pump.PumpID = id[i]; db.Panda_PumpFG_P.Add(pump); db.SaveChanges(); } var grid1 = UIHelper.Grid("GridGPump"); string sql = string.Empty; sql = sql + " and a.GroupID = " + groupId; Hashtable has = Panda_PumpFGDal.SearchGroupPump(gridIndex, gridPageSize, "b.FCreateDate", "asc", sql); grid1.DataSource(has["data"], GridGPump_fields); grid1.RecordCount(Int32.Parse(has["total"].ToString())); return(UIHelper.Result()); }
private void BindGridGPump(int pageIndex, int pageSize, string selectTest, int groupId, out DataTable table, out int count) { string sql = string.Empty; sql = sql + " and a.GroupID=" + groupId; if (!selectTest.Equals("")) { sql = sql + " and (b.PName like '%" + selectTest + "%' or b.PCustomPName like '%" + selectTest + "%')"; } if (GetUserType().Equals("2")) { sql = sql + " and b.PCompanyNumber='" + GetUserCompanyNumber() + "'"; } else if (GetUserType().Equals("3")) { sql = sql + " and b.FCustomerID=" + GetUserCustomer(); } Hashtable has = Panda_PumpFGDal.SearchGroupPump(pageIndex, pageSize, "b.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"); var ttbSearchCustomerUI = UIHelper.TwinTriggerBox("ttbSearchCustomer"); var ttbSearchCompanyUI = UIHelper.TwinTriggerBox("ttbSearchCompany"); string search = string.Empty; if (actionType == "trigger1") { ttbSearchMessageUI.Text(String.Empty); ttbSearchMessageUI.ShowTrigger1(false); ttbSearchMessage = String.Empty; ttbSearchCustomerUI.Text(String.Empty); ttbSearchCustomerUI.ShowTrigger1(false); ttbSearchCustomer = String.Empty; ttbSearchCompanyUI.Text(String.Empty); ttbSearchCompanyUI.ShowTrigger1(false); ttbSearchCompany = String.Empty; } else if (actionType == "trigger2") { ttbSearchMessageUI.ShowTrigger1(true); ttbSearchCustomerUI.Text(String.Empty); ttbSearchCustomerUI.ShowTrigger1(false); ttbSearchCustomer = String.Empty; ttbSearchCompanyUI.Text(String.Empty); ttbSearchCompanyUI.ShowTrigger1(false); ttbSearchCompany = String.Empty; search = ttbSearchMessage; } else if (actionType == "trigger3") { ttbSearchCustomerUI.ShowTrigger1(true); ttbSearchMessageUI.Text(String.Empty); ttbSearchMessageUI.ShowTrigger1(false); ttbSearchMessage = String.Empty; ttbSearchCompanyUI.Text(String.Empty); ttbSearchCompanyUI.ShowTrigger1(false); ttbSearchCompany = String.Empty; search = ttbSearchCustomer; } else if (actionType == "trigger4") { ttbSearchCompanyUI.ShowTrigger1(true); ttbSearchCustomerUI.Text(String.Empty); ttbSearchCustomerUI.ShowTrigger1(false); ttbSearchCustomer = String.Empty; ttbSearchMessageUI.Text(String.Empty); ttbSearchMessageUI.ShowTrigger1(false); ttbSearchMessage = String.Empty; search = ttbSearchCompany; } 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["FDelDate"] = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ssss")); hasData["FDelUser"] = GetIdentityName(); Panda_PumpFGDal.DeleteGroupList(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()); }