public void find() { XT_CAMERA_CONFIG_Dao camera_config_dao = new XT_CAMERA_CONFIG_Dao(); ActiveResult vret = ActiveResult.Valid(AppConfig.FAILURE); //String cORG_ID = StringEx.getString(request["DICT_ID"]); String cID = StringEx.getString(request["ID"]); XT_CAMERA xt_camera = CAMERADAO.FindOne(cID); String deviceid = xt_camera.device_id; XT_CAMERA_CONFIG camera_config = camera_config_dao.FindOne(deviceid); String cDevice_ID = camera_config.device_id; if (String.IsNullOrEmpty(cDevice_ID)) { DbManager.ExecSQL(" INSERT INTO XT_CAMERA_CONFIG SET DICT_ID = '" + deviceid + "'"); } else { XT_CAMERA_CONFIG vInfo = camera_config_dao.FindOne(cDevice_ID); vret = ActiveResult.returnObject(vInfo); } response.Write(vret.toJSONString()); }
public void save() { ActiveResult vret = ActiveResult.Valid(AppConfig.FAILURE); String cORG_ID = StringEx.getString(request["ORG_ID"]); String cKEYNAME = StringEx.getString(request["KEYNAME"]); String cKEYVALUE = StringEx.getString(request["KEYVALUE"]); if (String.IsNullOrEmpty(cORG_ID)) { vret = ActiveResult.Valid("单位编码参数不能为空!"); } else if (String.IsNullOrEmpty(cKEYNAME)) { vret = ActiveResult.Valid("配置项目不能为空!"); } else if (String.IsNullOrEmpty(cKEYVALUE)) { vret = ActiveResult.Valid("配置值不能为空!"); } else { StringBuilder sql = new StringBuilder(); sql.Append(" UPDATE S_ORG_INF_CONFIG "); sql.Append(" SET KEYVALUE='" + cKEYVALUE + "'"); sql.Append(" WHERE ORG_ID='" + cORG_ID + "'"); sql.Append(" AND KEYNAME='" + cKEYNAME + "'"); int iCode = DbManager.ExecSQL(sql.ToString()); vret = ActiveResult.returnObject(iCode); } response.Write(vret.toJSONString()); }
public void finditem(String cDBKey) { ActiveResult vret = new ActiveResult(); XT_NOTICE vo = dao.FindOne(cDBKey); vret = ActiveResult.returnObject(vo); response.Write(vret.toJSONString()); }
public void last() { ActiveResult vret = new ActiveResult(); XT_NOTICE vo = dao.FindLast(); vret = ActiveResult.returnObject(vo); response.Write(vret.toJSONString()); }
public void find() { ActiveResult vret = new ActiveResult(); String cKeyID = StringEx.getString(request["ID"]); XT_DJInfo vo = dao.FindOne(cKeyID); vret = ActiveResult.returnObject(vo); response.Write(vret.toJSONString()); }
public void finditem() { ActiveResult vret = new ActiveResult(); String cDBKey = StringEx.getString(request[AppConfig.__DBKEY]); S_ORG_INF_WX_CONFIG vo = dao.FindOne(cDBKey); vret = ActiveResult.returnObject(vo); 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 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 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()); }
/// <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()); }
/// <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() { 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()); }