private void RunQuery(string filter) { var usages = AmmeterDB.LoadAmmeterUsage(filter); this.dataGridView1.AutoGenerateColumns = true; //this.dataGridView1. bindingSource1.DataSource = (usages as DataSet).Tables[0]; this.dataGridView1.DataSource = bindingSource1; }
private void button_OK_Click(object sender, EventArgs e) { try { var cmd = CreateUpdateSql(); AmmeterDB.ExcuteSql(cmd); } catch (System.Exception ex) { MessageBox.Show(ex.ToString()); } }
void menuItem_CloneAdd_Click(object sender, EventArgs e) { //throw new NotImplementedException(); FormAmmAdd form = new FormAmmAdd(); form.CurrentData = (P_AmmeterInfo)this.SelectedNode.Tag; // form.ShowDialog(this); if (form.ShowDialog() == DialogResult.OK) { this.LoadData(AmmeterDB.LoadAmmInfoFromDatabase()); } }
void button_OK_Click(object sender, EventArgs e) { try { string sql = string.Format("DELETE from AMMETERINFO where RowID = {0}", this.CurrentData.ROWID); AmmeterDB.ExcuteSql(sql); this.DialogResult = System.Windows.Forms.DialogResult.OK; this.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
void toolStripLoadData(object sender, EventArgs e) { this.autoToolStrip1.Enabled = false; try { var results = AmmeterDB.LoadAmmInfoFromDatabase(); treeView_Ammeter.ClearData(); this.treeView_Ammeter.AddData(results); this.treeView_Ammeter.BuildTree(); } finally { this.autoToolStrip1.Enabled = true; } }
private void button_OK_Click(object sender, EventArgs e) { var cmd = CreateInsertSql(); try { Debug.Write(cmd); AmmeterDB.ExcuteSql(cmd); this.DialogResult = DialogResult.OK; MessageBox.Show("添加成功"); // this.Close(); } catch (System.Exception ex) { MessageBox.Show(ex.ToString()); } }
private void OpeNode(DataOpeMode ope) { if (this.SelectedNode != null) { var groupnode = this.SelectedNode.Tag as LevelBase; if (groupnode != null) { FormNodeModifyDelete form = new FormNodeModifyDelete(); form.Ope = ope; form.Info = this.SelectedNode.Tag as LevelBase; if (form.ShowDialog() == DialogResult.OK) { this.LoadData(AmmeterDB.LoadAmmInfoFromDatabase()); } } else { if (ope == DataOpeMode.Del) { FormAmmDel form = new FormAmmDel(); form.CurrentData = (P_AmmeterInfo)this.SelectedNode.Tag; // form.ShowDialog(this); if (form.ShowDialog() == DialogResult.OK) { this.LoadData(AmmeterDB.LoadAmmInfoFromDatabase()); } } else if (ope == DataOpeMode.Mod) { FormAmmMod form = new FormAmmMod(); form.CurrentData = (P_AmmeterInfo)this.SelectedNode.Tag; // form.ShowDialog(this); if (form.ShowDialog() == DialogResult.OK) { this.LoadData(AmmeterDB.LoadAmmInfoFromDatabase()); } } } } }
private void button_OK_Click(object sender, EventArgs e) { try { var cmd = CreateUpdateSql(); Debug.Write(cmd); AmmeterDB.ExcuteSql(cmd); MessageBox.Show("修改成功"); // if (this.chkKeepWWindow.Checked != true) { this.DialogResult = System.Windows.Forms.DialogResult.OK; this.Close(); } } catch (System.Exception ex) { MessageBox.Show(ex.ToString()); } }
private void button_OK_Click(object sender, EventArgs e) { string sql = string.Empty; if (this.editField1.Changed || this._ope == DataOpeMode.Del || this.comboField_phase.Changed) { if (MessageBox.Show(null, "确定修改?\r\n(修改完数据请最好重新启动应用程序重新加载数据)", "warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { if (L0companynode != null) { var cur = L0companynode; sql = string.Format("update AMMETERINFO set USER_COMPANY = '{0}' where user_company= '{1}'", this.editField1.Result, cur.Company); } if (L1stationnode != null) { var cur = L1stationnode; sql = string.Format("update AMMETERINFO set USER_STATION = '{0}' where user_company= '{1}' and USER_STATION = '{2}'", this.editField1.Result, cur.Company, cur.Station); } if (L2busnode != null) { var cur = L2busnode; sql = string.Format("update AMMETERINFO set USER_BUS = '{0}' where user_company= '{1}' and USER_STATION = '{2}' and USER_BUS = '{3}'", this.editField1.Result, cur.Company, cur.Station, cur.Bus); } if (L3linenode != null) { var cur = L3linenode; sql = string.Format("update AMMETERINFO set USER_LINENAME = '{0}' where user_company= '{1}' and USER_STATION = '{2}' and USER_BUS='{3}' and USER_LINENAME='{4}'", this.editField1.Result, cur.Company, cur.Station, cur.Bus, cur.Line); } if (L4transinfo != null) { var cur = L4transinfo; sql = string.Format("update AMMETERINFO set USER_TRANSFORMER = '{0}' where user_company= '{1}' and USER_STATION = '{2}' and USER_BUS='{3}' and USER_LINENAME = '{4}' and USER_TRANSFORMER = '{5}' ", this.editField1.Result, cur.Company, cur.Station, cur.Bus, cur.Line, cur.Tranformer); } if (L5moduleinfo != null) { var cur = L5moduleinfo; sql = string.Format("update AMMETERINFO set USER_MODULE = '{0}', user_phase = {7} where user_company= '{1}' and USER_STATION = '{2}' and USER_BUS='{3}' and USER_LINENAME = '{4}' and USER_TRANSFORMER = '{5}'and USER_MODULE = '{6}' ", this.editField1.Result, cur.Company, cur.Station, cur.Bus, cur.Line, cur.Tranformer, cur.Module, this.comboField_phase.Result); } try { if (this._ope == DataOpeMode.Del) { sql = "delete from AMMETERINFO " + sql.Substring(sql.IndexOf("where")); } AmmeterDB.ExcuteSql(sql); this.DialogResult = DialogResult.OK; this.Close(); } catch (System.Exception ex) { MessageBox.Show(ex.ToString(), "错误"); } } } }