public void query()
{
String cWX_ID = StringEx.getString(request["WX_ID"]);
ActiveResult vret = ActiveResult.Valid(AppConfig.FAILURE);
String cWhereParm = " (WX_ID ='" + cWX_ID + "') ";
String cOrderBy = "ORDER BY ID DESC";
DBResult dbret = dao.Query(cWhereParm, cOrderBy, iPageNo, iPageSize);
DataTable dtRows = dbret.dtrows;
int iRowsCount = dbret.ROW_COUNT;
vret = ActiveResult.Query(dtRows);
vret.total = iRowsCount;
response.Write(vret.toJSONString());
}
/// <summary>
///
/// </summary>
public void export_query()
{
String cORG_ID = Config.GetAppSettings("ORG_ID");
ActiveResult vret = ActiveResult.Valid(AppConfig.FAILURE);
String cWhereParm = " (ORG_ID ='" + cORG_ID + "') AND (SD_RESULT=1) ";
String cOrderBy = "ORDER BY ID ASC";
DBResult dbret = dao.QueryResult(cWhereParm, cOrderBy, iPageNo, iPageSize);
DataTable dtRows = dbret.dtrows;
int iRowsCount = dbret.ROW_COUNT;
vret = ActiveResult.Query(dtRows);
vret.total = iRowsCount;
response.Write(vret.toJSONString());
}
public void find()
{
ActiveResult vret = new ActiveResult();
String cORG_ID = StringEx.getString(request["ORG_ID"]);
if (cORG_ID.Length == 0)
{
vret = ActiveResult.Valid("错误，参数ORG_ID未正常传递！");
}
else
{
S_ORG_INF_WX_CONFIG vo = dao.FindOne(cORG_ID);
vret = ActiveResult.returnObject(vo);
}
response.Write(vret.toJSONString());
}
public void del_item()
{
ActiveResult vret = ActiveResult.Valid(AppConfig.FAILURE);
String cUSER_COUNT = StringEx.getString(request["dbkey"]);
if (String.IsNullOrEmpty(cUSER_COUNT))
{
vret = ActiveResult.Valid("编码不能为空！");
}
else
{
int iCode = dao.del_item(cUSER_COUNT);
vret = ActiveResult.Valid(iCode > 0);
}
response.Write(vret.toJSONString());
}
public void find()
{
ActiveResult vret = ActiveResult.Valid(AppConfig.FAILURE);
String cKeyID = StringEx.getString(request["ID"]);
if (String.IsNullOrEmpty(cKeyID))
{
vret = ActiveResult.Valid("单位编码参数不能为空！");
}
else
{
XT_JB vInfo = dao.FindOne(cKeyID);
vret = ActiveResult.returnObject(vInfo);
}
response.Write(vret.toJSONString());
}
public void query()
{
ActiveResult vret = new ActiveResult();
String cMaxID = StringEx.getString(request["MAXID"]);
String cORG_ID = StringEx.getString(request["ORG_ID"]);
String cCOUNTY = StringEx.getString(request["COUNTY"]);
String C_VILLAGE = StringEx.getString(request["VILLAGE"]);
String cADDR = StringEx.getString(request["ADDR"]);
String C_PAGE_SIZE = StringEx.getString(request["PAGE_SIZE"]);
int iPage_Size = StringEx.getInt(C_PAGE_SIZE);
DBResult rs = dao.search(cORG_ID, cMaxID, cCOUNTY, cADDR, C_VILLAGE, iPage_Size);
vret = ActiveResult.Query(rs.dtrows);
vret.total = rs.ROW_COUNT;
response.Write(vret.toJSONString());
}
public void find()
{
ActiveResult vret = ActiveResult.Valid(AppConfig.FAILURE);
String cKEY_ID = StringEx.getString(request["RECEIVE_GUID"]);
if (String.IsNullOrEmpty(cKEY_ID))
{
vret = ActiveResult.Valid("错误，RECEIVE_GUID参数为空！");
}
else
{
XT_RECEIVE_SMS vInfo = dao.FindOne(cKEY_ID);
vret = ActiveResult.returnObject(vInfo);
}
response.Write(vret.toJSONString());
}
public void find()
{
ActiveResult vret = ActiveResult.Valid(AppConfig.FAILURE);
String cORG_ID = StringEx.getString(request["DICT_ID"]);
if (String.IsNullOrEmpty(cORG_ID))
{
vret = ActiveResult.Valid("字典编码不能为空！");
}
else
{
S_PAGE_DICT vInfo = dao.FindOne(cORG_ID);
vret = ActiveResult.returnObject(vInfo);
}
response.Write(vret.toJSONString());
}
public void del_item()
{
ActiveResult vret = ActiveResult.Valid(AppConfig.FAILURE);
String cORG_ID = StringEx.getString(request["ORG_ID"]);
if (String.IsNullOrEmpty(cORG_ID))
{
vret = ActiveResult.Valid("单位编码参数不能为空！");
}
else
{
int iCode = dao.del_item(cORG_ID);
vret = ActiveResult.Valid(iCode > 0);
}
response.Write(vret.toJSONString());
}
public void save()
{
ActiveResult vret = ActiveResult.Valid(AppConfig.FAILURE);
String cID = StringEx.getString(request["DEVICE_ID"]);
String cOFFSET_P = StringEx.getString(request["OFFSET_P"]);
String cOFFSET_T = StringEx.getString(request["OFFSET_T"]);
String cOFFSET_X = StringEx.getString(request["OFFSET_X"]);
String cOFFSET_H = StringEx.getString(request["OFFSET_H"]);
String cX = StringEx.getString(request["X"]);
String cY = StringEx.getString(request["Y"]);
int iCode = DbManager.ExecSQL(" UPDATE XT_CAMERA_CONFIG SET OFFSET_P = '" + cOFFSET_P + "',OFFSET_T = '" + cOFFSET_T + "',OFFSET_X='" + cOFFSET_X + "',OFFSET_H='" + cOFFSET_H + "',X='" + cX + "',Y='" + cY + "'");
vret = ActiveResult.Valid(iCode > 0);
response.Write(vret.toJSONString());
}
public void query()
{
String cORG_ID = StringEx.getString(request["ORG_ID"]);
int iOrgType = AppManager.getAreaType(cORG_ID);
ActiveResult vret = ActiveResult.Valid(AppConfig.FAILURE);
String cWhereParm = "ORG_TYPE= '" + iOrgType + "'";
String cOrderBy = "ORDER BY ROLE_ID ASC";
DBResult dbret = dao.Query(cWhereParm, cOrderBy, iPageNo, iPageSize);
DataTable dtRows = dbret.dtrows;
int iRowsCount = dbret.ROW_COUNT;
vret = ActiveResult.Query(dtRows);
vret.total = iRowsCount;
response.Write(vret.toJSONString());
}
/// <summary>
/// 查询数据语句
/// </summary>
public void GetStrValue()
{
ActiveResult vret = ActiveResult.Valid(AppConfig.FAILURE);
String sql = StringEx.getString(request["SQL"]);
log4net.WriteLogFile("SQL:" + sql, LogType.DEBUG);
if (String.IsNullOrWhiteSpace(sql))
{
vret = ActiveResult.Valid("SQL语句不能为空！");
}
else
{
String cStr = DbManager.GetStrValue(sql);
vret = ActiveResult.returnObject(cStr);
}
response.Write(vret.toJSONString());
}
public void save()
{
ActiveResult vret = ActiveResult.Valid(AppConfig.SUCCESS);
String cKeyID = StringEx.getString(request["ID"]);
String cORG_ID = StringEx.getString(request["org_id"]);
String cAREA_ID = StringEx.getString(request["AREA_ID"]);
cAREA_ID = cAREA_ID.Replace("00", "");
S_ORG_INF vo = new S_ORG_INF();
vo = (S_ORG_INF)RequestUtil.readFromRequest(request, vo);
if (String.IsNullOrEmpty(cORG_ID))
{
vret = ActiveResult.Valid("单位编码不能为空！");
}
else if (!cORG_ID.StartsWith(cAREA_ID))
{
vret = ActiveResult.Valid("单位编码格式错误！");
}
else if (String.IsNullOrEmpty(vo.org_name))
{
vret = ActiveResult.Valid("单位简称不能为空！");
}
else if (String.IsNullOrEmpty(vo.org_full_name))
{
vret = ActiveResult.Valid("单位全称不能为空！");
}
String cPloygn = vo.ploygn;
if (!String.IsNullOrEmpty(cPloygn))
{
String cWebRoot = request.MapPath("/");
String cFileName = cWebRoot + @"static\area_range\" + cORG_ID + ".js";
FileLib.WriteTextFile(cFileName, cPloygn);
}
vo.org_type = cORG_ID.Length;
if (vret.result == AppConfig.SUCCESS)
{
int iCode = dao.save(vo, cKeyID);
vret = ActiveResult.Valid(iCode);
}
response.Write(vret.toJSONString());
}
public void clear_alarm()
{
ActiveResult vret = ActiveResult.Valid(AppConfig.SUCCESS);
String cREC_ID = StringEx.getString(request["ID"]);
if (String.IsNullOrWhiteSpace(cREC_ID))
{
vret = ActiveResult.Valid("参数传递错误！");
}
else
{
int iCode = DbManager.ExecSQL(" update XT_IMG_REC SET ALARM_CHECKED =2 WHERE REC_ID = '" + cREC_ID + "' ");
vret = ActiveResult.Valid(iCode);
}
response.Write(vret.toJSONString());
}
public void query_alarm()
{
String cORG_ID = StringEx.getString(request["ORG_ID"]);
String cCAMERA_NAME = StringEx.getString(request["CAMERA_NAME"]);
String cALARM_CHECKED = StringEx.getString(request["ALARM_CHECKED"]);
String cALARM_FLAG = StringEx.getString(request["ALARM_FLAG"]);
ActiveResult vret = ActiveResult.Valid(AppConfig.FAILURE);
String cWhereParm = " EXISTS( SELECT 1 FROM XT_CAMERA X WHERE X.ORG_ID='" + cORG_ID + "' AND X.DEVICE_ID=CAMERA_ID AND ALARM_FLAG = '0' AND ALARM_CHECKED = '0' ";
if (!String.IsNullOrWhiteSpace(cCAMERA_NAME))
{
cWhereParm = cWhereParm + " AND (CAMERA_NAME LIKE '%" + cCAMERA_NAME + "%')";
}
cWhereParm = cWhereParm + " )";
if (!String.IsNullOrWhiteSpace(cALARM_FLAG))
{
cWhereParm = cWhereParm + " AND (ALARM_FLAG=" + cALARM_FLAG + ") ";
}
if (!String.IsNullOrWhiteSpace(cALARM_CHECKED))
{
if (cALARM_CHECKED.Equals("0"))
{
cWhereParm = cWhereParm + " AND ALARM_CHECKED='" + cALARM_CHECKED + "'";
}
else
{
cWhereParm = cWhereParm + " AND ALARM_CHECKED> 0 ";
}
}
String cOrderBy = "ORDER BY REC_ID ASC";
DBResult dbret = dao.Query("*"
+ ",(SELECT CAMERA_NAME FROM XT_CAMERA X WHERE X.DEVICE_ID=CAMERA_ID) AS CAMERA_NAME"
+ ",(SELECT ADDR FROM XT_CAMERA X WHERE X.DEVICE_ID=CAMERA_ID) AS ADDR ", "XT_IMG_REC T", cWhereParm, cOrderBy, iPageNo, iPageSize);
DataTable dtRows = dbret.dtrows;
int iRowsCount = dbret.ROW_COUNT;
vret = ActiveResult.Query(dtRows);
vret.total = iRowsCount;
response.Write(vret.toJSONString());
}
/// <summary>
/// 用户登录模块
/// </summary>
public void UserLogin()
{
ActiveResult vret = new ActiveResult();
String cUserID = StringEx.getString(request["USERID"]);
String cKeyWord = StringEx.getString(request["KEYWORD"]);
if (cUserID.Length == 0)
{
vret = ActiveResult.Valid("usercode", "登录账号不能为空！");
}
else if (cKeyWord.Length == 0)
{
vret = ActiveResult.Valid("userpass", "登录密码不能为空！");
}
else
{
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT * FROM S_USER_INF u");
sql.Append(" WHERE USER_ID='" + cUserID + "' and USER_PASSW='" + cKeyWord + "'");
DataTable dtRows = DbManager.QueryData(sql.ToString());
if ((dtRows != null) && (dtRows.Rows.Count > 0))
{
LoginUserInfo vUserInf = new LoginUserInfo();
vUserInf.USER_ID = cUserID;
vUserInf.USER_NAME = StringEx.getString(dtRows, 0, "USER_NAME");
vUserInf.ORG_ID = StringEx.getString(dtRows, 0, "ORG_ID");
vUserInf.ORG_NAME = DbManager.GetStrValue("SELECT * FROM S_ORG_INF o , S_USER_INF u WHERE o.ORG_ID = u.ORG_ID and o.GXQ_ID='" + StringEx.getString(dtRows, 0, "GXQ_ID") + "'");
string sqlstr = "select ORG_TYPE FROM S_ORG_INF o, S_USER_INF u WHERE o.ORG_ID = u.ORG_ID and u.GXQ_ID='" + StringEx.getString(dtRows, 0, "GXQ_ID") + "'";
vUserInf.ORG_TYPE = DbManager.GetStrValue(sqlstr);
vUserInf.ROLE_ID = StringEx.getString(dtRows, 0, "ROLEID");
vret = ActiveResult.returnObject(vUserInf);
}
else
{
vret = ActiveResult.Valid("账号或密码错误！");
}
}
response.Write(vret.toJSONString());
}
public void query()
{
String cORG_ID = StringEx.getString(request["ORG_ID"]);
ActiveResult vret = new ActiveResult();
if (cORG_ID.Length == 0)
{
vret = ActiveResult.Valid("错误，参数ORG_ID未正常传递！");
}
else
{
String cWhereParm = "ORG_ID like '" + cORG_ID + "%'";
String cOrderBy = " order by ORG_ID desc ";
DBResult dbret = dao.Query(cWhereParm, cOrderBy, iPageNo, iPageSize);
DataTable dtRows = dbret.dtrows;
vret = ActiveResult.Query(dtRows);
vret.total = dtRows.Rows.Count;
}
response.Write(vret.toJSONString());
}
public void USER_LOGIN()
{
ActiveResult vret = ActiveResult.Valid(AppConfig.FAILURE);
String vUserCount = StringEx.getString(request["user_id"]);
String vPassWord = StringEx.getString(request["user_pass"]);
String sql = "SELECT COUNT(1) FROM S_USER_INF WHERE USER_CODE='" + vUserCount + "' AND USER_PASS = " + vPassWord;
String sqlValue = DbManager.GetStrValue(sql);
int iRSCount = StringEx.getInt(sqlValue);
if (iRSCount > 0)
{
HttpCookie vUserInf = new HttpCookie(AppConfig.SESSION_USER_ID, vUserCount);
HttpCookie ckUser = new HttpCookie(AppConfig.SESSION_USER_ID, vUserCount);
request.Cookies.Add(ckUser);
HttpContext.Current.Session[AppConfig.SESSION_USER_ID] = vUserCount;
request.Cookies.Add(vUserInf);
}
vret = ActiveResult.Valid(iRSCount);
response.Write(vret.toJSONString());
}
public void query_list()
{
String cREC_ID = StringEx.getString(request["REC_ID"]);
ActiveResult vret = ActiveResult.Valid(AppConfig.FAILURE);
DataTable dtInfo = DbManager.QueryData("SELECT CAMERA_ID,PRESET_ID FROM XT_IMG_REC WHERE REC_ID='" + cREC_ID + "'");
String cCAMERA_ID = StringEx.getString(dtInfo, 0, "CAMERA_ID");
String cPRESET_ID = StringEx.getString(dtInfo, 0, "PRESET_ID");
String cWhereParm = " CAMERA_ID='" + cCAMERA_ID + "' AND PRESET_ID='" + cPRESET_ID + "'";
String cOrderBy = "ORDER BY REC_ID ASC";
DBResult dbret = dao.Query("*,(SELECT ADDR FROM XT_CAMERA X WHERE X.DEVICE_ID=CAMERA_ID) AS ADDR ", "XT_IMG_REC T", cWhereParm, cOrderBy, iPageNo, iPageSize);
DataTable dtRows = dbret.dtrows;
int iRowsCount = dbret.ROW_COUNT;
vret = ActiveResult.Query(dtRows);
vret.total = iRowsCount;
response.Write(vret.toJSONString());
}
public void Query()
{
ActiveResult vret = ActiveResult.Valid(AppConfig.FAILURE);
String cFileList = StringEx.getString(request["FILELIST"]);
String cWhereParm = StringEx.getString(request["WHEREPARM"]);
String cTableName = StringEx.getString(request["TABLENAME"]);
String cOrderBy = StringEx.getString(request["CORDERBY"]);
String cPAGENO = StringEx.getString(request["PAGENO"]);
String cPAGESIZE = StringEx.getString(request["PAGESIZE"]);
log4net.WriteLogFile("FileList--" + cFileList + ":WhereParm--" + cWhereParm + ":TableName--" + cTableName, LogType.DEBUG);
if (String.IsNullOrWhiteSpace(cTableName))
{
vret = ActiveResult.Valid("数据表不能为空！");
}
else if (String.IsNullOrWhiteSpace(cFileList))
{
vret = ActiveResult.Valid("数据字段不能为空！");
}
else
{
int iPageNo = 1;
int iPageSize = 15;
if (!String.IsNullOrWhiteSpace(cPAGENO))
{
iPageNo = StringEx.getInt(cPAGENO);
}
if (!String.IsNullOrWhiteSpace(cPAGESIZE))
{
iPageSize = StringEx.getInt(cPAGESIZE);
}
DBResult rs = DbManager.Query(cFileList, cTableName, cWhereParm, cOrderBy, iPageNo, iPageSize);
vret = ActiveResult.returnObject(rs.dtrows);
vret.total = rs.ROW_COUNT;
}
response.Write(vret.toJSONString());
}
public void save()
{
ActiveResult vret = ActiveResult.Valid(AppConfig.SUCCESS);
String cKeyID = StringEx.getString(request["ID"]);
String cREC_ID = StringEx.getString(request["REC_ID"]);
if (String.IsNullOrWhiteSpace(cREC_ID))
{
vret = ActiveResult.Valid("参数传递错误！");
}
else
{
String cDeviceID = DbManager.GetStrValue("SELECT CAMERA_ID FROM XT_IMG_REC WHERE REC_ID='" + cREC_ID + "'");
XT_CAMERA_Dao dao = new XT_CAMERA_Dao();
XT_CAMERA mv = dao.FindItem(cDeviceID);
String cAddress = mv.addr;
String CX = StringEx.getString(mv.x);
String CY = StringEx.getString(mv.y);
String ID = AutoID.getAutoID();
List <String> sqls = new List <string>();
sqls.Add(" update XT_IMG_REC SET ALARM_CHECKED =1 WHERE REC_ID = '" + cREC_ID + "' ");
JActiveTable aTable = new JActiveTable();
aTable.TableName = "XT_JB";
aTable.AddField("ID", ID);
aTable.AddField("ADRESS", cAddress);
aTable.AddField("X", CX);
aTable.AddField("Y", CY);
sqls.Add(aTable.getInsertSQL());
int iCode = DbManager.ExecSQL(sqls);
vret = ActiveResult.Valid(iCode);
}
response.Write(vret.toJSONString());
}
public void GTWS()
{
ActiveResult vert = new ActiveResult();
XT_JB vo = new XT_JB();
vo.jbtype = "GTWS";
vo.time = DateTime.Now.ToString("yyyy-MM-dd");
vo.sd_result = 0;
String cOrgID = StringEx.getString(request["org_id"]);
vo.org_id = cOrgID;
vo.adress = StringEx.getString(request["Address"]);
vo.neirong = StringEx.getString(request["Content"]);
vo.open_id = StringEx.getString(request["open_id"]);
vo.danwei = DbManager.GetStrValue("SELECT ORG_ID FROM XT_CAMERA WHERE DEVICE_ID='" + vo.open_id + "'");
String cAppDir = System.Web.HttpContext.Current.Server.MapPath("~/");
String cFileDir = cAppDir + "GTWSUpload\\";
if (!Directory.Exists(cFileDir))
{
Directory.CreateDirectory(cFileDir);
}
String cKeyID = AutoID.getAutoID();
vo.id = cKeyID;
cFileDir = cFileDir + cKeyID.Substring(0, 8) + "\\";
if (!Directory.Exists(cFileDir))
{
Directory.CreateDirectory(cFileDir);
}
List <string> sqls = new List <string>();
List <UploadFileInfo> FileList = this.getUploadList(cOrgID, "GTWSUpload");
String cFile_ID = null;
List <String> sqlList = getUploadSQL(FileList);
for (int i = 0; (sqlList != null) && (i < sqlList.Count); i++)
{
sqls.Add(sqlList[i]);
if (i == 0)
{
cFile_ID = FileList[i].ID;
}
else
{
cFile_ID = cFile_ID + "," + FileList[i].ID;
}
}
vo.files_id = cFile_ID;
string vMaster = dao.Insert(vo);
sqls.Add(vMaster);
int iCode = DbManager.ExecSQL(sqls);
ActiveResult vret = ActiveResult.Valid(iCode);
response.Write(vret.toJSONString());
}