public ActionResult MyCustomJZPostBack(string type, JArray gridFields, JObject typeParams, int gridIndex, int gridPageSize, Guid jyzId) { var GridJZ = UIHelper.Grid("GridJZ"); string sql = string.Empty; sql = sql + " and jyzId = '" + jyzId + "'"; var ttbSearch = UIHelper.TwinTriggerBox("ttbSearchMessage"); if (type == "trigger1") { ttbSearch.Text(String.Empty); ttbSearch.ShowTrigger1(false); } else if (type == "trigger2") { ttbSearch.ShowTrigger1(true); var triggerValue = typeParams.Value <string>("triggerValue"); sql = " and jyzJZName like '%" + triggerValue + "%'"; } Hashtable table = BASE_JIAYAZHAN_JZDal.SearchJYZ(gridIndex, gridPageSize, "a.FCreateDate", "DESC", sql); GridJZ.DataSource(table["data"], gridFields); GridJZ.RecordCount(Int32.Parse(table["total"].ToString())); GridJZ.PageSize(gridPageSize); return(UIHelper.Result()); }
public ActionResult GridJZ_Delete(JArray selectedRows, JArray GridJZ_fields, int gridIndex, int gridPageSize, Guid jyzId) { string values = ""; for (int i = 0; i < selectedRows.Count; i++) { if (i != selectedRows.Count - 1) { values += "'" + selectedRows[i] + "',"; } else { values += "'" + selectedRows[i] + "'"; } } 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(); BASE_JIAYAZHAN_JZDal.DeleteList(hasData); UpdateGridJZ(GridJZ_fields, gridIndex, gridPageSize, jyzId); return(UIHelper.Result()); }
public ActionResult JYZ_JZ(Guid id) { ViewBag.CoreJYZJZNew = CheckPower("CoreJYZJZNew"); ViewBag.CoreJYZJZDelete = CheckPower("CoreJYZJZDelete"); ViewBag.CoreJYZJZEdit = CheckPower("CoreJYZJZEdit"); ViewBag.jyzId = id.ToString(); Hashtable table = BASE_JIAYAZHAN_JZDal.SearchJYZ(0, 20, "a.FCreateDate", "DESC", " and jyzId='" + id + "'"); DataTable dt = (DataTable)table["data"]; if (dt.Rows.Count > 0) { int customerid = Convert.ToInt32(dt.Rows[0]["FCustomerID"]); if (customerid > 0) { ViewBag.Hidden = false; } else { ViewBag.Hidden = true; } } ViewBag.GridJZDataSource = table["data"]; ViewBag.GridJZRecordCount = Int32.Parse(table["total"].ToString()); return(View()); }
private void UpdateGridJZ(JArray GridJZ_fields, int gridIndex, int gridPageSize, Guid jyzId) { var GridJZ = UIHelper.Grid("GridJZ"); string sql = string.Empty; sql = sql + " and jyzId = '" + jyzId + "'"; Hashtable table = BASE_JIAYAZHAN_JZDal.SearchJYZ(gridIndex, gridPageSize, "a.FCreateDate", "DESC", sql); GridJZ.DataSource(table["data"], GridJZ_fields); GridJZ.RecordCount(Int32.Parse(table["total"].ToString())); }
public ActionResult GridJZ_PageIndexChanged(JArray GridJZ_fields, int GridJZ_pageIndex, int gridPageSize, Guid jyzId, string searchMessage) { var GridJZ = UIHelper.Grid("GridJZ"); string sql = string.Empty; if (!searchMessage.Equals("")) { sql = sql + " and jyzJZName like '%" + searchMessage + "%'"; } sql = sql + " and jyzId = '" + jyzId + "'"; Hashtable table = BASE_JIAYAZHAN_JZDal.SearchJYZ(GridJZ_pageIndex, gridPageSize, "a.FCreateDate", "DESC", sql); GridJZ.DataSource(table["data"], GridJZ_fields); GridJZ.RecordCount(Int32.Parse(table["total"].ToString())); return(UIHelper.Result()); }
public ActionResult btnJZCreate_Click() { try { if (ModelState.IsValid) { if (BASE_JIAYAZHAN_JZDal.Exist(" and DTUCode='" + Request["tbSelectedDTU"] + "'").Rows.Count == 0) { string jz_id = Guid.NewGuid().ToString(); Hashtable hasData = new Hashtable(); hasData["ID"] = jz_id; hasData["DTUCode"] = Request["tbSelectedDTU"]; hasData["jyzId"] = Request["jyzId"]; hasData["FType"] = Request["ddlType"]; hasData["jyzJZName"] = Request["tbxName"]; hasData["jyzJZAddressList"] = Request["hidDZB"] == "" ? "0" : Request["hidDZB"]; hasData["jyzJZCollectPeriod"] = Request["txt_cjzq"]; //采集周期 hasData["jyzJZCollectLength"] = Request["txt_cjcd"]; //采集长度 hasData["jyzJZReadMode"] = Request["ddlDqms"]; //读取模式 hasData["FCreateUser"] = GetIdentityName(); hasData["FCreateDate"] = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); hasData["FIsDelete"] = 0; hasData["FSort"] = Request["txtFSort"]; BASE_JIAYAZHAN_JZDal.Insert(hasData); ShowNotify("成功!"); // 关闭本窗体(触发窗体的关闭事件) PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } else { ShowNotify("加压站编号重复,请更换!"); } } } catch { ShowNotify("失败!"); } return(UIHelper.Result()); }