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 find() { ActiveResult vret = new ActiveResult(); // String cKeyID = StringEx.getString(request["ID"]); String cKeyID = StringEx.getString(request["ID"]); XT_CAMERA vo = dao.FindOne(cKeyID); vret = ActiveResult.returnObject(vo); response.Write(vret.toJSONString()); }
public void save() { ActiveResult vret = ActiveResult.Valid(AppConfig.SUCCESS); String cKeyID = StringEx.getString(request["ID"]); String cREC_ID = StringEx.getString(request["REC_ID"]); if (String.IsNullOrWhiteSpace(cREC_ID)) { vret = ActiveResult.Valid("参数传递错误!"); } else { String cDeviceID = DbManager.GetStrValue("SELECT CAMERA_ID FROM XT_IMG_REC WHERE REC_ID='" + cREC_ID + "'"); XT_CAMERA_Dao dao = new XT_CAMERA_Dao(); XT_CAMERA mv = dao.FindItem(cDeviceID); String cAddress = mv.addr; String CX = StringEx.getString(mv.x); String CY = StringEx.getString(mv.y); String ID = AutoID.getAutoID(); List <String> sqls = new List <string>(); sqls.Add(" update XT_IMG_REC SET ALARM_CHECKED =1 WHERE REC_ID = '" + cREC_ID + "' "); JActiveTable aTable = new JActiveTable(); aTable.TableName = "XT_JB"; aTable.AddField("ID", ID); aTable.AddField("ADRESS", cAddress); aTable.AddField("X", CX); aTable.AddField("Y", CY); sqls.Add(aTable.getInsertSQL()); int iCode = DbManager.ExecSQL(sqls); vret = ActiveResult.Valid(iCode); } response.Write(vret.toJSONString()); }