Exemple #1
0
 public void btnSaveStatus_Click(object sender, EventArgs e)
 {
     try
     {
         this.BaseFocusLabel.Focus();
         int           DtsID     = 0;
         string        Status    = string.Empty;
         string        sql       = string.Empty;
         int           Num       = 0;
         SampleDtsRule rule      = new SampleDtsRule();
         SampleDts     entityDts = new SampleDts();
         for (int i = 0; i < gridView1.RowCount; i++)
         {
             DtsID  = SysConvert.ToInt32(gridView1.GetRowCellValue(i, "DtsID"));
             Status = SysConvert.ToString(gridView1.GetRowCellValue(i, "EventStatus"));
             sql    = "Update Dev_SampleDts set EventStatus=" + SysString.ToDBString(Status);
             if (entityDts.EventStatus != Status)
             {
                 sql += " where ID=" + DtsID;
                 SysUtils.ExecuteNonQuery(sql);
                 Num++;
             }
         }
         if (Num > 0)
         {
             this.ShowInfoMessage(Num.ToString() + "条状态更新成功");
         }
     }
     catch (Exception E)
     {
         this.ShowMessage(E.Message);
     }
 }
Exemple #2
0
        /// <summary>
        /// 绑定数据明细
        /// </summary>
        public override void BindGridDts()
        {
            SampleDtsRule rule  = new SampleDtsRule();
            DataTable     dtDts = rule.RShow(" AND MainID=" + HTDataID + " ORDER BY Seq", ProcessGrid.GetQueryField(gridView1));

            gridView1.GridControl.DataSource = dtDts;
            gridView1.GridControl.Show();
        }