public void report()
{
ActiveResult vret = ActiveResult.Valid(AppConfig.FAILURE);
String cORG_ID = StringEx.getString(request["ORG_ID"]);
if (String.IsNullOrEmpty(cORG_ID))
{
vret = ActiveResult.Valid("用户账号不能为空！");
}
else
{
String cAreaID = AppManager.getAreaHeader(cORG_ID);
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT ORG_ID ");
sql.Append(" , (SELECT ORG_NAME FROM S_ORG_INF X WHERE X.ORG_ID = T.ORG_ID) AS ORG_NAME ");
sql.Append(" , COUNT(1) AS ALL_TASK ");
sql.Append(" , (SELECT COUNT(1) FROM XT_TASK_LIST X WHERE X.ORG_ID = T.ORG_ID) AS LEFT_TASK ");
sql.Append(" FROM XT_CAMERA T ");
sql.Append(" WHERE ORG_ID like '" + cAreaID + "%'");
sql.Append(" GROUP BY ORG_ID ");
DataTable dtRows = DbManager.QueryData(sql.ToString());
vret = ActiveResult.Query(dtRows);
}
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 cCLS_ID = StringEx.getString(request["cls_id"]);
XT_NEWS vo = new XT_NEWS();
vo = (XT_NEWS)RequestUtil.readFromRequest(request, vo);
vo.cls_id = cCLS_ID;
vo.update_time = StringEx.getString(DateUtils.getDayTimeNum());
if (String.IsNullOrEmpty(cORG_ID))
{
vret = ActiveResult.Valid("单位编码不能为空！");
}
else if (String.IsNullOrEmpty(cCLS_ID))
{
vret = ActiveResult.Valid("类型不能为空！");
}
if (vret.result == AppConfig.SUCCESS)
{
int iCode = dao.save(vo, cKeyID);
vret = ActiveResult.Valid(iCode);
}
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", "");
XT_JB_SEND vo = new XT_JB_SEND();
vo.createdatetime = DateTime.Now.ToString("yyyy-MM-dd");
vo = (XT_JB_SEND)RequestUtil.readFromRequest(request, vo);
if (String.IsNullOrEmpty(cORG_ID))
{
vret = ActiveResult.Valid("单位编码不能为空！");
}
else if (String.IsNullOrEmpty(vo.user_count))
{
vret = ActiveResult.Valid("用户账号不能为空！");
}
if (vret.result == AppConfig.SUCCESS)
{
int iCode = dao.save(vo, "");
vret = ActiveResult.Valid(iCode);
}
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());
}
/// <summary>
/// 执行SQL语句
/// </summary>
public void ExecSQL()
{
List <String> sqls = new List <string>();
List <Object[]> objs = new List <Object[]>();
for (int i = 1; i < 1000; i++)
{
String cSQL = StringEx.getString(request["SQL_" + i]);
String cPARM = StringEx.getString(request["PARM_" + i]);
if (!String.IsNullOrWhiteSpace(cSQL))
{
sqls.Add(cSQL);
log4net.WriteLogFile("SQL--" + cSQL, LogType.DEBUG);
if (!String.IsNullOrWhiteSpace(cPARM))
{
Object[] parmList = JsonLib.ToObject <Object[]>(cPARM);
log4net.WriteLogFile("PARM--" + cPARM, LogType.DEBUG);
objs.Add(parmList);
}
else
{
objs.Add(null);
}
}
else
{
break;
}
}
ActiveResult vret = ActiveResult.Valid(AppConfig.FAILURE);
int iCode = DbManager.ExecSQL(sqls, objs);
vret = ActiveResult.Valid(iCode);
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 cCLS_ID = StringEx.getString(request["cls_id"]);
String cALARM_FLAG = StringEx.getString(request["ALARM_FLAG"]);
String cREC_ID = StringEx.getString(request["REC_ID"]);
String Ccamera_name = StringEx.getString(request["CAMERA_NAME"]);
String CADDR = StringEx.getString(request["ADDR"]);
String CX = StringEx.getString(request["X"]);
String CY = StringEx.getString(request["Y"]);
String ID = (System.DateTime.Now).ToFileTime().ToString();
if (!String.IsNullOrWhiteSpace(Ccamera_name) && !String.IsNullOrWhiteSpace(CADDR) && !String.IsNullOrWhiteSpace(CX) && !String.IsNullOrWhiteSpace(CY))
{
DbManager.ExecSQL(" update XT_IMG_REC SET ALARM_FLAG = '" + cALARM_FLAG + "' and ALARM_CHECKED =1 WHERE REC_ID = '" + cREC_ID + "' ");
int Code = DbManager.ExecSQL(" INSERT INTO XT_JB (ID,ADRESS,X,Y)VALUES('" + ID + "','" + CADDR + "','" + CX + "','" + CY + "') ");
vret.total = Code;
}
else
{
int Code = DbManager.ExecSQL(" update XT_IMG_REC SET ALARM_FLAG = '" + cALARM_FLAG + "' and ALARM_CHECKED =1 WHERE REC_ID = '" + cREC_ID + "' ");
vret.total = Code;
}
response.Write(vret.toJSONString());
}
/// <summary>
/// 根据单位类型和上级模块，查询可管理模块。
/// </summary>
public void MENU()
{
ActiveResult vret = new ActiveResult();
String cTYPE_ID = StringEx.getString(request["TYPE_ID"]);
String cORG_CLS = StringEx.getString(request["ORG_CLS"]);
if (cTYPE_ID.Length == 0)
{
vret = ActiveResult.Valid("单位序号不能为空！");
}
else if (cORG_CLS.Length == 0)
{
vret = ActiveResult.Valid("单位类型不能为空！");
}
else
{
StringBuilder sql = new StringBuilder();
sql.Append(" SELECT ITEM_ID,ITEM_NAME,EVENT,PARENTID,ALLOW_ORGS ");
sql.Append(" FROM S_NODES ");
sql.Append(" WHERE PARENTID='" + cTYPE_ID + "' and ALLOW_ORGS LIKE '" + "%" + cORG_CLS + "%" + "'");
DataTable dtRows = DbManager.QueryData(sql.ToString());
vret = ActiveResult.Query(dtRows);
}
response.Write(vret.toJSONString());
}
public void city_gxsd()
{
ActiveResult vret = new ActiveResult();
String cXZQDM = StringEx.getString(request["XZQDM"]);
String cORG_ID = StringEx.getString(request["ORG_ID"]);
if (String.IsNullOrEmpty(cORG_ID))
{
vret = ActiveResult.Query(null);
response.Write(vret.toJSONString());
return;
}
cORG_ID = cORG_ID.Replace("00", "");
StringBuilder sql = new StringBuilder();
if (cORG_ID.Length == 4)
{
sql.Append(" (XZQDM LIKE '" + cORG_ID + "%') ");
}
if (cXZQDM.Length > 0)
{
sql.Append(" AND (XZQDM='" + cXZQDM + "') ");
}
DBResult dbret = dao.Query("JCTB_GUID,XZQDM,XMC AS XZQMC,JCBH,AREA_XZQDM AS GXQDM,(SELECT GXQ_NAME FROM S_GXQ_INF X WHERE X.GXQ_ID=AREA_XZQDM) AS GXQMC ", sql.ToString(), " order by xzqdm,jcbh asc ", iPageNo, iPageSize);
vret = ActiveResult.Query(dbret.dtrows);
int iRowCount = (dbret == null) ? 0 : dbret.ROW_COUNT;
vret.total = iRowCount;
response.Write(vret.toJSONString());
}
private void btnApply_Click(object sender, EventArgs e)
{
String cUrl = Config.GetAppSettings(AppConfig.WEB_URL) + "api/rest.ashx";
Dictionary <String, String> vParmList = new Dictionary <string, string>();
vParmList.Add("action_type", "WFJB");
vParmList.Add("action_method", "GTWS");
vParmList.Add("open_id", CameraID);
//vParmList.Add("org_id", ApplicationEvent.UserInfo.ORG_ID);
vParmList.Add("address", txtAddress.Text);
vParmList.Add("content", txtContent.Text);
String[] FileList = new string[1];
FileList[0] = PHOTO_FILENAME;
HttpUtil vTool = new HttpUtil();
string cValue = vTool.HttpPost(cUrl, vParmList, FileList);
ActiveResult vret = ActiveResult.Valid(AppConfig.FAILURE);
if (!String.IsNullOrEmpty(cValue))
{
vret = JsonLib.ToObject <ActiveResult>(cValue);
}
if (vret.result == AppConfig.SUCCESS)
{
MessageBox.Show("数据保存成功！");
this.Close();
}
else
{
MessageBox.Show("数据保存失败，稍后请重试！");
}
}
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());
}
/// <summary>
/// 删除项目
/// </summary>
/// <param name="cKeyID"></param>
/// <returns></returns>
public int del_item(String cKeyID)
{
ActiveResult vret = new ActiveResult();
string sql = "DELETE FROM xt_jctb WHERE ogr_fid='" + cKeyID + "'";
return(DbManager.ExecSQL(sql));
}
public void save()
{
ActiveResult vret = ActiveResult.Valid(AppConfig.SUCCESS);
String cKeyID = StringEx.getString(request["ID"]);
String cUser_Count = StringEx.getString(request["user_count"]);
String cORG_ID = StringEx.getString(request["org_id"]);
String cAREA_ID = StringEx.getString(request["AREA_ID"]);
cAREA_ID = cAREA_ID.Replace("00", "");
XT_MOBILE_USER vo = new XT_MOBILE_USER();
vo = (XT_MOBILE_USER)RequestUtil.readFromRequest(request, vo);
vo.user_count = vo.phone_num;
if (String.IsNullOrEmpty(cORG_ID))
{
vret = ActiveResult.Valid("单位编码不能为空！");
}
else if (String.IsNullOrEmpty(vo.phone_num))
{
vret = ActiveResult.Valid("手机号码不能为空！");
}
if (vret.result == AppConfig.SUCCESS)
{
int iCode = dao.save(vo, cKeyID);
vret = ActiveResult.Valid(iCode);
}
response.Write(vret.toJSONString());
}
public void find()
{
ActiveResult vret = new ActiveResult();
String cDBKey = StringEx.getString(request["ID"]);
DataTable dtRows = DbManager.QueryData("select * from XT_IMG_SCREEN where id='" + cDBKey + "'");
String cCUTOUT_TXT = StringEx.getString(dtRows, 0, "CUTOUT_TXT");
int i = cCUTOUT_TXT.IndexOf(",");
dtRows.Columns.Add("CHINESE");
StringBuilder cChinese = new StringBuilder();
if (i > 0)
{
string[] sArray = cCUTOUT_TXT.Split(',');
foreach (string cEN in sArray)
{
String cCH = DbManager.GetStrValue("select CHINESE from XT_IMG_DICT where ENGLISH like '%" + cEN + "%'");
if (String.IsNullOrEmpty(cCH))
{
cChinese.Append(cEN + ",");
}
else
{
cChinese.Append(cCH + ",");
}
}
}
dtRows.Rows[0]["CHINESE"] = cChinese.ToString();
vret = ActiveResult.Query(dtRows);
response.Write(vret.toJSONString());
}
public void query()
{
String cORG_ID = Config.GetAppSettings("ORG_ID");
ActiveResult vret = ActiveResult.Valid(AppConfig.FAILURE);
String cWhereParm = " (ORG_ID ='" + cORG_ID + "') ";
String cSTART_DAY = StringEx.getString(request["START_DAY"]);
String cFINISH_DAY = StringEx.getString(request["FINISH_DAY"]);
if (!String.IsNullOrEmpty(cSTART_DAY))
{
cWhereParm = cWhereParm + " AND TIME>='" + cSTART_DAY + "'";
}
if (!String.IsNullOrEmpty(cFINISH_DAY))
{
cWhereParm = cWhereParm + " AND TIME<='" + cFINISH_DAY + "'";
}
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 static DataTable QueryData(String vSQL)
{
String cWebUrl = INIConfig.ReadString("Config", "WEB_URL");
String cUrl = "http://" + cWebUrl + "/api/rest.ashx";
try
{
String cActionType = "SQLDB";
String cActionMethod = "QueryData";
cUrl = cUrl + "?action_type=" + cActionType + "&action_method=" + cActionMethod;
HttpUtil vPost = new HttpUtil();
Dictionary <String, String> vData = new Dictionary <string, string>();
vData.Add("SQL", vSQL);
String cStr = vPost.HttpPost(cUrl, vData);
ActiveResult vret = JsonLib.ToObject <ActiveResult>(cStr);
if (vret.result == AppConfig.SUCCESS)
{
cStr = StringEx.getString(vret.info);
DataTable dtRows = JsonLib.ToObject <DataTable>(cStr);
return(dtRows);
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(null);
}
}
public static int ExecSQL(List <String> sqlList, List <Object[]> parmList)
{
String cWebUrl = INIConfig.ReadString("Config", "WEB_URL");
String cUrl = "http://" + cWebUrl + "/api/rest.ashx";
try
{
String cActionType = "SQLDB";
String cActionMethod = "ExecSQL";
cUrl = cUrl + "?action_type=" + cActionType + "&action_method=" + cActionMethod;
HttpUtil vPost = new HttpUtil();
Dictionary <String, String> vData = new Dictionary <string, string>();
for (int i = 0; i < sqlList.Count; i++)
{
String vSQL = sqlList[i];
vData.Add("SQL_" + (i + 1), vSQL);
if (parmList != null)
{
String cParm = JsonLib.ToJSON(parmList[i]);
vData.Add("PARM_" + (i + 1), cParm);
}
}
String cStr = vPost.HttpPost(cUrl, vData);
ActiveResult vret = JsonLib.ToObject <ActiveResult>(cStr);
return(vret.result);
}
catch (Exception ex)
{
return(AppConfig.FAILURE);
}
}
public void last()
{
ActiveResult vret = new ActiveResult();
XT_NOTICE vo = dao.FindLast();
vret = ActiveResult.returnObject(vo);
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 execsql()
{
ActiveResult vret = new ActiveResult();
String sql = StringEx.getString(request["SQLTEXT"]);
int iCode = dao.execsql(sql);
vret = ActiveResult.Valid(iCode);
response.Write(vret.toJSONString());
}
public void query()
{
ActiveResult vret = new ActiveResult();
String sql = StringEx.getString(request["SQLTEXT"]);
DataTable dtRows = dao.query(sql);
vret = ActiveResult.Query(dtRows);
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 query()
{
ActiveResult vret = new ActiveResult();
DBResult dbret = dao.Query(null, "ORDER BY NOTICE_ID DESC", iPageNo, iPageSize);
vret = ActiveResult.Query(dbret.dtrows);
vret.total = dbret.ROW_COUNT;
response.Write(vret.toJSONString());
}
public void del_list()
{
ActiveResult vret = new ActiveResult();
String cDBKey = StringEx.getString(request[DEL_LIST_KEY]);
int iCode = dao.del_list(cDBKey);
vret = ActiveResult.Valid(iCode);
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 int del_item(String cDBKey)
{
ActiveResult vret = new ActiveResult();
string sql = "";
sql = "DELETE FROM S_PAGE_DICT WHERE dict_id='" + cDBKey + "'";
int iCode = DbManager.ExecSQL(sql);
return(iCode);
}
public int del_item(String cDBKey)
{
ActiveResult vret = new ActiveResult();
string sql = "";
sql = "DELETE FROM XT_TASK WHERE REC_ID='" + cDBKey + "'";
int iCode = DbManager.ExecSQL(sql);
return(iCode);
}
public int del_item(String cAppID, String cDBKey)
{
ActiveResult vret = new ActiveResult();
string sql = "";
sql = "DELETE FROM WX_USER WHERE OPENID='" + cDBKey + "'";
int iCode = DbManager.ExecSQL(sql);
return(iCode);
}
public int del_item(String cDBKey)
{
ActiveResult vret = new ActiveResult();
string sql = "";
sql = "DELETE FROM S_TEMPLATE WHERE template_id='" + cDBKey + "'";
int iCode = DbManager.ExecSQL(sql);
return(iCode);
}
public void query()
{
ActiveResult vret = new ActiveResult();
String cORG_ID = StringEx.getString(request["ORG_ID"]);
String cWhereParm = "ORG_ID='" + cORG_ID + "'";
DataTable dtRows = dao.QueryData(cWhereParm);
vret = ActiveResult.Query(dtRows);
response.Write(vret.toJSONString());
}
public DataTable QueryList(String cRoleID, String cTypeID)
{
ActiveResult vret = new ActiveResult();
string sql = "SELECT * FROM S_NODES T "
+ " WHERE (T.ISACTIVE=1) "
+ " AND (TYPE_ID='" + cTypeID + "') "
+ " AND EXISTS(SELECT 1 FROM S_ROLE_GRANT X WHERE (X.ROLE_ID='" + cRoleID + "') AND T.ID=X.NODE_ID) ";
return(DbManager.QueryData(sql));
}
