private void FillDS() { if (ds != null && ds.Tables.Count > 0) { _dataGrid.DataSource = ds.Tables[0]; List <string> l = new List <string>(); foreach (DataGridViewColumn col in _dataGrid.Columns) { l.Add(col.HeaderText); } int i = 0; foreach (string col in l) { try { System.Data.DataSet dss = myDb.RetriveDataSet("select tname,caption,reftable,refcol from t_dict_column where cname='" + col + "'"); string reft = dss.Tables[0].Rows[0]["reftable"].ToString(); if (reft != "" && (reft.StartsWith("K") || reft.StartsWith("Z") || reft.StartsWith("G"))) { AddComboBoxColumns(dss.Tables[0].Rows[0]["reftable"].ToString(), col, i); } } catch (Exception) { } i++; } foreach (DataGridViewColumn col in _dataGrid.Columns) { try { col.HeaderText = myDb.ExecuteScalar("select Caption from t_dict_column where cname='" + col.HeaderText + "'").ToString(); // 中文字段名 } catch (Exception) { } } _dataGrid.AutoResizeColumns(); _dataGrid.Columns[0].Frozen = true; if (_dataGrid.Rows.Count > 0 && _listResult.FindItemWithText(cbCheck.Text) == null) //加入记录list { ListViewItem item = new ListViewItem(); item.Text = cbCheck.Text; item.SubItems.Add(sql); item.SubItems.Add(_dataGrid.Rows.Count.ToString()); item.SubItems.Add(cbType.Text); _listResult.Items.Add(item); } } pb.Visible = false; _msgBox.Text = msgFile.ReadString(cbType.Text, cbCheck.Text, ""); }
private void cbCheck_SelectedIndexChanged(object sender, EventArgs e) { sql = chkFile.ReadString(cbType.Text, cbCheck.Text, ""); if (cbYear.Text != "") { sql = sql.Replace("$", cbYear.Text); } if (sql.IndexOf("UPDATE") >= 0 || sql.IndexOf("DELETE") >= 0) { if (MessageBox.Show("当前检查对原始数据有修改,是否执行?\r\n" + cbCheck.Text, "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { OnCheck(); } else { return; } } OnCheck(); }
private void cbCheck_SelectedIndexChanged(object sender, EventArgs e) { sql = chkFile.ReadString(cbType.Text, cbCheck.Text, ""); OnCheck(); }