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