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);
}
}
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 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);
}
}
/// <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());
}
void onConsumerListener(IMessage message)
{
ITextMessage msg = (ITextMessage)message;
//异步调用下，否则无法回归主线程
log4net.WriteLogFile(msg.Text);
String cStr = msg.Text;
ActiveMQ_Message vMessage = JsonLib.ToObject <ActiveMQ_Message>(cStr);
Change(vMessage);
}
public static List <ExportObject> Explain(String cStr)
{
try
{
return(JsonLib.ToObject <List <ExportObject> >(cStr));
}
catch (Exception ex)
{
return(null);
}
}
public List <Rectangle> FindRectangle(String cREC_ID)
{
List <Rectangle> KeyList = new List <Rectangle>();
DataTable dtRows = DbManager.QueryData("SELECT POINT_LIST FROM XT_IMG_LIST WHERE ALARM_FLAG=1 AND REC_ID='" + cREC_ID + "'");
for (int i = 0; i < dtRows.Rows.Count; i++)
{
String cPOINT_LIST = StringEx.getString(dtRows, i, "POINT_LIST");
Rectangle rf = JsonLib.ToObject <Rectangle>(cPOINT_LIST);
KeyList.Add(rf);
}
return(KeyList);
}
public static Boolean RedrawImage(String cFileName, String cRect)
{
try
{
Image<Bgr, byte> vImage = new Image<Bgr, byte>(cFileName);
Rectangle vRect = JsonLib.ToObject<Rectangle>(cRect);
CvInvoke.Rectangle(vImage, vRect, new MCvScalar(255, 0, 0), 2);
vImage.Save(cFileName);
return true;
}
catch (Exception ex)
{
log4net.WriteLogFile(ex.Message);
return false;
}
}
public static DBResult Query(String cFileList, String cTableName, String cWhereParm, String cOrderBy, int iPageNo, int iPageSize)
{
String cWebUrl = INIConfig.ReadString("Config", "WEB_URL");
String cUrl = "http://" + cWebUrl + "/api/rest.ashx";
try
{
String cActionType = "SQLDB";
String cActionMethod = "Query";
cUrl = cUrl + "?action_type=" + cActionType + "&action_method=" + cActionMethod;
HttpUtil vPost = new HttpUtil();
Dictionary <String, String> vData = new Dictionary <string, string>();
vData.Add("FILELIST", cFileList);
vData.Add("TABLENAME", cTableName);
vData.Add("WHEREPARM", cWhereParm);
vData.Add("ORDERBY", cOrderBy);
vData.Add("PAGENO", StringEx.getString(iPageNo));
vData.Add("PAGESIZE", StringEx.getString(iPageSize));
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);
DBResult rs = new DBResult();
rs.dtrows = dtRows;
rs.ROW_COUNT = vret.total;
return(rs);
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(null);
}
}
