Exemple #1
0
 /// <summary>
 /// 改变待测表的界面datagridview
 /// </summary>
 public void ChangeMeter()
 {
     if (DGV_MeterInfo.InvokeRequired)
     {
         MyDelegate_meter Mdm = new MyDelegate_meter(ChangeMeter);
         this.Invoke(Mdm);
     }
     else
     {
         // this.dt_MeterInfoTableAdapter.Fill(this.myDataSet.Dt_MeterInfo);
         DataTable dt = this.dt_MeterInfoTableAdapter.GetData();
         DGV_MeterInfo.AllowUserToAddRows = true;
         this.DGV_MeterInfo.Rows.Clear();
         for (int i = 0; i < dt.Rows.Count; i++)
         {
             DataRow dr = dt.Rows[i];
             this.DGV_MeterInfo.Rows.Add();
             this.DGV_MeterInfo.Rows[i].Cells["MeterId"].Value         = dr["MeterId"].ToString();
             this.DGV_MeterInfo.Rows[i].Cells["MeterType"].Value       = dr["MeterType"].ToString();
             this.DGV_MeterInfo.Rows[i].Cells["MeterIcState"].Value    = dr["MeterIcState"].ToString();
             this.DGV_MeterInfo.Rows[i].Cells["MeterChuState"].Value   = dr["MeterChuState"].ToString();
             this.DGV_MeterInfo.Rows[i].Cells["MeterComState"].Value   = dr["MeterComState"].ToString();
             this.DGV_MeterInfo.Rows[i].Cells["MeterZhongState"].Value = dr["MeterZhongState"].ToString();
             this.DGV_MeterInfo.Rows[i].Cells["MeterState"].Value      = dr["MeterState"].ToString();
             this.DGV_MeterInfo.Rows[i].Cells["MeterTest"].Value       = dr["MeterTest"].ToString();
             this.DGV_MeterInfo.Rows[i].Cells["MeterTime"].Value       = ((DateTime)dr["MeterTime"]).ToString("MM-dd HH:mm");
             this.DGV_MeterInfo.Rows[i].Cells["MeterCancel"].Value     = dr["MeterCancel"].ToString().Equals("否") ? false : true;
             this.DGV_MeterInfo.Rows[i].Cells["MeterPrivilege"].Value  = dr["MeterPrivilege"].ToString().Equals("0") ? false : true;
         }
         DGV_MeterInfo.ClearSelection();
         Change_st(DGV_MeterInfo);
         DGV_MeterInfo.AllowUserToAddRows = false;
     }
 }
Exemple #2
0
 private void PlatManger_MouseDown(object sender, MouseEventArgs e)
 {
     DGV_MeterInfo.ClearSelection();
     DGV_plat.ClearSelection();
     if (der != null)
     {
         der.Close();
     }
     // Showmsg("pp");
 }
Exemple #3
0
        private void PlatManger_Load(object sender, EventArgs e)
        {
            try
            {
                // TODO: 这行代码将数据加载到表“myDataSet.Dt_success”中。您可以根据需要移动或删除它。
                this.dt_PlateInfoTableAdapter.Fill(this.myDataSet.Dt_PlateInfo);
                ChangeMeter();
                // TODO: 这行代码将数据加载到表“myDataSet.Dt_MeterInfo”中。您可以根据需要移动或删除它。
                //  this.dt_MeterInfoTableAdapter.Fill(this.myDataSet.Dt_MeterInfo);
                //  this.dT_ResultTableAdapter.Fill(this.myDataSet.DT_Result,"完成");
                // this.dT_BHGTableAdapter.Fill_BHG(this.myDataSet.DT_BHG, "不合格");
                // this.dT_SBTableAdapter.Fill_SB(this.myDataSet.DT_SB, "失败");
            }
            catch (Exception)
            {
                MessageBox.Show("数据库连接异常");
            }

            DGV_MeterInfo.AllowUserToAddRows = false;
            DGV_plat.AllowUserToAddRows      = false;

            DGV_MeterInfo.ClearSelection();
            DGV_plat.ClearSelection();
            DGV_HG.ClearSelection();
            DGV_BHG.ClearSelection();
            DGV_SB.ClearSelection();
            fc = new FormControl(this);
            fc.GetInit(this, fc);

            this.formStartX = this.Width;
            this.formStartY = this.Height;

            Change_st(DGV_MeterInfo);
            Change_pl(DGV_plat);

            if (OpenServer())
            {
                SetBtsetext("关闭服务", Color.Black);
                Lisenter();
            }

            Dictionary <string, HeartInfo> h  = CommonFunction.hearts;
            Dictionary <int, PlatInfo>     he = CommonFunction.platInfos;
        }
Exemple #4
0
        private void Search_Load(object sender, EventArgs e)
        {
            if (!MysqlHepler.SqlOpen())
            {
                MessageBox.Show("数据库连接失败!");
            }
            string    sql = "Select * From mygas_manufacture";
            DataTable dt  = MysqlHepler.SqlReturnDs(sql).Tables[0];

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                CLB_changjia.Items.Add(dt.Rows[i]["ManufactureName"].ToString());
                manufacture[dt.Rows[i]["id"].ToString()] = dt.Rows[i]["ManufactureName"].ToString();
            }
            DGV_MeterInfo.Visible = true;
            DGV_result.Visible    = false;
            DGV_MeterInfo.ClearSelection();
            DGV_result.ClearSelection();
            AutoSizeColumn(DGV_result);
            AutoSizeColumn(DGV_MeterInfo);
        }
Exemple #5
0
 private void DGV_MeterInfo_Leave(object sender, EventArgs e)
 {
     DGV_MeterInfo.ClearSelection();
 }
Exemple #6
0
 private void TP_result_MouseDown(object sender, MouseEventArgs e)
 {
     DGV_MeterInfo.ClearSelection();
     DGV_result.ClearSelection();
     CLB_changjia.SelectedItems.Clear();
 }