public void setAlarmTanim(String Serinolar,AlarmT AlarmTan) { String[] seriNo; seriNo= Serinolar.Split(';'); string sorgu = ""; for (int i = 0; i < seriNo.Length-1; i++) { sorgu = "DELETE FROM ATS_ALARMTAN1M WHERE TNM_ARC='"+seriNo[i]+"';"; SqlHelper.ExecuteNonQuery(SqlHelper.ConnStr,System.Data.CommandType.Text,sorgu); sorgu = "INSERT INTO ATS_ALARMTAN1M (TNM_KUL,TNM_ARC,TNM_GSM,TNM_EPOSTA,TNM_HZLMT,TNM_MESA1,TNM_ROLANT,TNM_DURAKLAMA) VALUES(@P0,@P1,@P2,@P3,@P4,@P5,@P6,@P7);"; SqlParameter[] prm = new SqlParameter[8]; prm[0] = new SqlParameter("P0", AlarmTan.TNM_KUL); prm[1] = new SqlParameter("P1", seriNo[i].Trim()); prm[2] = new SqlParameter("P2", AlarmTan.TNM_GSM); prm[3] = new SqlParameter("P3", AlarmTan.TNM_EPOSTA); prm[4] = new SqlParameter("P4", AlarmTan.TNM_HZLMT); prm[5] = new SqlParameter("P5", AlarmTan.TNM_MESA1); prm[6] = new SqlParameter("P6", AlarmTan.TNM_ROLANT); prm[7] = new SqlParameter("P7", AlarmTan.TNM_DURAKLAMA); SqlHelper.ExecuteNonQuery(SqlHelper.ConnStr, CommandType.Text, sorgu, prm); } }
public void setAlarmTanim(String Serinolar, AlarmT AlarmTan) { String[] seriNo; seriNo = Serinolar.Split(';'); string sorgu = ""; for (int i = 0; i < seriNo.Length - 1; i++) { sorgu = "DELETE FROM ATS_ALARMTAN1M WHERE TNM_ARC='" + seriNo[i] + "';"; SqlHelper.ExecuteNonQuery(SqlHelper.ConnStr, System.Data.CommandType.Text, sorgu); sorgu = "INSERT INTO ATS_ALARMTAN1M (TNM_KUL,TNM_ARC,TNM_GSM,TNM_EPOSTA,TNM_HZLMT,TNM_MESA1,TNM_ROLANT,TNM_DURAKLAMA) VALUES(@P0,@P1,@P2,@P3,@P4,@P5,@P6,@P7);"; SqlParameter[] prm = new SqlParameter[8]; prm[0] = new SqlParameter("P0", AlarmTan.TNM_KUL); prm[1] = new SqlParameter("P1", seriNo[i].Trim()); prm[2] = new SqlParameter("P2", AlarmTan.TNM_GSM); prm[3] = new SqlParameter("P3", AlarmTan.TNM_EPOSTA); prm[4] = new SqlParameter("P4", AlarmTan.TNM_HZLMT); prm[5] = new SqlParameter("P5", AlarmTan.TNM_MESA1); prm[6] = new SqlParameter("P6", AlarmTan.TNM_ROLANT); prm[7] = new SqlParameter("P7", AlarmTan.TNM_DURAKLAMA); SqlHelper.ExecuteNonQuery(SqlHelper.ConnStr, CommandType.Text, sorgu, prm); } }
public void setAlarmTanim(String Serinolar, AlarmT AlarmTan) { Ater.setAlarmTanim(Serinolar, AlarmTan); return; }