public ActionResult MyCustomPostBack(string type, JArray gridFields, JObject typeParams, int gridIndex, int gridPageSize, string FSchemeID)
{
var Grid1 = UIHelper.Grid("Grid1");
string sql = string.Empty;
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 FName like '%" + triggerValue + "%'";
}
sql = sql + " AND FSchemeID= " + Convert.ToInt32(FSchemeID);
Hashtable table = AddressSchemeEntryDal.Search(gridIndex, gridPageSize, "id", "ASC", sql);
Grid1.PageSize(gridPageSize);
Grid1.DataSource(table["data"], gridFields);
Grid1.RecordCount(Int32.Parse(table["total"].ToString()));
return(UIHelper.Result());
}
public ActionResult Grid1_AfterEdit(JArray Grid1_fields, JArray Grid1_modifiedData, int Grid1_pageIndex, string FSchemeID, int gridPageSize, string searchMessage)
{
foreach (JObject modifiedRow in Grid1_modifiedData)
{
string status = modifiedRow.Value <string>("status");
int rowId = Convert.ToInt32(modifiedRow.Value <string>("id"));
if (status == "modified")
{
Hashtable hasData = new Hashtable();
hasData["ID"] = rowId;
Dictionary <string, object> rowDict = modifiedRow.Value <JObject>("values").ToObject <Dictionary <string, object> >();
if (rowDict.ContainsKey("FPLCAddress"))
{
hasData["FPLCAddress"] = rowDict["FPLCAddress"];
}
if (rowDict.ContainsKey("FWorR"))
{
hasData["FWorR"] = rowDict["FWorR"];
}
if (rowDict.ContainsKey("FUnit"))
{
hasData["FUnit"] = rowDict["FUnit"];
}
if (rowDict.ContainsKey("FRate"))
{
hasData["FRate"] = rowDict["FRate"];
}
if (rowDict.ContainsKey("FNote"))
{
hasData["FNote"] = rowDict["FNote"];
}
AddressSchemeEntryDal.Update(hasData);
}
}
var grid1 = UIHelper.Grid("Grid1");
string sql = string.Empty;
if (!searchMessage.Equals(""))
{
sql = sql + " and FName like '%" + searchMessage + "%'";
}
sql = sql + " AND FSchemeID= " + Convert.ToInt32(FSchemeID);
Hashtable table = AddressSchemeEntryDal.Search(Grid1_pageIndex, gridPageSize, "id", "ASC", sql);
var recordCount = Int32.Parse(table["total"].ToString());
// 1.设置总项数（数据库分页回发时，如果总记录数不变，可以不设置RecordCount）
grid1.RecordCount(recordCount);
grid1.PageSize(gridPageSize);
// 2.获取当前分页数据
var dataSource = table["data"];
grid1.DataSource(dataSource, Grid1_fields);
return(UIHelper.Result());
}
public ActionResult AddressSchemeEntry(string FSchemeID)
{
Hashtable table = AddressSchemeEntryDal.Search(0, 1000, "id", "ASC", " AND FSchemeID= " + Convert.ToInt32(FSchemeID));
ViewBag.Grid1DataSource = table["data"];
ViewBag.Grid1RecordCount = Int32.Parse(table["total"].ToString());
ViewBag.FSchemeID = FSchemeID;
return(View());
}
public ActionResult btnCreate_Click()
{
try
{
if (ModelState.IsValid)
{
Hashtable hasData = new Hashtable();
hasData["FNumber"] = Request["tbxFNumber"];
hasData["FName"] = Request["tbxFName"];
hasData["FStartAddress"] = Request["tbxFStartAddress"];
hasData["FAddressLength"] = Convert.ToInt32(Request["tbxFAddressLength"]);
hasData["FNote"] = Request["tbxFNote"];
hasData["FOrderBy"] = Convert.ToInt32(Request["tbxFOrderBy"]);
hasData["FType"] = Request["ddlFType"];
hasData["FCreateUser"] = GetIdentityName();
hasData["FCreateDate"] = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
hasData["FIsDelete"] = 0;
int id = AddressSchemeDal.Insert(hasData);
if (id > 0)
{
DataTable table = AddressSchemeDal.SearchALL("", hasData["FType"].ToString());
for (int i = 0; i < table.Rows.Count; i++)
{
Hashtable hashtable = new Hashtable();
hashtable["FSchemeID"] = id;
hashtable["FName"] = table.Rows[i]["FName"].ToString();
hashtable["FPLCAddress"] = table.Rows[i]["FPLCAddress"].ToString();
hashtable["FDBAddress"] = table.Rows[i]["FDBAddress"].ToString();
hashtable["FWorR"] = table.Rows[i]["FWorR"].ToString();
hashtable["FNote"] = table.Rows[i]["FNote"].ToString();
hashtable["FUnit"] = table.Rows[i]["FUnit"].ToString();
hashtable["FRate"] = table.Rows[i]["FRate"].ToString();
hashtable["FCreateDate"] = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
AddressSchemeEntryDal.Insert(hashtable);
}
}
ShowNotify("成功！");
// 关闭本窗体（触发窗体的关闭事件）'
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
}
}
catch
{
ShowNotify("失败！");
}
return(UIHelper.Result());
}
public ActionResult Grid1_PageIndexChanged(JArray Grid1_fields, int Grid1_pageIndex, string FSchemeID, int gridPageSize, string searchMessage)
{
var grid1 = UIHelper.Grid("Grid1");
string sql = string.Empty;
if (!searchMessage.Equals(""))
{
sql = sql + " and FName like '%" + searchMessage + "%'";
}
sql = sql + " AND FSchemeID= " + Convert.ToInt32(FSchemeID);
Hashtable table = AddressSchemeEntryDal.Search(Grid1_pageIndex, gridPageSize, "id", "ASC", sql);
var recordCount = Int32.Parse(table["total"].ToString());
// 1.设置总项数（数据库分页回发时，如果总记录数不变，可以不设置RecordCount）
grid1.RecordCount(recordCount);
grid1.PageSize(gridPageSize);
// 2.获取当前分页数据
var dataSource = table["data"];
grid1.DataSource(dataSource, Grid1_fields);
return(UIHelper.Result());
}
