public ActionResult Grid1_Delete(JArray selectedRows, JArray Grid1_fields, int gridIndex, int gridPageSize)
{
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_SHUICHANGDal.DeleteList(hasData);
Bll.Map_MarkerBll.DeleteMarker(4, values);
UpdateGrid(Grid1_fields, gridIndex, gridPageSize);
return(UIHelper.Result());
}
public ActionResult MyCustomPostBack(string type, JArray gridFields, JObject typeParams, int gridIndex, int gridPageSize)
{
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 + getPowerConst("water");
Hashtable table = BASE_SHUICHANGDal.Search(gridIndex, gridPageSize, "a.FCreateDate", "DESC", sql);
Grid1.DataSource(table["data"], gridFields);
Grid1.RecordCount(Int32.Parse(table["total"].ToString()));
return(UIHelper.Result());
}
public ActionResult btnBasicEdit_Click()
{
try
{
if (ModelState.IsValid)
{
int FCustomerID = Convert.ToInt32(Request["tbxCustomerID"]);
Hashtable hasData = new Hashtable();
hasData["id"] = Request["tbxID"];
hasData["FName"] = Request["tbxName"];
hasData["FCustomerID"] = FCustomerID;
hasData["FLngLat"] = Request["tbxLngLat"];
hasData["FMapAddress"] = Request["tbSelectedAddress"];
hasData["FType"] = Request["ddlFType"];
hasData["FRotaryPa"] = Request["ddlFRotaryPa"];
hasData["FInDiameter"] = Request["ddlFInDiameter"];
hasData["FOutDiameter"] = Request["ddlFOutDiameter"];
hasData["FEnterWNum"] = Request["tbxFEnterWNum"];
hasData["FExitWNum"] = Request["tbxFExitWNum"];
hasData["FWater"] = Request["tbxFWater"];
hasData["FWaterPa"] = Request["tbxFWaterPa"];
hasData["FWaterM3"] = Request["tbxFWaterM3"];
hasData["FNote"] = Request["tbxFNote"];
hasData["FJKLink"] = Request["tbxFJKLink"];
hasData["FUpdUser"] = GetIdentityName();
hasData["FUpdDate"] = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
BASE_SHUICHANGDal.Update(hasData);
if (FCustomerID > 0)
{
if (Request["tbxFMarkerID"].ToString() != "")
{
string[] lnglat = Request["tbxLngLat"].Split(',');
Hashtable has1 = new Hashtable();
has1["ID"] = Request["tbxFMarkerID"];
has1["FName"] = Request["tbxName"];
has1["FMapTempID"] = Request["tbxFMapTempID"];
Bll.Map_MarkerBll.UpdateMarker(has1);
Hashtable has2 = new Hashtable();
has2["FMarkerID"] = Request["tbxFMarkerID"];
has2["FMarker"] = "[{\"lng\":" + lnglat[0] + ",\"lat\":" + lnglat[1] + "}]";
Bll.Map_MarkerBll.UpdateMarkerProperty(has2);
}
}
ShowNotify("成功！");
// 关闭本窗体（触发窗体的关闭事件）
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
return(UIHelper.Result());
}
}
catch
{
ShowNotify("失败！");
}
return(UIHelper.Result());
}
private void UpdateGrid(JArray Grid1_fields, int gridIndex, int gridPageSize)
{
var Grid1 = UIHelper.Grid("Grid1");
Hashtable table = BASE_SHUICHANGDal.Search(gridIndex, gridPageSize, "a.FCreateDate", "DESC", getPowerConst("water"));
Grid1.DataSource(table["data"], Grid1_fields);
Grid1.RecordCount(Int32.Parse(table["total"].ToString()));
}
public ActionResult Index()
{
ViewBag.CoreWaterWorkNew = CheckPower("CoreWaterWorkNew");
ViewBag.CoreWaterWorkDelete = CheckPower("CoreWaterWorkDelete");
ViewBag.CoreWaterWorkEdit = CheckPower("CoreWaterWorkEdit");
Hashtable table = BASE_SHUICHANGDal.Search(0, 20, "a.FCreateDate", "DESC", getPowerConst("water"));
ViewBag.Grid1DataSource = table["data"];
ViewBag.Grid1RecordCount = Int32.Parse(table["total"].ToString());
return(View());
}
public ActionResult Grid1_PageIndexChanged(JArray Grid1_fields, int Grid1_pageIndex, int gridPageSize, string searchMessage)
{
var Grid1 = UIHelper.Grid("Grid1");
string sql = string.Empty;
if (!searchMessage.Equals(""))
{
sql = sql + " and FName like '%" + searchMessage + "%'";
}
sql = sql + getPowerConst("water");
Hashtable table = BASE_SHUICHANGDal.Search(Grid1_pageIndex, gridPageSize, "a.FCreateDate", "DESC", sql);
Grid1.DataSource(table["data"], Grid1_fields);
Grid1.RecordCount(Int32.Parse(table["total"].ToString()));
return(UIHelper.Result());
}
public ActionResult btnBasicCreate_Click()
{
try
{
if (ModelState.IsValid)
{
string guid = Guid.NewGuid().ToString();
string waterid = Guid.NewGuid().ToString();
int FCustomerID = Convert.ToInt32(Request["tbxCustomerID"]);
Hashtable hasData = new Hashtable();
hasData["id"] = waterid;
hasData["FCode"] = Request["tbxCode"];
hasData["FName"] = Request["tbxName"];
hasData["FCustomerID"] = FCustomerID;
hasData["FLngLat"] = Request["tbxLngLat"];
hasData["FMapAddress"] = Request["tbSelectedAddress"];
hasData["FType"] = Request["ddlFType"];
hasData["FRotaryPa"] = Request["ddlFRotaryPa"];
hasData["FInDiameter"] = Request["ddlFInDiameter"];
hasData["FOutDiameter"] = Request["ddlFOutDiameter"];
hasData["FEnterWNum"] = Request["tbxFEnterWNum"];
hasData["FExitWNum"] = Request["tbxFExitWNum"];
hasData["FWater"] = Request["tbxFWater"];
hasData["FWaterPa"] = Request["tbxFWaterPa"];
hasData["FWaterM3"] = Request["tbxFWaterM3"];
hasData["FNote"] = Request["tbxFNote"];
hasData["FJKLink"] = Request["tbxFJKLink"];
hasData["FCreateUser"] = GetIdentityName();
hasData["FIsDelete"] = 0;
hasData["FMarkerID"] = guid;
BASE_SHUICHANGDal.Insert(hasData);
if (FCustomerID > 0)
{
string[] lnglat = Request["tbxLngLat"].Split(',');
Hashtable has1 = new Hashtable();
Hashtable has2 = new Hashtable();
has1["ID"] = guid;
has1["FName"] = Request["tbxName"];
has1["FMapTempID"] = Request["tbxFMapTempID"];
has2["FMarkerID"] = guid;
int maxid = Convert.ToInt32(Dal.DBUtil.SelectDataTable("select isnull(max(ID),0) as maxId from Map_MarkerProperty").Rows[0]["maxId"].ToString()) + 1;
has2["FAliasName"] = "Marker" + maxid.ToString();
has2["FType"] = "4";
has2["FMarker"] = "[{\"lng\":" + lnglat[0] + ",\"lat\":" + lnglat[1] + "}]";
has2["FMID"] = waterid;
Bll.Map_MarkerBll.InsertMarker(has1);
Bll.Map_MarkerBll.InsertMarkerProperty(has2);
}
ShowNotify("成功！");
string url = Url.Action("Water_Diagram", "WaterWorks", new { type = "edit", waterId = waterid });
// 关闭本窗体（触发窗体的关闭事件）'
PageContext.RegisterStartupScript("parent.updateLabelResult('" + url + "');");
}
}
catch
{
ShowNotify("失败！");
}
return(UIHelper.Result());
}
