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); } }
/// <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(); }