public ActionResult MyCustomJZPostBack(string type, JArray gridFields, JObject typeParams, int gridIndex, int gridPageSize, Guid ShuiChangId)
{
var GridJZ = UIHelper.Grid("GridJZ");
string sql = string.Empty;
sql = sql + " and ShuiChangId = '" + ShuiChangId + "'";
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 a.FName like '%" + triggerValue + "%'";
}
Hashtable table = BASE_SHUICHANG_JZDal.Search(gridIndex, gridPageSize, "a.FCreateDate", "DESC", sql);
GridJZ.DataSource(table["data"], gridFields);
GridJZ.RecordCount(Int32.Parse(table["total"].ToString()));
GridJZ.PageSize(gridPageSize);
return(UIHelper.Result());
}
private void UpdateGridJZ(JArray GridJZ_fields, int gridIndex, int gridPageSize, Guid ShuiChangId)
{
var GridJZ = UIHelper.Grid("GridJZ");
string sql = string.Empty;
sql = sql + " and ShuiChangId = '" + ShuiChangId + "'";
Hashtable table = BASE_SHUICHANG_JZDal.Search(gridIndex, gridPageSize, "a.FCreateDate", "DESC", sql);
GridJZ.DataSource(table["data"], GridJZ_fields);
GridJZ.RecordCount(Int32.Parse(table["total"].ToString()));
}
public ActionResult WaterJZ(Guid id)
{
ViewBag.CorePumpJZNew = CheckPower("CoreWaterJZNew");
ViewBag.CorePumpJZDelete = CheckPower("CoreWaterJZDelete");
ViewBag.CorePumpJZEdit = CheckPower("CoreWaterJZEdit");
ViewBag.CorePumpJZAlermSet = CheckPower("CoreWaterJZAlermSet");
ViewBag.ShuiChangId = id.ToString();
Hashtable table = BASE_SHUICHANG_JZDal.Search(0, 20, "a.FCreateDate", "DESC", " and a.ShuiChangId='" + id + "'");
ViewBag.GridJZDataSource = table["data"];
ViewBag.GridJZRecordCount = Int32.Parse(table["total"].ToString());
return(View());
}
public ActionResult GridJZ_PageIndexChanged(JArray GridJZ_fields, int GridJZ_pageIndex, int gridPageSize, Guid ShuiChangId, string searchMessage)
{
var GridJZ = UIHelper.Grid("GridJZ");
string sql = string.Empty;
if (!searchMessage.Equals(""))
{
sql = sql + " and FName like '%" + searchMessage + "%'";
}
sql = sql + " and ShuiChangId = '" + ShuiChangId + "'";
Hashtable table = BASE_SHUICHANG_JZDal.Search(GridJZ_pageIndex, gridPageSize, "a.FCreateDate", "DESC", sql);
GridJZ.DataSource(table["data"], GridJZ_fields);
GridJZ.RecordCount(Int32.Parse(table["total"].ToString()));
return(UIHelper.Result());
}