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