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