public void AlarmcodeReport1(string CarID1, string Carid1) { InitializeComponent();
DataSet ds = Get_Goods_Load_Infos(CarID1, Carid1);
//int i = 0; //int ii = 1; // if (i <= ii)<br /> if (ds != null) { foreach (DataRow row in ds.Tables[0].Rows) { string ALARMID = row["ALARMID"].ToString().Trim(); //string ALARMTEXT = row["ALARMTEXT"].ToString().Trim(); //string ALARMRECOVERYTEXT = row["ALARMRECOVERYTEXT"].ToString().Trim(); //string ERRORID = row["ERRORID"].ToString().Trim(); string UNITTYPE = row["UNITTYPE"].ToString().Trim(); //tex1.Text = row["ALARMID"].ToString(); //tex2.Text = row["ALARMTEXT"].ToString().Trim(); //tex3.Text = row["ALARMRECOVERYTEXT"].ToString().Trim(); //tex4.Text = row["ERRORID"].ToString().Trim(); //tex5.Text = row["UNITTYPE"].ToString().Trim(); tex1.Text = ALARMID; //tex2.Text = ALARMTEXT; //tex3.Text = ALARMRECOVERYTEXT; //tex4.Text = ERRORID; tex5.Text = UNITTYPE; } }
}
public DataSet Get_Goods_Load_Infos(string ALARMID, string UNITTYPE) {
DataSet ds = null; string sql = "UPDATE ALARMCODE2 SET ALARMTEXT = '" + tex2.Text + "' , ALARMRECOVERYTEXT = '" + tex3.Text + "' , ERRORID = '" + tex4.Text + "'WHERE ALARMID = '" + ALARMID + "' , UNITTYPE = '" + UNITTYPE + "'"; ds = OraFunc.GetDS_OracleTable("ALARMCODE2", sql); return (ds); }
private void button1_Click(object sender, EventArgs e) {
AlarmcodeReport1(CarID1, Carid1); }
CarID1 À̸§ÀÌ ÇöÀç ÄÁÅؽºÆ®¿¡ ¾ø½À´Ï´Ù. Carid1 À̸§ÀÌ ÇöÀç ÄÁÅؽºÆ®¿¡ ¾ø½À´Ï´Ù.
ÀÌ·¸°Ô ¶å´Ï´Ù.. Áö¿ªº¯¼ö ¸Â°Ô ÁØ°Å°°Àºµ¥ ¿ÖÀÌ·¸°Ô ¶ã±î¿ä...; | |
|
CaridµéÀº Àü¿ªº¯¼ö Àΰ¡¿ä?