public string ImageSelect(string TableName, int id)
{
string result = "";
try
{
string ImageSelect = Data_dal.ImageSelect(TableName, id);
string desc = Data_dal.GetDescription(TableName, id);
if (!string.IsNullOrEmpty(ImageSelect))
{
ImageSelect = "\"" + ImageSelect + "\"";
TableName = "\"" + TableName + "\"";
result = @"[{""image"":" + ImageSelect + ",\"TableName\":" + TableName + ",\"id\":" + id + ",\"desc\":'" + desc + "'}]";
}
else
{
result = @"[{}]";
}
}
catch (Exception)
{
System.Web.HttpContext.Current.Response.Write("<script>alert(" + err + ")</script>");
}
return(result);
}
public string GetPatroList_Dept()
{
string result = "";
try
{
result = Data_dal.GetPatroList_Dept();
}
catch
{
}
return(result);
}
public string GetPersonList_ByAminid(string iadminid, string deptid)
{
string result = "";
try
{
result = Data_dal.GetPatroPersonList_ByAminid(iadminid, deptid);
}
catch
{
}
return(result);
}
public string getPatroPersonListByAminid(string iadmin, string starttime, string endtime)
{
string result = "";
try
{
result = Data_dal.getPatroPersonListByAminid(iadmin, starttime, endtime);
}
catch
{
}
return(result);
}
public string UpdatePassword(string iadminid, string oldpassword, string newpassword)
{
string result = "";
try
{
result = Data_dal.UpdatePassword(iadminid, oldpassword, newpassword);
}
catch
{
}
return(result);
}
public string BindTracker(int userid, string trackerid)
{
string result = "";
try
{
result = Data_dal.BindTracker(userid, trackerid);
}
catch
{
}
return(result);
}
public string bindLabelId(string labelId, string equipmentName, int equipmentSmid, float coordinateX, float coordinateY, int adminId)
{
string result = "";
try
{
result = Data_dal.bindLabelId(labelId, equipmentName, equipmentSmid, coordinateX, coordinateY, adminId);
}
catch
{
}
return(result);
}
public string equipmentInWell(string layerName, int smid)
{
string result = "";
try
{
result = Data_dal.equipmentInWell(layerName, smid);
}
catch
{
}
return(result);
}
public string unbindLabelId(string labelId, int adminId)
{
string result = "";
try
{
result = Data_dal.unbindLabelId(labelId, adminId);
}
catch
{
}
return(result);
}
public string upNFCReport(string labelId, int adminId, string equipmentName, int equipmentSmid, string reportContent, string editDateTime)
{
string result = "";
try
{
result = Data_dal.upNFCReport(labelId, adminId, equipmentName, equipmentSmid, reportContent, editDateTime);
}
catch
{
}
return(result);
}
public string patrolReportForm(int adminId, string startDate, string endDate, int formType)
{
string result = "";
try
{
result = Data_dal.patrolReportForm_FromNFCReport(adminId, startDate, endDate, formType);
}
catch
{
}
return(result);
}
public string reportFormDetails(int adminId, string startDate, string endDate, int formType, string name, int pageNumber)
{
string result = "";
try
{
result = Data_dal.reportFormDetails(adminId, startDate, endDate, formType, name, pageNumber);
}
catch
{
}
return(result);
}
public string UPCoordinatePositionNew(string x, string y, string uptime, string name, string zaixian, string dignweiStatus, string yichang)
{
string result = "";
if (Data_dal.UPCoordinatePosition(x, y, uptime, name, zaixian, dignweiStatus, yichang) > 0)
{
result = @"[{""result"":true}]";
}
else
{
result = @"[{""result"":false}]";
}
return(result);
}
public string UPCoordinatePosition(string x, string y, string uptime, string name, string zaixian)
{
string result = "";
if (Data_dal.UPCoordinatePosition(x, y, uptime, name, zaixian) > 0)
{
result = @"[{""result"":true}]";
}
else
{
result = @"[{""result"":false}]";
}
return(result);
}
/// <summary>
/// 计划完成状态
/// </summary>
public string Update_ZT(int id)
{
string result = "";
if (Data_dal.Update_Set_ZT(id) > 0)
{
result = @"[{""result"":true}]";
}
else
{
result = @"[{""result"":false}]";
}
return(result);
}
public string LoadLabels()
{
string result = "";
try
{
result = Data_dal.LoadLabels();
}
catch
{
}
return(result);
//return null;
}
public string QianDao(string Lwr_PersonId, string Lwr_Date, string Lwr_StartTime, string Lwr_EndTime, string Lwr_Hour, string Lwr_BeiZhu, string Lwr_PersonStatus, string Lwr_UpTime, string Lwr_GpsStatus, string Lwr_MobileStatus, string Lwr_Power)
{
string result = "";
try
{
if (Data_dal.Insert_QianDao(ref err, Lwr_PersonId, Lwr_Date, Lwr_StartTime, Lwr_EndTime, Lwr_Hour, Lwr_BeiZhu, Lwr_PersonStatus, Lwr_UpTime, Lwr_GpsStatus, Lwr_MobileStatus, Lwr_Power) > 0)
{
result = @"[{""result"":成功}]";
}
else
{
result = @"[{""result"":失败}]";
}
}
catch (Exception)
{
System.Web.HttpContext.Current.Response.Write("<script>alert(" + err + ")</script>");
}
return(result);
}
/// <summary>
/// HiddenTroubleReport_Update 隐患上报方法
/// </summary>
///
public string HiddenTroubleReport_Insert(int shebei_type, int yinhuan_type, string address, string miaoshu, string faxiantime, string uptime, string x, string y, int peopleid, string sheshi, string imagegeshi, string base64, int rwID, int pianID, int luxianID, int ishidden)
{
string result = "";
try
{
if (Data_dal.Insert_Hidden(ref err, shebei_type, yinhuan_type, address, miaoshu, faxiantime, uptime, x, y, peopleid, sheshi, imagegeshi, base64, rwID, pianID, luxianID, ishidden) > 0)
{
result = @"[{""result"":成功}]";
}
else
{
result = @"[{""result"":失败}]";
}
}
catch (Exception)
{
System.Web.HttpContext.Current.Response.Write("<script>alert(" + err + ")</script>");
}
return(result);
}
public string ImageRemove(string TableName, int id, string ImageName)
{
string result = "";
try
{
if (Data_dal.ImageRemove(TableName, id, ImageName) > 0)
{
result = @"[{""result"":""成功""}]";
}
else
{
result = @"[{""result"":""失败""}]";
}
}
catch (Exception)
{
System.Web.HttpContext.Current.Response.Write("<script>alert(" + err + ")</script>");
}
return(result);
}
/// <summary>
///上传表井图片
/// </summary>
public string InsertIntoWellImage(string base64Photo, int id, string TableName, string desc)
{
string result = "";
try
{
if (base64Photo != "")//有图片上传图片后更新描述
{
if (Data_dal.ReceiveWellImage(base64Photo, id, TableName) > 0)
{
//更新设施描述
Data_dal.UpdateDescription(TableName, id, desc);
result = @"[{""result"":成功}]";
}
else
{
result = @"[{""result"":失败}]";
}
}
else//无图片直接更新描述
{
//更新设施描述
int i = Data_dal.UpdateDescription(TableName, id, desc);
if (i > 0)
{
result = @"[{""result"":成功}]";
}
else
{
result = @"[{""result"":失败}]";
}
}
}
catch (Exception)
{
System.Web.HttpContext.Current.Response.Write("<script>alert(" + err + ")</script>");
}
return(result);
}
public string Get_POI(string str)
{
return(Data_dal.Get_POI(str));
}
/// <summary>
/// id:用户ID,dateStr 月份如2016-12 返回一个月的数据
/// </summary>
public string Get_WorkRecord(int id, string dateStr)
{
return(Data_dal.Get_WorkRecord(id, dateStr));
}
public string Get_Notice()
{
return(Data_dal.Get_Notice());
}
/// <summary>
///巡查项目所有分类
/// </summary>
public string Get_Line_Item_All()
{
return(Data_dal.Get_Line_Item_All());
}
/// <summary>
///巡查项目子分类
/// </summary>
public string Get_Line_ChildItem(int parentId)
{
return(Data_dal.Get_Line_ChildItem(parentId));
}
/// <summary>
///设备类型下拉框G_Repair_type
/// </summary>
public string Get_G_Repair_type()
{
return(Data_dal.Get_G_Repair_type());
}
/// <summary>
///获取服务器时间
/// </summary>
public string Get_ServerTime()
{
return(Data_dal.Get_ServerTime());
}
public string User_Check(string name, string pwd, string smid)
{
return(Data_dal.User_Check_(name, pwd, smid));
}
public string Get_Road(string str)
{
return(Data_dal.Get_Road(str));
}
public string Get_Select_Hidden(string ksdate, string jsdate, int nameid)
{
return(Data_dal.Get_Select_Hidden(ksdate, jsdate, nameid));
}
