private void button2_Click(object sender, EventArgs e) { Task.Factory.StartNew(() => { LoadForm.ShowLoading(this); try { var mongoTool = MongoDBTool.Connect(connectStr); var dataBaseNames = mongoTool.GetDataBases(); var dataBaseName = ""; if (dataBaseNames != null && dataBaseNames.Any()) { if (System.Linq.Enumerable.Count(dataBaseNames) == 1) { dataBaseName = dataBaseNames.First(); } else { dataBaseName = "all"; } } this.Invoke(new Action(() => { Connection connectionModel = new Connection(); connectionModel.Database = dataBaseName; connectionModel.ID = Guid.NewGuid(); connectionModel.Name = mongoTool.ServerInfo + "(MongoDB)[" + connectionModel.Database + "]"; connectionModel.DbType = DatabaseType.MongoDB.ToString(); connectionModel.ConnectionString = connectStr; UtilsHelper.AddConnection(connectionModel); this.DialogResult = DialogResult.OK; this.Close(); })); } catch (Exception ex) { MessageBox.Show("连接失败!\n\r" + ex.Message); } LoadForm.HideLoading(); }); }
//构造函数接收传入的ListView子项类型 public ModifyUserInfo(ListViewItem.ListViewSubItemCollection listViewSubItem) { InitializeComponent(); this.Text = LoadForm.TextList[int.Parse(this.Tag.ToString())]; LoadForm.LoadText(this); conn = Program.ConDataBase(); cmd = new MySqlCommand(); cmd.Connection = conn; //查询并设置会员等级选项 string sql = "select name from user_rank order by discount_rate desc"; cmd = new MySqlCommand(sql, conn); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string data = reader[0].ToString(); user_rank_cbb.Items.Add(data); } cmd.Dispose(); reader.Close(); //查询并设置会员状态选项 sql = "select name from user_status"; cmd = new MySqlCommand(sql, conn); reader = cmd.ExecuteReader(); while (reader.Read()) { string data = reader[0].ToString(); user_status_cbb.Items.Add(data); } cmd.Dispose(); reader.Close(); //通过接收的ListView子项显示当前选中的会员信息 id = int.Parse(listViewSubItem[0].Text); name_txb.Text = listViewSubItem[1].Text; sex_cbb.Text = listViewSubItem[2].Text; tel_txb.Text = listViewSubItem[3].Text; user_rank_cbb.Text = listViewSubItem[8].Text; user_status_cbb.Text = listViewSubItem[9].Text; expired_time_dtp.Value = Convert.ToDateTime(listViewSubItem[12].Text.ToString()); remarks_txb.Text = listViewSubItem[13].Text; }
public static void Init() { string constring = "server=db4free.net;port=3306;database=tictactoecl;user=admincl;password=myadmin"; connection = new MySqlConnection(constring); try { Connect(); LoadForm load = new LoadForm(); load.ShowDialog(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//构造函数接收传入的ListView子项类型 public ModifyUserRank(ListViewItem.ListViewSubItemCollection listViewSubItem, string first_rank_name) { InitializeComponent(); this.Text = LoadForm.TextList[int.Parse(this.Tag.ToString())]; LoadForm.LoadText(this); conn = Program.ConDataBase(); cmd = new MySqlCommand(); cmd.Connection = conn; id = listViewSubItem[0].Tag.ToString(); //设置当前选中会员等级的id this.first_rank_name = first_rank_name; //设置传入的第一个等级的名称 rank_name = listViewSubItem[0].Text; rank_name_txb.Text = listViewSubItem[0].Text; discount_rate_txb.Text = listViewSubItem[1].Text; }
//构造函数接收传入的是否正在选择供应商bool值 public SupplierManage(bool isSelectingSupplier) { InitializeComponent(); this.Text = LoadForm.TextList[int.Parse(this.Tag.ToString())]; LoadForm.LoadText(this); conn = Program.ConDataBase(); cmd = new MySqlCommand(); cmd.Connection = conn; //如果正在选择供应商,设置新增供应商分区不可用 create_supplier_gpb.Enabled = !isSelectingSupplier; this.isSelectingSupplier = isSelectingSupplier; SelectSupplier("select * from supplier"); }
//构造函数接收传入的ListView子项类型 public UserCharge(ListViewItem.ListViewSubItemCollection listViewSubItem) { InitializeComponent(); this.Text = LoadForm.TextList[int.Parse(this.Tag.ToString())]; LoadForm.LoadText(this); conn = Program.ConDataBase(); cmd = new MySqlCommand(); cmd.Connection = conn; //通过接收的ListView子项显示当前选中的会员信息(不可编辑) id_txb.Text = listViewSubItem[0].Text.ToString(); name_txb.Text = listViewSubItem[1].Text.ToString(); tel_txb.Text = listViewSubItem[3].Text.ToString(); balance_txb.Text = listViewSubItem[5].Text.ToString(); total_num_txb.Text = listViewSubItem[6].Text.ToString(); }
public GoodsList() { InitializeComponent(); this.Text = LoadForm.TextList[int.Parse(this.Tag.ToString())]; LoadForm.LoadText(this); conn = Program.ConDataBase(); cmd = new MySqlCommand(); cmd.Connection = conn; SelectGoods("SELECT g.id, g.`name`, g.type, g.stock_num, g.sold_num, g.sell_price, g.purchase_price, g.stock_time, s.`name` as sName FROM goods as g, supplier as s WHERE g.supplier_id = s.id"); //调用AddNodes方法,传入默认根节点,初始化商品分类树 AddNodes(by_type_tvw.Nodes[0], 1); AddNodes(by_type_tvw.Nodes[1], 2); by_type_tvw.ExpandAll(); }
//构造函数接收传入的ListView子项类型 public ModifySupplierInfo(ListViewItem.ListViewSubItemCollection listViewSubItem) { InitializeComponent(); this.Text = LoadForm.TextList[int.Parse(this.Tag.ToString())]; LoadForm.LoadText(this); conn = Program.ConDataBase(); cmd = new MySqlCommand(); cmd.Connection = conn; //设置各供应商信息为传入的供应商信息 id = int.Parse(listViewSubItem[0].Text); name_txb.Text = listViewSubItem[1].Text; tel_txb.Text = listViewSubItem[2].Text; address_txb.Text = listViewSubItem[3].Text; remarks_txb.Text = listViewSubItem[6].Text; }
private void HomeDelivery_Load(object sender, EventArgs e) { LoadForm.centerForm(this); cbxReceptionEmployee.Text = "Recepcionista"; cbxAtendedEmployee.Text = "Repartidor"; cbxClients.Text = "Clientes"; List <String> nameClients = new List <string>(); foreach (var item in client_Logic.getClient()) { nameClients.Add($"{item.id_client} - {item.first_client} {item.last_client}"); } LoadForm.fillCbx(cbxReceptionEmployee, employee_Logic.getReceptorEmployee()); LoadForm.fillCbx(cbxAtendedEmployee, employee_Logic.getDeliveryEmployee()); LoadForm.fillCbx(cbxClients, nameClients); fillListView(); }
public UserList() { InitializeComponent(); this.Text = LoadForm.TextList[int.Parse(this.Tag.ToString())]; LoadForm.LoadText(this); conn = Program.ConDataBase(); cmd = new MySqlCommand(); cmd.Connection = conn; //显示所有会员 SelectUser("select * from user"); //设置性别默认值 by_sex_cbb.SelectedIndex = 2; //设置TreeView中会员等级节点 string sql = "select name from user_rank order by discount_rate desc"; cmd = new MySqlCommand(sql, conn); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { by_type_tvw.Nodes[0].Nodes.Add(reader[0].ToString()); } cmd.Dispose(); reader.Close(); //设置TreeView中会员状态节点 sql = "select name from user_status"; cmd = new MySqlCommand(sql, conn); reader = cmd.ExecuteReader(); while (reader.Read()) { by_type_tvw.Nodes[1].Nodes.Add(reader[0].ToString()); } cmd.Dispose(); reader.Close(); by_type_tvw.ExpandAll(); }
//构造函数接收传入的是否正在选择商品分类bool值 public SetGoodsType(bool isSelectingType) { InitializeComponent(); this.Text = LoadForm.TextList[int.Parse(this.Tag.ToString())]; LoadForm.LoadText(this); conn = Program.ConDataBase(); cmd = new MySqlCommand(); cmd.Connection = conn; //如果正在选择商品分类,设置编辑商品分类分区不可用 modify_goods_type_gpb.Enabled = !isSelectingType; this.isSelectingType = isSelectingType; ////调用AddNodes方法,传入默认根节点,初始化商品分类树 AddNodes(goods_type_tvw.Nodes[0], 1); AddNodes(goods_type_tvw.Nodes[1], 2); goods_type_tvw.ExpandAll(); }
//构造函数接收传入的ListView子项类型 public ModifyGoodsInfo(ListViewItem.ListViewSubItemCollection listViewSubItem) { InitializeComponent(); this.Text = LoadForm.TextList[int.Parse(this.Tag.ToString())]; LoadForm.LoadText(this); conn = Program.ConDataBase(); cmd = new MySqlCommand(); cmd.Connection = conn; //设置各商品信息为传入的商品信息 id = int.Parse(listViewSubItem[0].Text); goods_name = listViewSubItem[1].Text; goods_name_txb.Text = listViewSubItem[1].Text; select_goods_type_btn.Text = listViewSubItem[2].Text; stock_num_txb.Text = listViewSubItem[3].Text; sell_price_txb.Text = listViewSubItem[5].Text; purchase_price_txb.Text = listViewSubItem[6].Text; select_supplier_btn.Text = listViewSubItem[8].Text; }
private void HomeBill_Load(object sender, EventArgs e) { LoadForm.centerForm(this); string fullName = $"{LoadForm.client.first_client} {LoadForm.client.last_client}"; txtAdress.Text = LoadForm.client.address; txtNIT.Text = LoadForm.client.nit_client.ToString(); txtName.Text = fullName; lblIDUser.Text = LoadForm.client.idDBClient.ToString(); float totalPrice = 0; if (HomeDelivery.ListSaucers.saucers.Count > 0) { foreach (var item in HomeDelivery.ListSaucers.saucers) { string saucer = $"Q.{item.costSaucer} - {item.nameSaucer}\n"; listSaucer.Items.Add(saucer); totalPrice += item.costSaucer; } } lblPrice.Text = $"{totalPrice.ToString()}"; }
/// <summary> /// 确定 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button2_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(cbbServer.Text)) { MessageBox.Show("服务器不能为空!"); return; } if (cbbShenFenRZ.SelectedIndex == 1 && string.IsNullOrEmpty(txtUserName.Text)) { MessageBox.Show("登陆名不能为空!"); return; } string tempconnectionstring = createConnectionString(cbbDatabase.SelectedIndex == 0 ? "master" : cbbDatabase.Text); Task.Factory.StartNew(() => { LoadForm.ShowLoading(this); try { using (SqlConnection conn = new SqlConnection(tempconnectionstring)) { conn.Open(); } LoadForm.HideLoading(); Dictionary <string, string> dic = new Dictionary <string, string>(); this.Invoke(new Action(() => { if (checkBox1.Checked) { var cnnStr = textBox1.Text; var arr1 = cnnStr.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); foreach (var item in arr1) { var arr2 = item.Split(new string[] { "=" }, StringSplitOptions.RemoveEmptyEntries); try { dic.Add(arr2[0].ToLower(), arr2[1].ToLower()); } catch { } } Connection connectionModel = new Connection(); connectionModel.Database = dic["initial catalog"]; connectionModel.ID = Guid.NewGuid(); connectionModel.Name = dic["data source"] + "(" + DatabaseType.SqlServer9.ToString() + ")[" + connectionModel.Database + "]"; connectionModel.DbType = DatabaseType.SqlServer9.ToString(); connectionModel.ConnectionString = tempconnectionstring; UtilsHelper.AddConnection(connectionModel); this.DialogResult = DialogResult.OK; this.Close(); } else { Connection connectionModel = new Connection(); connectionModel.Database = cbbDatabase.SelectedIndex == 0 ? "all" : cbbDatabase.Text; connectionModel.ID = Guid.NewGuid(); connectionModel.Name = cbbServer.Text + "(" + cbbServerType.Text + ")[" + connectionModel.Database + "]"; if (cbbServerType.SelectedIndex == 0) { connectionModel.DbType = DatabaseType.SqlServer.ToString(); } else { connectionModel.DbType = DatabaseType.SqlServer9.ToString(); } connectionModel.ConnectionString = tempconnectionstring; UtilsHelper.AddConnection(connectionModel); this.DialogResult = DialogResult.OK; this.Close(); } })); } catch (Exception ex) { LoadForm.HideLoading(); MessageBox.Show("连接失败!\n\r" + ex.Message); } }); }
private void DeviceInfoForm_Load(object sender, EventArgs e) { LoadForm?.Invoke(sender, e); }
public void RunSql() { var sql = AutoTextBox.TextBox.Text; stopwatch.Restart(); LoadForm.ShowLoading(this); Task.Factory.StartNew(() => { try { WEF.DbDAL.IDbObject dbObject = DBObjectHelper.GetDBObject(ConnectionModel); if (string.IsNullOrEmpty(sql)) { LoadForm.HideLoading(this);; this.Invoke(new Action(() => { MessageBox.Show(this, "sql内容不能为空!"); })); return; } this.Invoke(new Action(() => { if (!string.IsNullOrWhiteSpace(AutoTextBox.TextBox.SelectedText)) { sql = AutoTextBox.TextBox.SelectedText.Trim(); if (string.IsNullOrEmpty(sql)) { LoadForm.HideLoading(this);; MessageBox.Show(this, "sql内容不能为空!"); return; } } dataGridView1.DataSource = null; })); if (sql.IndexOf("select", StringComparison.InvariantCultureIgnoreCase) >= 0) { try { int max = 50; var ds = dbObject.Query(ConnectionModel.Database, sql); if (ds != null && ds.Tables != null) { var dt = ds.Tables[0]; if (dt != null) { var count = dt.Rows.Count; if (count > max) { for (int i = max; i < count; i++) { dt.Rows.RemoveAt(max); } } var dList = new List <int>(); for (int i = 0; i < dt.Columns.Count; i++) { if (dt.Columns[i].DataType == typeof(DateTime)) { dList.Add(i); } } dataGridView1.Invoke(new Action(() => { dataGridView1.DataSource = dt; if (dList.Any()) { foreach (var item in dList) { dataGridView1.Columns[item].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss.fff"; } } lbl_execute.Text = $"当前显示{(max > count ? count : max)}行,影响数据行数:{count} 耗时:{stopwatch.Elapsed.TotalSeconds} 秒"; })); } } LoadForm.HideLoading(this);; } catch (Exception ex) { LoadForm.HideLoading(this);; this.Invoke(new Action(() => { MessageBox.Show(this, $"查询发生异常,ex:" + ex.Message); })); } } else { try { var count = dbObject.ExecuteSql(ConnectionModel.Database, sql); lbl_execute.Invoke(new Action(() => { lbl_execute.Text = $"影响数据行数:{count} 耗时:{stopwatch.Elapsed.TotalMilliseconds} 毫秒"; })); LoadForm.HideLoading(this);; } catch (Exception ex) { LoadForm.HideLoading(this);; this.Invoke(new Action(() => { MessageBox.Show(this, $"操作发生异常,ex:" + ex.Message); })); } } } catch (Exception ex) { this.Invoke(new Action(() => { MessageBox.Show(this, $"操作发生异常,ex:" + ex.Message); })); } }); }
public void Load() { LoadForm?.Invoke(this, new PowerThreadNodeLoadEventArgs()); }
private void condition_2_txb_KeyPress(object sender, KeyPressEventArgs e) { LoadForm.LimitInput(sender, e, 1); }
//限制采购价格文本输入,不允许负数 private void purchase_price_txb_KeyPress(object sender, KeyPressEventArgs e) { LoadForm.LimitInput(sender, e, 0); }
//限制联系方式(新增供应商时)文本输入,不允许负数 private void tel_txb_KeyPress(object sender, KeyPressEventArgs e) { LoadForm.LimitInput(sender, e, 0); }
private void FmDepartmentView_Load(object sender, EventArgs e) { LoadForm?.Invoke(sender, e); }
private void btnFZTest_Click(object sender, EventArgs e) { LoadForm LForm = new LoadForm(); LForm.ShowDialog(); }
//限制充值金额控件输入,不允许负数 private void charge_balance_txb_KeyPress(object sender, KeyPressEventArgs e) { LoadForm.LimitInput(sender, e, 0); }
public FrmMenu() { InitializeComponent(); toolStripStatusLabelDate.Text = DateTime.Now.ToString("dd/MM/yyyy"); lf += new LoadForm(OpenForm); }
private void Saucer_Load(object sender, EventArgs e) { LoadForm.centerForm(this); fillTable(); }
/// <summary> /// 连接 测试 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { if (checkBox1.Checked) { if (string.IsNullOrEmpty(textBox1.Text)) { MessageBox.Show("连接字符串不能为空!"); return; } LoadForm.ShowLoading(this); WEF.DbDAL.IDbObject dbObejct = null; try { dbObejct = new WEF.DbDAL.SQL2000.DbObject(textBox1.Text); } catch (Exception ex) { LoadForm.HideLoading(); MessageBox.Show($"连接测试失败:{ex.Message}"); } if (dbObejct == null) { return; } cbbDatabase.Enabled = false; Task.Factory.StartNew(() => { try { var DBNameTable = dbObejct.GetDBList(); this.Invoke(new Action(() => { cbbDatabase.Items.Clear(); cbbDatabase.Items.Add("全部"); foreach (DataRow dr in DBNameTable.Rows) { cbbDatabase.Items.Add(dr[0].ToString()); } cbbDatabase.Enabled = true; cbbDatabase.SelectedIndex = 0; LoadForm.HideLoading(); MessageBox.Show("连接成功!"); button2.Enabled = true; })); } catch (Exception ex) { LoadForm.HideLoading(); MessageBox.Show("连接失败!\n\r" + ex.Message); } }); } else { if (string.IsNullOrEmpty(cbbServer.Text)) { MessageBox.Show("服务器不能为空!"); return; } if (cbbShenFenRZ.SelectedIndex == 1 && string.IsNullOrEmpty(txtUserName.Text)) { MessageBox.Show("登陆名不能为空!"); return; } LoadForm.ShowLoading(this); WEF.DbDAL.IDbObject dbObejct = new WEF.DbDAL.SQL2000.DbObject(cbbShenFenRZ.SelectedIndex == 0, cbbServer.Text, txtUserName.Text, txtPassword.Text); cbbDatabase.Enabled = false; Task.Factory.StartNew(() => { try { var DBNameTable = dbObejct.GetDBList(); this.Invoke(new Action(() => { cbbDatabase.Items.Clear(); cbbDatabase.Items.Add("全部"); foreach (DataRow dr in DBNameTable.Rows) { cbbDatabase.Items.Add(dr[0].ToString()); } cbbDatabase.Enabled = true; cbbDatabase.SelectedIndex = 0; LoadForm.HideLoading(); MessageBox.Show("连接成功!"); button2.Enabled = true; })); } catch (Exception ex) { LoadForm.HideLoading(); MessageBox.Show("连接失败!\n\r" + ex.Message); } }); } }