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 SendMSG(String cSender, String cAccept, ActiveMQ_Message vMessage)
{
try
{
//通过工厂建立连接
using (IConnection vActiveMQ = factory.CreateConnection())
{
//通过连接创建Session会话
using (ISession session = vActiveMQ.CreateSession())
{
//通过会话创建生产者，方法里面new出来的是MQ中的Queue
IMessageProducer prod = session.CreateProducer(new Apache.NMS.ActiveMQ.Commands.ActiveMQQueue("MQ" + cAccept));
//创建一个发送的消息对象
ITextMessage message = prod.CreateTextMessage();
//给这个对象赋实际的消息
message.Text = JsonLib.ToJSON(vMessage);
//设置消息对象的属性，这个很重要哦，是Queue的过滤条件，也是P2P消息的唯一指定属性
//message.Properties.SetString("filter", "demo");
//生产者把消息发送出去，几个枚举参数MsgDeliveryMode是否长链，MsgPriority消息优先级别，发送最小单位，当然还有其他重载
prod.Send(message, MsgDeliveryMode.NonPersistent, MsgPriority.Normal, TimeSpan.MinValue);
}
}
}
catch (Exception ex)
{
log4net.WriteLogFile(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
CheckLogin();
LoginUserInfo vUserInfo = getLoginUserInfo();
DBConfig vConf = new DBConfig();
ORG_ID = vUserInfo.ORG_ID;
cHOST = vConf.getOrgKey(ORG_ID, "GTWS_HOST");
cPORT = vConf.getOrgKey(ORG_ID, "GTWS_PORT");
cUSER = vConf.getOrgKey(ORG_ID, "GTWS_USER");
cPASS = vConf.getOrgKey(ORG_ID, "GTWS_PASS");
XT_CAMERA_Dao dao = new XT_CAMERA_Dao();
DataTable CountyList = dao.QueryData("DISTINCT ORG_ID,COUNTY", "ORG_ID LIKE '" + AppManager.getAreaHeader(ORG_ID) + "%'", " ORDER BY ORG_ID");
List <Dictionary <String, string> > KeyList = new List <Dictionary <string, string> >();
DataTable VillageList = dao.QueryData("DISTINCT VILLAGE_ID,VILLAGE,ORG_ID", "ORG_ID LIKE '" + AppManager.getAreaHeader(ORG_ID) + "%'", " ORDER BY ORG_ID");
List <string> ORG_LIST = new List <string>();
for (int i = 0; i < CountyList.Rows.Count; i++)
{
String cID = StringEx.getString(CountyList, i, "ORG_ID");
String cCOUNTY = StringEx.getString(CountyList, i, "COUNTY");
Dictionary <string, string> vo = new Dictionary <string, string>();
vo.Add("id", cID);
vo.Add("name", cCOUNTY);
vo.Add("value", cID);
vo.Add("pid", "0");
vo.Add("isParent", "true");
KeyList.Add(vo);
}
ROOT_LIST = JsonLib.ToJSON(KeyList);
}
public static String Pack(String cTABLE_ID, DataTable dtRows, String cRootDir, String cSYSID)
{
List <ExportObject> arKeys = new List <ExportObject>();
DataTable dtFieldConfig = DbManager.QueryData("SELECT FIELD_NAME,ISKEY FROM S_ETL_FIELD WHERE TABLE_ID='" + cTABLE_ID + "'");
for (int j = 0; (dtRows != null) && (j < dtRows.Rows.Count); j++)
{
ExportObject vo = new ExportObject();
vo.TABLE_ID = cTABLE_ID;
vo.SYS_ID = cSYSID;
String cKEY_ID = StringEx.getString(dtRows, 0, "ID").ToUpper();
for (int k = 0; (dtFieldConfig != null) && (k < dtFieldConfig.Rows.Count); k++)
{
String cFieldName = StringEx.getString(dtFieldConfig, k, "FIELD_NAME").ToUpper();
String cFieldValue = StringEx.getString(dtRows, j, cFieldName);
vo.AddFieldValue(cFieldName, Base64.StrToBase64(cFieldValue));
}
String cFileID_List = StringEx.getString(dtRows, 0, "FILES_ID").ToUpper();
if (cFileID_List.Length > 0)
{
String[] File_List = cFileID_List.Split(',');
cFileID_List = "";
for (int i = 0; i < File_List.Length; i++)
{
if (cFileID_List == "")
{
cFileID_List = "'" + File_List[i] + "'";
}
else
{
cFileID_List = cFileID_List + "," + "'" + File_List[i] + "'";
}
}
DataTable dtFiles = DbManager.QueryData("SELECT ID,TEXT,URL FROM S_UPLOAD WHERE ID in (" + cFileID_List + ")");
for (int k = 0; (dtFiles != null) && (k < dtFiles.Rows.Count); k++)
{
String cID = StringEx.getString(dtFiles, k, "ID").ToUpper();
String cText = StringEx.getString(dtFiles, k, "TEXT").ToUpper();
String cUrl = StringEx.getString(dtFiles, k, "URL").ToUpper();
String cFileName = cRootDir + cUrl.Replace("/", "\\");
if (File.Exists(cFileName))
{
vo.AddFileValue(cID, cText, cUrl, Base64.StrToBase64(cFileName));
}
}
}
arKeys.Add(vo);
}
return(JsonLib.ToJSON(arKeys));
}
public void Child()
{
String cKeyID = StringEx.getString(request["ID"]);
String cVKey, cVName;
List <Dictionary <string, string> > arKeys = new List <Dictionary <string, string> >();
int iTypeID = StringEx.getInt(cKeyID);
DataTable dtRows = null;
if (cKeyID.Length == 6)
{
dtRows = dao.QueryData("DISTINCT VILLAGE_ID AS ID, VILLAGE AS TEXT", " (ORG_ID='" + cKeyID + "') ", " order by VILLAGE ");
}
else
{
dtRows = dao.QueryData("ID, DEVICE_ID, ADDR AS TEXT", " (VILLAGE_ID='" + cKeyID + "') ", " order by ADDR ");
}
for (int i = 0; i < dtRows.Rows.Count; i++)
{
cVKey = StringEx.getString(dtRows, i, "ID");
cVName = StringEx.getString(dtRows, i, "TEXT");
Dictionary <string, string> vo = new Dictionary <string, string>();
vo.Add("id", cVKey);
vo.Add("text", cVName);
vo.Add("name", cVName);
vo.Add("pid", cKeyID);
vo.Add("value", cVKey);
if (cKeyID.Length == 6)
{
vo.Add("isParent", "true");
vo.Add("device_id", "");
}
else
{
vo.Add("isParent", "false");
vo.Add("device_id", StringEx.getString(dtRows, i, "DEVICE_ID"));
}
arKeys.Add(vo);
}
// response.Write(cStart + JsonLib.toJSONString(arKeys) + cFinish);
response.Write(JsonLib.ToJSON(arKeys));
}
public void QueryData()
{
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
{
DataTable dtRows = DbManager.QueryData(sql);
String cStr = JsonLib.ToJSON(dtRows);
vret = ActiveResult.returnObject(cStr);
}
response.Write(vret.toJSONString());
}
protected void Page_Load(object sender, EventArgs e)
{
CheckLogin();
ID = StringEx.getString(Request.QueryString["ID"]);
LoginUserInfo vUserInfo = getLoginUserInfo();
String cUSER_ID = vUserInfo.USER_ID;
String cORG_ID = vUserInfo.ORG_ID;
String cDayTime = StringEx.getString(DateUtils.getDayTimeNum());
String cKeyID = cUSER_ID + "@" + cORG_ID + "@" + cDayTime + "@" + ID;
String cKeyMD = Base64.StrToBase64(cKeyID);
ActiveMQ_Message vMessage = new ActiveMQ_Message();
vMessage.CMD_ID = ActiveMQ_MessageType.VIDEO_LIVE;
Dictionary <string, string> voConf = new Dictionary <string, string>();
voConf.Add("ID", ID);
voConf.Add("ORG_ID", cORG_ID);
voConf.Add("USER_ID", cUSER_ID);
voConf.Add("DAYTIME", cDayTime);
ID = cKeyMD;
vMessage.MESSAGE = JsonLib.ToJSON(voConf);
//ActiveMQ_Producer.SendMessage(cORG_ID, cUSER_ID, vMessage);
}
public static List<KeyValue> getImageList(String cFileName, int iMinVal, int iMaxVal, int iGrayMinVal, int iGrayMaxVal)
{
try
{
Image<Bgr, Byte> BgrImage = null;
Image<Gray, Byte> GrayImage = null;
List<KeyValue> ImageList = new List<KeyValue>();
String cExportDir = Application.StartupPath + "\\export\\";
ResetDirectory(cExportDir);
//调取图片
BgrImage = new Image<Bgr, byte>(cFileName);
GrayImage = new Image<Gray, byte>(BgrImage.Width, BgrImage.Height);
//转灰度
CvInvoke.CvtColor(BgrImage, GrayImage, Emgu.CV.CvEnum.ColorConversion.Rgb2Gray);
//转黑白
Image<Gray, byte> BinaryImage = GrayImage.ThresholdToZeroInv(new Gray(iGrayMinVal));
BinaryImage.Save("D:\\IMG03.jpg");
String cREC_ID = Path.GetFileName(cFileName).Replace(".jpg", "");
VectorOfVectorOfPoint rvs = new VectorOfVectorOfPoint();
CvInvoke.FindContours(BinaryImage, rvs, null, RetrType.List, ChainApproxMethod.ChainApproxSimple);
int j = 10001;
for (int i = 0; i < rvs.Size; i++)
{
var contour = rvs[i];
Rectangle BoundingBox = CvInvoke.BoundingRectangle(contour);
if ((BoundingBox.Width < iMinVal) || (BoundingBox.Height < iMinVal)) continue;
if ((BoundingBox.Width > iMaxVal) || (BoundingBox.Height > iMaxVal)) continue;
j++;
CvInvoke.Rectangle(BgrImage, BoundingBox, new MCvScalar(255, 0, 0, 0), 3);
Image<Bgr, Byte> vResult = BgrImage.GetSubRect(BoundingBox);
String cExportFileName = cREC_ID + "_" + j.ToString() + ".jpg";
vResult.Save(cExportDir + cExportFileName);
KeyValue rowKey = new KeyValue();
rowKey.Text = cExportDir + cExportFileName;
rowKey.Val = JsonLib.ToJSON(BoundingBox);
ImageList.Add(rowKey);
}
String cZipFileName = Application.StartupPath + "\\" + cREC_ID + ".zip";
Zip vo = new Zip();
vo.ZipDir(cExportDir, cZipFileName);
BgrImage.Save("D:\\IMG04.jpg");
return ImageList;
}
catch (Exception ex)
{
log4net.WriteLogFile("报错，原因为：" + ex);
return null;
}
}
