public ForSetckk(New_Main_Form mainFrm) { InitializeComponent(); this.mainFrm = mainFrm; MySqlConnection dbConn1; dbConn1 = new MySqlConnection(mainFrm.dbConnectionString); dbConn1.Open(); string sqlStr = " select ckkid,ckkname,ckkstatus from idx_ckk order by ckkid"; DataSet ds = MySqlHelper.ExecuteDataset(dbConn1, sqlStr); if (ds.Tables[0].Rows.Count > 0) { int i = 0; for (; i < ds.Tables[0].Rows.Count; i++) { if ((ds.Tables[0].Rows[i])["ckkid"].ToString() == "1") { if ((ds.Tables[0].Rows[i])["ckkstatus"].ToString() == "1") { ckk1Status.Text = "可用"; } else { ckk1Status.Text = "不可用"; } } if ((ds.Tables[0].Rows[i])["ckkid"].ToString() == "2") { if ((ds.Tables[0].Rows[i])["ckkstatus"].ToString() == "1") { ckk2Status.Text = "可用"; } else { ckk2Status.Text = "不可用"; } } if ((ds.Tables[0].Rows[i])["ckkid"].ToString() == "3") { if ((ds.Tables[0].Rows[i])["ckkstatus"].ToString() == "1") { ckk3Status.Text = "可用"; } else { ckk3Status.Text = "不可用"; } } if ((ds.Tables[0].Rows[i])["ckkid"].ToString() == "4") { if ((ds.Tables[0].Rows[i])["ckkstatus"].ToString() == "1") { ckk4Status.Text = "可用"; } else { ckk4Status.Text = "不可用"; } } } } dbConn1.Close(); }
//private DataSet taskDs = new DataSet(); public TaskAutoRun(New_Main_Form mainform) { this.mainform = mainform; }