public void ScanData() { int result; if (Int32.TryParse(txtCode.Text, out result)) { Int32 code = Int32.Parse(txtCode.Text); DataSet1TableAdapters.tb_assetTableAdapter tb_asset = new DataSet1TableAdapters.tb_assetTableAdapter(); DataTable dt = tb_asset.GetDataByRfidCode(code.ToString()); // MessageBox.Show(dt.Rows.Count.ToString()); DataSet1TableAdapters.tb_trackingTableAdapter tb_tracking = new DataSet1TableAdapters.tb_trackingTableAdapter(); Int32 place_id = Int32.Parse(dlPlace.SelectedValue.ToString()); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; Int32 asset_id = Int32.Parse(dr["id"].ToString()); String check_date = DateTime.Now.ToString("yyyy-MM-dd");; if (dr["place_id"].ToString() != dlPlace.SelectedValue.ToString()) { // Console.WriteLine("Wrong Place"); tb_tracking.InsertQuery(asset_id, place_id, check_date, 2); tb_asset.UpdatePlace(2, 1, place_id, Convert.ToInt32(dr["id"].ToString()), Convert.ToInt32(dr["id"].ToString())); DataSet1TableAdapters.tb_placeTableAdapter tb_place = new DataSet1TableAdapters.tb_placeTableAdapter(); DataTable dt_place = tb_place.GetDataById(Int32.Parse(dr["place_id"].ToString())); DataRow dr_place = dt_place.Rows[0]; lbStatus.Text = "ผิดที่ [ในระบบ : " + dr_place["place_name"] + " ]"; lbStatus.BackColor = Color.Red; } else { tb_tracking.InsertQuery(asset_id, place_id, check_date, 1); tb_asset.UpdatePlace(1, 1, place_id, Convert.ToInt32(dr["id"].ToString()), Convert.ToInt32(dr["id"].ToString())); lbStatus.Text = "พบ"; lbStatus.BackColor = this.BackColor; } } else { lbStatus.Text = "ไม่พบ"; lbStatus.BackColor = Color.Red; } txtCode.Text = ""; txtCode.Focus(); LoadDataToGrid(place_id.ToString()); ShowHighlight(code.ToString()); } }
public void LoadDataToGrid(String place_id) { txtCode.Focus(); try { DataSet1TableAdapters.tb_assetTableAdapter tb_asset = new DataSet1TableAdapters.tb_assetTableAdapter(); DataTable dt = tb_asset.GetDataByPlaceId(Convert.ToInt32(place_id)); dgAsset.Rows.Clear(); foreach (DataRow dr in dt.Rows) { String status = dr["status"].ToString(); String str_status = ""; if (status == "0") { str_status = "ไม่พบ"; } if (status == "1") { str_status = "พบ"; } if (status == "2") { DataSet1TableAdapters.tb_placeTableAdapter tb_place = new DataSet1TableAdapters.tb_placeTableAdapter(); DataTable dt_place = tb_place.GetDataById(Int32.Parse(dr["place_id"].ToString())); DataRow dr_place = dt_place.Rows[0]; str_status = "พบที่ [ ห้อง : " + dr_place["place_name"] + " ]"; } DataGridViewRow dvr = new DataGridViewRow(); dgAsset.Rows.Add(dr["rfid_code"].ToString(), dr["asset_code"].ToString(), dr["asset_name"].ToString(), str_status); } foreach (DataGridViewRow row in dgAsset.Rows) { if (row.Cells[4].Value.ToString() != "พบ" && row.Cells[4].Value.ToString() != "ไม่พบ") { row.DefaultCellStyle.BackColor = Color.Red; } } } catch (Exception ex) { Console.WriteLine(ex.Message); } }