Example #1
0
		public void cfy_daten_update (string signalquelle_id, string type, string kategorie, string cluster_id, string ort, int region, string plz,
		                       string strasse, string hnr, string gestatt_name, string gestatt_vertragsnr, int objekt_id, int soll_we, int subscriber,
		                       int subscriber_int, int subscriber_tel, string status, string cmts, string gps_langengrad, string gps_breitengrad,
		                       string signallieferant)
		{
			string query = "UPDATE " + System.Reflection.MethodBase.GetCurrentMethod ().Name + " SET " +
			               "signalquelle_id='" + signalquelle_id + "'," +
			               "type ='" + type + "'," +
			               "kategorie ='" + kategorie + "'," +
			               "cluster_id ='" + cluster_id + "'," +
			               "ort ='" + ort + "'," +
			               "region =" + region + "," +
			               "plz ='" + plz + "'," +
			               "strasse='" + strasse + "'," +
			               "hnr='" + hnr + "'," +
			               "gestatt_name='" + gestatt_name + "'," +
			               "gestatt_vertragsnr='" + gestatt_vertragsnr + "'," +
			               "objekt_id=" + objekt_id + "," +
			               "soll_we=" + soll_we + "," +
			               "subscriber=" + subscriber + "," +
			               "subscriber_int=" + subscriber_int + "," +
			               "subscriber_tel=" + subscriber_tel + "," +

			               "status='" + status + "'," +
			               "cmts='" + cmts + "'," +
			               "gps_langengrad='" + gps_langengrad + "'," +
			               "gps_breitengrad='" + gps_breitengrad + "'," +
			               "signallieferant='" + signallieferant + "'" +
			               " WHERE objekt_id = " + objekt_id + ";";


			MySQLQueries execute = new MySQLQueries ();
			execute.ExecuteInsertQuery (query);	
		}
Example #2
0
		public void cfy_daten_insert (string signalquelle_id, string type, string kategorie, string cluster_id, string ort, int region, string plz,
		                       string strasse, string hnr, string gestatt_name, string gestatt_vertragsnr, int objekt_id, int soll_we, int subscriber,
		                       int subscriber_int, int subscriber_tel, string status, string cmts, string gps_langengrad, string gps_breitengrad,
		                       string signallieferant)
		{
			string query = "INSERT INTO " + System.Reflection.MethodBase.GetCurrentMethod ().Name + " (" +
			               "signalquelle_id," +
			               "type," +
			               "kategorie," +
			               "cluster_id," +
			               "ort," +
			               "region," +
			               "plz," +
			               "strasse," +
			               "hnr," +
			               "gestatt_name," +
			               "gestatt_vertragsnr," +
			               "objekt_id," +
			               "soll_we," +
			               "subscriber," +
			               "subscriber_int," +
			               "subscriber_tel," +

			               "status," +
			               "cmts," +
			               "gps_langengrad," +
			               "gps_breitengrad," +
			               "signallieferant) " +
			               "VALUES ('" +
			               signalquelle_id + "','" +
			               type + "','" +
			               kategorie + "','" +
			               cluster_id + "','" +
			               ort + "','" +
			               region + "','" +
			               plz + "','" +
			               strasse + "','" +
			               hnr + "','" +
			               gestatt_name + "','" +
			               gestatt_vertragsnr + "','" +
			               objekt_id + "','" +
			               soll_we + "','" +
			               subscriber + "','" +
			               subscriber_int + "','" +
			               subscriber_tel + "','" +

			               status + "','" +
			               cmts + "','" +
			               gps_langengrad + "','" +
			               gps_breitengrad + "','" +
			               signallieferant + "');";


			MySQLQueries execute = new MySQLQueries ();
			execute.ExecuteInsertQuery (query);
		}
Example #3
0
			public void cfy_gestattungsgeber_name (string name, byte status)
			{
				string query = "INSERT INTO " + System.Reflection.MethodBase.GetCurrentMethod ().Name + " (" +
				               "name," +
				               "status)" +
				               "VALUES ('+" +
				               name + "','" +
				               status + "');";

				MySQLQueries execute = new MySQLQueries ();
				execute.ExecuteInsertQuery (query);
			}
Example #4
0
			public void cfy_cluster (string cluster_id, byte status)
			{
				string query = "INSERT INTO " + System.Reflection.MethodBase.GetCurrentMethod ().Name + " (" +
				               "cluster_id," +
				               "status)" +
				               "VALUES ('+" +
				               cluster_id + "','" +
				               status + "');";

				MySQLQueries execute = new MySQLQueries ();
				execute.ExecuteInsertQuery (query);
			}
Example #5
0
			public void cfy_gps (string langengrad, string breitengrad, byte status)
			{
				string query = "INSERT INTO " + System.Reflection.MethodBase.GetCurrentMethod ().Name + " (" +
				               "langengrad," +
				               "breitengrad," +
				               "status) " +
				               "VALUES ('+" +
				               langengrad + "','" +
				               breitengrad + "','" +
				               status + "');";

				MySQLQueries execute = new MySQLQueries ();
				execute.ExecuteInsertQuery (query);
			}
Example #6
0
			public void cfy_erstellt (string tabelle, int tabelle_id, int objekt_id, int unix_zeitpunkt)
			{
				string query = "INSERT INTO " + System.Reflection.MethodBase.GetCurrentMethod ().Name + " (" +
				               "tabelle," +
				               "tabelle_id," +
				               "objekt_id, " +
				               "unix_zeitpunkt," +
				               "VALUES ('+" +
				               tabelle + "','" +
				               tabelle_id + "','" +
				               objekt_id + "','" +
				               unix_zeitpunkt + "');";

				MySQLQueries execute = new MySQLQueries ();
				execute.ExecuteInsertQuery (query);
			}
Example #7
0
			public void cfy_kunden (int soll_we, int subscriber, int internet, int telefon, byte status, int objekt_id)
			{
				string query = "INSERT INTO " + System.Reflection.MethodBase.GetCurrentMethod ().Name + " (" +
				               "soll_we," +
				               "subscriber," +
				               "internet," +
				               "telefon," +
				               "status," +
				               "objekt_id) " +
				               "VALUES ('+" +
				               soll_we + "','" +
				               subscriber + "','" +
				               internet + "','" +
				               telefon + "','" +
				               status + "','" +
				               objekt_id + "');";

				MySQLQueries execute = new MySQLQueries ();
				execute.ExecuteInsertQuery (query);
			}