public string GetAdminPurviewInfo(string iAdminID)
{
if (string.IsNullOrEmpty(iAdminID))
{
return(WebExport.ExportSuccess("iAdminID!"));
}
DataTable DT;
string ErrInfo = "";
bool IsOk = APP.SQLServer_PingTai.GetDataTable("select * from V_P_Admin where iAdminID=" + iAdminID.Trim(), out DT, out ErrInfo);
//执行完成返回
if (IsOk)
{
if (DT.Rows.Count > 0)
{
string Sql = "SELECT distinct [iFunID] ,[cFunName],iFunFatherID,cFunMenuOrder FROM [V_P_FunPurview] where (iPurviewID =" + iAdminID.Trim() + " and iPurviewType=1) or (iPurviewID =" + DT.Rows[0]["iRoleID"].ToString() + " and iPurviewType=2) or (iPurviewID =" + DT.Rows[0]["iDeptID"].ToString() + " and iPurviewType=3)";
DataTable DT2;
IsOk = APP.SQLServer_PingTai.GetDataTable(Sql, out DT2, out ErrInfo);
if (IsOk)
{
StringBuilder listStr = new StringBuilder();
bool[] arrShowLine = new bool[10];
listStr.Append("[{\"id\":0,\"text\":\"APP系统\",\"children\":");
listStr.Append(getChidrenTree(DT2, "1000016", 0, false, "iFunFatherID", "cFunMenuOrder", " asc", arrShowLine));
listStr.Append("}]");
return(listStr.ToString());
}
else
{
return(WebExport.ExportErrMsg("权限获取中用户权限信息失败!" + ErrInfo));
}
}
else
{
return(WebExport.ExportErrMsg("权限获取中没有查询到用户信息!"));
}
}
else
{
return(WebExport.ExportErrMsg("权限获取中用户信息失败!"));
}
}
public string GetAdminInfo(string iAdminID)
{
if (string.IsNullOrEmpty(iAdminID))
{
return(WebExport.ExportSuccess("iAdminID!"));
}
DataTable DT;
string ErrInfo = "";
bool IsOk = APP.SQLServer_PingTai.GetDataTable("select * from V_P_Admin where iAdminID=" + iAdminID.Trim(), out DT, out ErrInfo);
//执行完成返回
if (IsOk)
{
return(WebExport.ExportSuccess(DT));
}
else
{
return(WebExport.ExportSuccess("获取用户信息失败!"));
}
}
public string SearchForPOI(string poi_v)
{
if (string.IsNullOrEmpty(poi_v))
{
return(WebExport.ExportSuccess("查询值不能为空!"));
}
string SQL = "select top 30 * from POI where 名称 like '%" + poi_v + "%'";
DataTable DT;
string ErrInfo = "";
bool IsOk = APP.SQLServer_BaseGisDB_Helper.GetDataTable(SQL, out DT, out ErrInfo);
//执行完成返回
if (IsOk)
{
return(WebExport.ExportSuccess(DT));
}
else
{
return(WebExport.ExportSuccess("查询失败!"));
}
}
private void GetPOI()
{
string mc = "";
CheckRequery.check("poi_v", out mc);
string SQL = "select * from POI where 名称 like '%" + mc + "%'";
DataTable DT;
string ErrInfo = "";
bool IsOk = APP.SQLServer_BaseGisDB_Helper.GetDataTable(SQL, out DT, out ErrInfo);
//执行完成返回
if (IsOk)
{
Context.Response.Write(WebExport.ExportSuccess("查询成功!"));
return;
}
else
{
Context.Response.Write(WebExport.ExportSuccess("查询失败!"));
return;
}
}
public override void Ashx_Load()
{
Context.Response.ContentType = "text/plain";
Context.Response.AddHeader("Access-Control-Allow-Origin", "*");
Context.Response.AddHeader("Access-Control-Allow-Methods", "POST");
Context.Response.AddHeader("Access-Control-Max-Ag", "1000");
string actionType = "";
//string retStr = "";//返回值
string ErrInfo = string.Empty;
string sqlStr = "";
CheckRequery.checkNotNull("actionType", "类型不能为空！", out actionType);
string id = "";
string personName = "";
string personTelphone = "";
string deptID = "";
string personPassword = "";
string deptName = "";
string roleId = "";
CheckRequery.check("deptID", out deptID);
CheckRequery.checkNotNull("id", "不能为空！", out id);
CheckRequery.check("personName", out personName);
CheckRequery.check("personTelphone", out personTelphone);
CheckRequery.check("roleId", out roleId);
switch (actionType)
{
//添加一个人员
case "ADD":
CheckRequery.check("personPassword", out personPassword);
CheckRequery.check("deptName", out deptName);
sqlStr = "INSERT INTO L_Person( PersonName, Telephone, DepartmentId, PersonId, PassWord,iRoleID,DeleteStatus )VALUES ( '" + personName + "','" + personTelphone + "','" + deptID + "','" + id + "','" + personPassword + "','" + roleId + "','0')";
int m = APP.SQLServer_Helper.UpDate(sqlStr, out ErrInfo);
if (!string.IsNullOrEmpty(ErrInfo))
{
Context.Response.Write(WebExport.ExportErrMsg("添加失败，请检查数据!"));
}
if (m > 0)
{
Context.Response.Write(WebExport.ExportSuccess("添加成功!"));
}
break;
//删除一个人员
case "DEL":
//sqlStr = "delete from L_Person where PersonId = " + id + "";
sqlStr = " UPDATE dbo.L_Person SET DeleteStatus='1' WHERE PersonId='" + id + "'";
int d = APP.SQLServer_Helper.UpDate(sqlStr, out ErrInfo);
if (!string.IsNullOrEmpty(ErrInfo))
{
Context.Response.Write(WebExport.ExportErrMsg("删除失败，请检查数据!"));
}
if (d > 0)
{
Context.Response.Write(WebExport.ExportSuccess("删除成功!"));
}
break;
//更新人员
case "MODIFY":
sqlStr = "update L_Person set PersonName = '" + personName + "',Telephone='" + personTelphone + "',DepartmentId='" + deptID + "',iRoleID = '" + roleId + "' where PersonId=" + id + "";
int update1 = APP.SQLServer_Helper.UpDate(sqlStr, out ErrInfo);
if (!string.IsNullOrEmpty(ErrInfo))
{
Context.Response.Write(WebExport.ExportErrMsg("修改失败，请检查数据!"));
}
if (update1 > 0)
{
Context.Response.Write(WebExport.ExportSuccess("修改成功!"));
}
break;
default:
break;
}
//Context.Response.Write(retStr);
}
public string SearchForSmID(string SmID, string LayerName)
{
if (string.IsNullOrEmpty(SmID))
{
return(WebExport.ExportSuccess("SmID不能为空!"));
}
if (string.IsNullOrEmpty(LayerName))
{
return(WebExport.ExportSuccess("LayerName!"));
}
LayerName = LayerName.Split('@')[0];
string SQL = "";
switch (LayerName)
{
case "普通给水管线":
SQL = @"Select SmID,
管线编号,
道路名称,
管径,
管长,
管道材质,
接口方式,
起点点号,
终止点号,
敷设年代,
竣工日期,
施工单位,
施工单位,
起点埋深,
终点埋深,
平均埋深,
起点高程,
终点高程 From " + LayerName + " where SmID=" + SmID;
break;
case "阀门":
SQL = @"Select SmID
物探点号
阀门编号
口径,
井盖形状,
井盖尺寸,
井盖材质,
井壁结构,
施工单位联系方式,
施工单位,
埋深,
高程,
开关状态,
开关类型,
材质,
埋设方式,
所在道路,
道路名称,
安装日期,
竣工日期 From " + LayerName + " where SmID=" + SmID;
break;
case "消防栓":
SQL = @"Select SmID,
管径,
管件口径,
井盖形状,
井盖尺寸,
井盖材质,
井壁结构,
施工单位联系方式,
施工单位,
安装日期,
竣工日期 From " + LayerName + " where SmID=" + SmID;
break;
case "阀门井":
SQL = @"Select SmID,
编号,
井盖形状,
井盖尺寸,
井盖材质,
井壁结构,
施工单位,
施工单位联系方式 From " + LayerName + " where SmID=" + SmID;
break;
case "排气阀":
SQL = @"Select SmID,
编号,
施工单位,
道路名称 From " + LayerName + " where SmID=" + SmID;
break;
case "直通井":
SQL = @"Select SmID,
编号,
井盖形状,
井盖尺寸,
井盖材质,
井壁结构,
施工单位,
施工单位联系方式 From " + LayerName + " where SmID=" + SmID;
break;
case "四通井":
SQL = @"Select SmID,
编号,
井盖形状,
井盖尺寸,
井盖材质,
井壁结构,
施工单位,
施工单位联系方式 From " + LayerName + " where SmID=" + SmID;
break;
default:
SQL = @"Select SmID,
编号,
井盖形状,
井盖尺寸,
井盖材质,
井壁结构,
施工单位,
施工单位联系方式 From " + LayerName + " where SmID=" + SmID;
break;
}
DataTable DT;
string ErrInfo = "";
bool IsOk = APP.SQLServer_BaseGisDB_Helper.GetDataTable(SQL, out DT, out ErrInfo);
//执行完成返回
if (IsOk)
{
return(WebExport.ExportSuccess(DT));
}
else
{
return(WebExport.ExportSuccess("查询失败!"));
}
}
private void ForSmID()
{
string SmID, LayerName;
//检查 and 数据赋值
CheckRequery.checkNotNull("LayerName", "设施不能为空！", out LayerName);
CheckRequery.checkNotNull("SmID", "SmID不能为空！", out SmID);
LayerName = LayerName.Split('@')[0];
string SQL = "";
switch (LayerName)
{
case "普通给水管线":
SQL = @"Select SmID,
管线编号,
道路名称,
管径,
管长,
管道材质,
接口方式,
起点点号,
终止点号,
敷设年代,
竣工日期,
施工单位,
施工单位,
起点埋深,
终点埋深,
平均埋深,
起点高程,
终点高程 From " + LayerName + " where SmID=" + SmID;
break;
case "阀门":
SQL = @"Select SmID
物探点号
阀门编号
口径,
井盖形状,
井盖尺寸,
井盖材质,
井壁结构,
施工单位联系方式,
施工单位,
埋深,
高程,
开关状态,
开关类型,
材质,
埋设方式,
所在道路,
道路名称,
安装日期,
竣工日期 From " + LayerName + " where SmID=" + SmID;
break;
case "消防栓":
SQL = @"Select SmID,
管径,
管件口径,
井盖形状,
井盖尺寸,
井盖材质,
井壁结构,
施工单位联系方式,
施工单位,
安装日期,
竣工日期 From " + LayerName + " where SmID=" + SmID;
break;
case "阀门井":
SQL = @"Select SmID,
编号,
井盖形状,
井盖尺寸,
井盖材质,
井壁结构,
施工单位,
施工单位联系方式 From " + LayerName + " where SmID=" + SmID;
break;
case "排气阀":
SQL = @"Select SmID,
编号,
施工单位,
道路名称 From " + LayerName + " where SmID=" + SmID;
break;
case "直通井":
SQL = @"Select SmID,
编号,
井盖形状,
井盖尺寸,
井盖材质,
井壁结构,
施工单位,
施工单位联系方式 From " + LayerName + " where SmID=" + SmID;
break;
case "四通井":
SQL = @"Select SmID,
编号,
井盖形状,
井盖尺寸,
井盖材质,
井壁结构,
施工单位,
施工单位联系方式 From " + LayerName + " where SmID=" + SmID;
break;
default:
SQL = @"Select SmID,
编号,
井盖形状,
井盖尺寸,
井盖材质,
井壁结构,
施工单位,
施工单位联系方式 From " + LayerName + " where SmID=" + SmID;
break;
}
DataTable DT;
string ErrInfo = "";
bool IsOk = APP.SQLServer_BaseGisDB_Helper.GetDataTable(SQL, out DT, out ErrInfo);
//执行完成返回
if (IsOk)
{
Context.Response.Write(WebExport.ExportSuccess("查询成功!"));
return;
}
else
{
Context.Response.Write(WebExport.ExportSuccess("查询失败!"));
return;
}
}
