private void textBoxContainButton2_Click(object sender, EventArgs e) { TextBoxContainButton _txt = (TextBoxContainButton)sender; if (LoginInfo._ZT_Admin_Id == "Z") { _txt.Text = CommomHelper.GetQuery("Role", ""); } else { string _where = "and UsrRole.Usr_id='" + LoginInfo._Usr_id + "'"; _txt.Text = CommomHelper.GetQuery("UsrRole", _where); } }
void btn_Click(object sender, EventArgs e) { int _ColumnIndex = dataGridView1.CurrentCell.ColumnIndex; int _RowIndex = dataGridView1.CurrentCell.RowIndex; DataGridViewColumn _column = dataGridView1.Columns[_ColumnIndex]; BindingSource _bdSource = new BindingSource(); _bdSource = dataGridView1.DataSource as BindingSource; if (_column.DataPropertyName == "Warehouse_Id") { string _columns = " ID=Warehouse_Id,Desc_01=Desc_01 "; string _id = ""; if (LoginInfo._ZT_Admin_Id == "Z") { _id = CommomHelper.GetQuery("Warehouse", _columns, ""); } else { string _where = "and Warehouse.Company_Id='" + LoginInfo._Usr_Company + "' And (Status_Id In ('130', '130')) And Is_Lowest='T'"; _id = CommomHelper.GetQuery("Warehouse", _columns, _where); } this.dataGridView1.Rows[_RowIndex].Cells[_ColumnIndex].Value = _id; _bdSource.EndEdit(); } else if (_column.DataPropertyName == "Item_Id") { string _columns = " ID=Item_Id,Desc_01=Desc_01 "; string _where = "and Item.Company_Id='" + LoginInfo._Usr_Company + "' And (Status_Id In ('130', '130')) And Is_Lowest='T'"; string _id = CommomHelper.GetQuery("Item", _columns, _where); this.dataGridView1.Rows[_RowIndex].Cells[_ColumnIndex].Value = _id; _bdSource.EndEdit(); } else if (_column.DataPropertyName == "ItemUnit_Id") { string _columns = " ID=ItemUnit_Id,Desc_01=ItemUnit_Id "; // string _where = " And (Status_Id In ('130', '130')) "; string _id = CommomHelper.GetQuery("ItemUnit", _columns, ""); this.dataGridView1.Rows[_RowIndex].Cells[_ColumnIndex].Value = _id; _bdSource.EndEdit(); } else if (_column.DataPropertyName == "Project_Id") { string _columns = " ID=Project_Id,Desc_01=Desc_01 "; string _where = "and Company_Id='" + LoginInfo._Usr_Company + "' And (Status_Id In ('130', '130')) "; string _id = CommomHelper.GetQuery("Project", _columns, _where); this.dataGridView1.Rows[_RowIndex].Cells[_ColumnIndex].Value = _id; _bdSource.EndEdit(); } else if (_column.DataPropertyName == "PackageMethod_Id") { string _where = "and (Status_Id In (''130'', ''130'')) "; string _columns = " ID=PackageMethod_Id,Desc_01=Desc_01 "; string _id = CommomHelper.GetQuery("PackageMethod", _columns, _where); this.dataGridView1.Rows[_RowIndex].Cells[_ColumnIndex].Value = _id; _bdSource.EndEdit(); } else if (_column.DataPropertyName == "Ewm_Id") //序列号和二维码 { if (!string.IsNullOrEmpty(this.CsvPo_Id.Text) && !string.IsNullOrEmpty(this.dataGridView1.Rows[_RowIndex].Cells["ItemPrpty_Id"].Value.ToString())) { ShippingInfoEwmManage _EwmManage = new ShippingInfoEwmManage(); _EwmManage.Edit = _Edit; _EwmManage.Shipping_Id = this.Shipping_Id.Text; _EwmManage.Company_Id = LoginInfo._Usr_Company; _EwmManage.CsvPo_Id = this.CsvPo_Id.Text; _EwmManage.ItemPrpty_Id = this.dataGridView1.Rows[_RowIndex].Cells["ItemPrpty_Id"].Value.ToString(); _EwmManage.qty = this.dataGridView1.Rows[_RowIndex].Cells["Qty"].Value.ToString(); _EwmManage.itemUt = String.IsNullOrEmpty(this.dataGridView1.Rows[_RowIndex].Cells["ItemUnit_Id"].Value.ToString()) ? "" : this.dataGridView1.Rows[_RowIndex].Cells["ItemUnit_Id"].Value.ToString(); _EwmManage.Body1_Tbl_Name = Body1_Tbl_Name; if (_EwmManage.ShowDialog() != DialogResult.OK) { } } else { MessageBox.Show("客户PO和型号必须输入!"); } } else if (_column.DataPropertyName == "snc") //SNC导入导出 { if (string.IsNullOrEmpty(this.CsvPo_Id.Text) || string.IsNullOrEmpty(this.dataGridView1.Rows[_RowIndex].Cells["ItemPrpty_Id"].Value.ToString()) || string.IsNullOrEmpty(this.dataGridView1.Rows[_RowIndex].Cells["Qty"].Value.ToString())) { MessageBox.Show("客户PO和型号、数量必须输入!"); return; } Form3 f3 = new Form3(); f3.PO = this.CsvPo_Id.Text; f3.SEL = this.dataGridView1.Rows[_RowIndex].Cells["ItemPrpty_Id"].Value.ToString(); f3.QTY = this.dataGridView1.Rows[_RowIndex].Cells["Qty"].Value.ToString(); f3.input = this.dataGridView1.Rows[_RowIndex].Cells["Src_Input_Id"].Value.ToString(); if (f3.ShowDialog() != DialogResult.OK) { } } }
private void textBoxContainButton1_Click(object sender, EventArgs e) { TextBoxContainButton _txt = (TextBoxContainButton)sender; _txt.Text = CommomHelper.GetQuery("Usr1", ""); }