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()); }