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_YUZHIBENGZHANDal.DeleteList(hasData);
Bll.Map_MarkerBll.DeleteMarker(11, 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("YuZhiPump");
Hashtable table = BASE_YUZHIBENGZHANDal.SearchLL(gridIndex, gridPageSize, "a.FCreateDate", "DESC", sql);
Grid1.DataSource(table["data"], gridFields);
Grid1.RecordCount(Int32.Parse(table["total"].ToString()));
return(UIHelper.Result());
}
private void UpdateGrid(JArray Grid1_fields, int gridIndex, int gridPageSize)
{
var Grid1 = UIHelper.Grid("Grid1");
Hashtable table = BASE_YUZHIBENGZHANDal.SearchLL(gridIndex, gridPageSize, "a.FCreateDate", "DESC", getPowerConst("YuZhiPump"));
Grid1.DataSource(table["data"], Grid1_fields);
Grid1.RecordCount(Int32.Parse(table["total"].ToString()));
}
public ActionResult Index()
{
ViewBag.CoreYuZhiPumpNew = CheckPower("CoreYuZhiPumpNew");
ViewBag.CoreYuZhiPumpDelete = CheckPower("CoreYuZhiPumpDelete");
ViewBag.CoreYuZhiPumpEdit = CheckPower("CoreYuZhiPumpEdit");
Hashtable table = BASE_YUZHIBENGZHANDal.SearchLL(0, 20, "a.FCreateDate", "DESC", getPowerConst("YuZhiPump"));
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("YuZhiPump");
Hashtable table = BASE_YUZHIBENGZHANDal.SearchLL(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 btnBasicEdit_Click()
{
try
{
if (ModelState.IsValid)
{
if (BASE_YUZHIBENGZHANDal.Exist(" and FDTUCode='" + Request["tbSelectedDTU"] + "' and FDTUCode<>'" + Request["tbOldDTU"] + "'").Rows.Count == 0)
{
int FCustomerID = Convert.ToInt32(Request["tbxCustomerID"]);
Hashtable hasData = new Hashtable();
hasData["id"] = Request["tbxID"];
hasData["FDTUCode"] = Request["tbSelectedDTU"];
hasData["FName"] = Request["tbxName"];
hasData["RunPumpNum"] = Request["ddlRunPumpNum"];
hasData["Auxiliarypumpcount"] = Request["ddlAuxiliarypumpcount"];
hasData["DrainPumpNum"] = Request["ddlDrainPumpNum"];
hasData["FTankVolume"] = Request["txt_sxrj"];//水箱容积
hasData["FCustomerID"] = FCustomerID;
hasData["FLngLat"] = Request["tbxLngLat"];
hasData["FMapAddress"] = Request["tbSelectedAddress"];
hasData["FWell"] = Request["hidFWell"];
hasData["FPipeline"] = Request["hidFPipeline"];
hasData["FEnterValve"] = Request["hidFEnterValve"];
hasData["FExitValve"] = Request["hidFExitValve"];
hasData["FBrand"] = Request["tbxFBrand"];
hasData["FMaterial"] = Request["ddlFMaterial"];
hasData["FCaliber"] = Request["ddlFCaliber"];
hasData["FEQuiType"] = Request["ddlFEQuiType"];
hasData["FInstallMode"] = Request["ddlFInstallMode"];
hasData["FCommunicationMode"] = Request["ddlFCommunicationMode"];
hasData["FReadMeterMode"] = Request["ddlFReadMeterMode"];
hasData["FBuriedMode"] = Request["ddlFBuriedMode"];
hasData["FEQuiState"] = Request["ddlFEQuiState"];
hasData["FGroundHeigh"] = Request["tbxFGroundHeigh"];
hasData["FNote"] = Request["tbxFNote"];
hasData["FBYCycle"] = Request["tbxFBYCycle"];
hasData["FGHCycle"] = Request["tbxFGHCycle"];
hasData["FSchemeID"] = Request["tbxFSchemeID"];
hasData["FUpdUser"] = GetIdentityName();
hasData["FUpdDate"] = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
BASE_YUZHIBENGZHANDal.Update(hasData);
Hashtable hasData1 = new Hashtable();
hasData1["FDTUCode"] = Request["tbSelectedDTU"];
hasData1["BASEID"] = Request["tbxID"];
DATA_YUZHIBENGZHAN_MAINDal.Update(hasData1);
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());
}
else
{
ShowNotify("流量编号重复，请更换！");
}
}
}
catch
{
ShowNotify("失败！");
}
return(UIHelper.Result());
}
public ActionResult btnBasicCreate_Click()
{
try
{
if (ModelState.IsValid)
{
if (BASE_YUZHIBENGZHANDal.Exist(" and FDTUCode='" + Request["tbSelectedDTU"] + "'").Rows.Count == 0)
{
string guid = Guid.NewGuid().ToString();
string YuZhiPumpid = Guid.NewGuid().ToString();
int FCustomerID = Convert.ToInt32(Request["tbxCustomerID"]);
Hashtable hasData = new Hashtable();
hasData["id"] = YuZhiPumpid;
hasData["FDTUCode"] = Request["tbSelectedDTU"];
hasData["FName"] = Request["tbxName"];
hasData["RunPumpNum"] = Request["ddlRunPumpNum"];
hasData["Auxiliarypumpcount"] = Request["ddlAuxiliarypumpcount"];
hasData["DrainPumpNum"] = Request["ddlDrainPumpNum"];
hasData["FTankVolume"] = Request["txt_sxrj"];//水箱容积
hasData["FCustomerID"] = FCustomerID;
hasData["FLngLat"] = Request["tbxLngLat"];
hasData["FMapAddress"] = Request["tbSelectedAddress"];
hasData["FWell"] = Request["hidFWell"];
hasData["FPipeline"] = Request["hidFPipeline"];
hasData["FEnterValve"] = Request["hidFEnterValve"];
hasData["FExitValve"] = Request["hidFExitValve"];
hasData["FBrand"] = Request["tbxFBrand"];
hasData["FMaterial"] = Request["ddlFMaterial"];
hasData["FCaliber"] = Request["ddlFCaliber"];
hasData["FEQuiType"] = Request["ddlFEQuiType"];
hasData["FInstallMode"] = Request["ddlFInstallMode"];
hasData["FCommunicationMode"] = Request["ddlFCommunicationMode"];
hasData["FReadMeterMode"] = Request["ddlFReadMeterMode"];
hasData["FBuriedMode"] = Request["ddlFBuriedMode"];
hasData["FEQuiState"] = Request["ddlFEQuiState"];
hasData["FGroundHeigh"] = Request["tbxFGroundHeigh"];
hasData["FBYCycle"] = Request["tbxFBYCycle"];
hasData["FGHCycle"] = Request["tbxFGHCycle"];
hasData["FNote"] = Request["tbxFNote"];
hasData["FSchemeID"] = Request["tbxFSchemeID"];
hasData["FCreateUser"] = GetIdentityName();
hasData["FIsDelete"] = 0;
hasData["FMarkerID"] = guid;
BASE_YUZHIBENGZHANDal.Insert(hasData);
Hashtable hasData1 = new Hashtable();
hasData1["id"] = Guid.NewGuid();
hasData1["FDTUCode"] = Request["tbSelectedDTU"];
hasData1["BASEID"] = YuZhiPumpid;
DATA_YUZHIBENGZHAN_MAINDal.Insert(hasData1);
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"] = "11";
has2["FMarker"] = "[{\"lng\":" + lnglat[0] + ",\"lat\":" + lnglat[1] + "}]";
has2["FMID"] = YuZhiPumpid;
Bll.Map_MarkerBll.InsertMarker(has1);
Bll.Map_MarkerBll.InsertMarkerProperty(has2);
Bll.Data_YaLiBll.SearchInsertAlarm(" and FMarkerType=11", guid);
}
ShowNotify("成功！");
string url = Url.Action("YuZhiPump_Diagram", "BASE_YUZHIBENGZHAN", new { type = "edit", YuZhiPumpId = YuZhiPumpid });
// 关闭本窗体（触发窗体的关闭事件）'
PageContext.RegisterStartupScript("parent.updateLabelResult('" + url + "');");
}
else
{
ShowNotify("流量编号重复，请更换！");
}
}
}
catch
{
ShowNotify("失败！");
}
return(UIHelper.Result());
}
