private void textBoxContainButton1_Click(object sender, EventArgs e) { TextBoxContainButton _txt = (TextBoxContainButton)sender; string _columns = " ID=ShippingAddress_ID,Desc_01=Desc_01 "; Dictionary <string, object> _ht = new Dictionary <string, object>(); if (LoginInfo._ZT_Admin_Id == "Z") { _ht = CommomHelper.GetQuery1("ShippingAddress", _columns, "And isnull(ShippingAddress_Id,'')<>'" + this.txtDepNo.Text + "'"); } else { string _where = "and ShippingAddress.Company_Id='" + LoginInfo._Usr_Company + "' And (Status_Id In ('130', '130')) And isnull(ShippingAddress_Id,'')<>'" + this.txtDepNo.Text + "'"; _ht = CommomHelper.GetQuery1("ShippingAddress", _columns, _where); } if (_ht != null) { if (_ht.ContainsKey("ID") && _ht.ContainsKey("DESC")) { _txt.ID = _ht["ID"].ToString(); _txt.Desc = _ht["DESC"].ToString(); _txt.Text = _ht["DESC"].ToString(); } } }
private void textBoxContainButton2_Click(object sender, EventArgs e) { TextBoxContainButton _txt = (TextBoxContainButton)sender; Dictionary <string, object> _ht = new Dictionary <string, object>(); if (LoginInfo._ZT_Admin_Id == "Z") { string _columns = " ID=Role_ID,Desc_01=Desc_01 "; _ht = CommomHelper.GetQuery1("Role", _columns, ""); } else { string _columns = " ID=Role_ID,Desc_01=Role_ID "; string _where = "and UsrRole.Usr_id='" + LoginInfo._Usr_id + "'"; _ht = CommomHelper.GetQuery1("UsrRole", _columns, _where); } if (_ht != null) { if (_ht.ContainsKey("ID") && _ht.ContainsKey("DESC")) { _txt.ID = _ht["ID"].ToString(); _txt.Desc = _ht["DESC"].ToString(); _txt.Text = _ht["DESC"].ToString(); } } }
private void textBoxContainButton1_Click(object sender, EventArgs e) { TextBoxContainButton _txt = (TextBoxContainButton)sender; string _columns = " ID=Warehouse_Id,Desc_01=Desc_01 "; Dictionary <string, object> _ht = new Dictionary <string, object>(); if (LoginInfo._ZT_Admin_Id == "Z") { _ht = CommomHelper.GetQuery1("Warehouse", _columns, "and Warehouse_Id not in('" + this.txtNo.Text + "') "); } else { string _where = "and Warehouse.Company_Id='" + LoginInfo._Usr_Company + "' and Warehouse_Id not in('" + this.txtNo.Text + "')"; _ht = CommomHelper.GetQuery1("Warehouse", _columns, _where); } if (_ht != null) { if (_ht.ContainsKey("ID") && _ht.ContainsKey("DESC")) { _txt.ID = _ht["ID"].ToString(); _txt.Desc = _ht["DESC"].ToString(); _txt.Text = _ht["DESC"].ToString(); } } }
private void textBoxContainButton1_Click(object sender, EventArgs e) { TextBoxContainButton _txt = (TextBoxContainButton)sender; string _columns = " ID=Notify_Id,Desc_01=Notify_Id "; Dictionary <string, object> _ht = new Dictionary <string, object>(); if (LoginInfo._ZT_Admin_Id == "Z") { _ht = CommomHelper.GetQuery1("TaskNotifyOrder", _columns, ""); } else { string _where = "and TaskNotifyOrder.Company_Id='" + LoginInfo._Usr_Company + "'"; _ht = CommomHelper.GetQuery1("TaskNotifyOrder", _columns, _where); } if (_ht != null) { if (_ht.ContainsKey("ID") && _ht.ContainsKey("DESC")) { _txt.ID = _ht["ID"].ToString(); _txt.Desc = _ht["DESC"].ToString(); _txt.Text = _ht["DESC"].ToString(); } } }
private void textBoxContainButton2_Click(object sender, EventArgs e) { TextBoxContainButton _txt = (TextBoxContainButton)sender; string _columns = " ID=Employee_ID,Desc_01=Desc_01 "; Dictionary <string, object> _ht = new Dictionary <string, object>(); string PgmName = "Employee"; if (_txt.Name == "Recipient_Employee_Ids" || _txt.Name == "CC_Employee_Ids") { PgmName = "Employee_MutSelect"; } if (LoginInfo._ZT_Admin_Id == "Z") { _ht = CommomHelper.GetQuery1(PgmName, _columns, ""); } else { string _where = "and Employee.Company_Id='" + LoginInfo._Usr_Company + "' And (Status_Id In ('130', '130'))"; _ht = CommomHelper.GetQuery1(PgmName, _columns, _where); } if (_ht != null) { if (_ht.ContainsKey("ID") && _ht.ContainsKey("DESC")) { _txt.ID = _ht["ID"].ToString(); _txt.Desc = _ht["DESC"].ToString(); _txt.Text = _ht["DESC"].ToString(); } } }
private void textBoxContainButton1_Click(object sender, EventArgs e) { TextBoxContainButton _txt = (TextBoxContainButton)sender; string _columns = " ID=ProjectStage_Id,Desc_01=Desc_01 "; string _where = "AND isnull(ProjectStage_Id,'')<>'" + this.txtNo.Text + "'"; Dictionary <string, object> _ht = new Dictionary <string, object>(); if (LoginInfo._ZT_Admin_Id == "Z") { _ht = CommomHelper.GetQuery1("ProjectStage", _columns, _where); } else { _ht = CommomHelper.GetQuery1("ProjectStage", _columns, _where); } if (_ht != null) { if (_ht.ContainsKey("ID") && _ht.ContainsKey("DESC")) { _txt.ID = _ht["ID"].ToString(); _txt.Desc = _ht["DESC"].ToString(); _txt.Text = _ht["DESC"].ToString(); } } }
private void textBoxContainButton3_Click(object sender, EventArgs e) { TextBoxContainButton _txt = (TextBoxContainButton)sender; string _columns = " ID=ItemKind_ID,Desc_01=Desc_01 "; Dictionary <string, object> _ht = new Dictionary <string, object>(); if (LoginInfo._ZT_Admin_Id == "Z") { _ht = CommomHelper.GetQuery1("ItemKind", _columns, " And (Status_Id In ('130', '130')) "); } else { string _where = "and Department.Company_Id='" + LoginInfo._Usr_Company + "' And (Status_Id In ('130', '130'))"; _ht = CommomHelper.GetQuery1("ItemKind", _columns, _where); } if (_ht != null) { if (_ht.ContainsKey("ID") && _ht.ContainsKey("DESC")) { _txt.ID = _ht["ID"].ToString(); _txt.Desc = _ht["DESC"].ToString(); _txt.Text = _ht["DESC"].ToString(); } } }
private void textBoxContainButton2_Click(object sender, EventArgs e) { TextBoxContainButton _txt = (TextBoxContainButton)sender; string _columns = " ID=Collection_Id,Desc_01=Collection_Id "; Dictionary <string, object> _ht = CommomHelper.GetQuery1("RequestCollectionOrder", _columns, ""); if (_ht.ContainsKey("ID") && _ht.ContainsKey("DESC")) { _txt.ID = _ht["ID"].ToString(); _txt.Desc = _ht["DESC"].ToString(); _txt.Text = _ht["DESC"].ToString(); } }
private void textBoxContainButton1_Click(object sender, EventArgs e) { TextBoxContainButton _txt = (TextBoxContainButton)sender; string _columns = " ID=ItemUt_ID,Desc_01=Desc_01 "; Dictionary <string, object> _ht = new Dictionary <string, object>(); _ht = CommomHelper.GetQuery1("ItemUt", _columns, ""); if (_ht != null) { if (_ht.ContainsKey("ID") && _ht.ContainsKey("DESC")) { _txt.ID = _ht["ID"].ToString(); _txt.Desc = _ht["DESC"].ToString(); _txt.Text = _ht["DESC"].ToString(); } } }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0 && e.ColumnIndex >= 0) { DataGridViewColumn _column = dataGridView1.Columns[e.ColumnIndex]; BindingSource _bdSource = new BindingSource(); _bdSource = dataGridView1.DataSource as BindingSource; if (_column.DataPropertyName == "ItemUnit_Id") { string _columns = " ID=ItemUt_ID,Desc_01=Desc_01 "; string _where = "and (Status_Id In ('130', '130')) and ItemUt_Id not in ('" + _ItemUtId + "')"; Dictionary <string, object> _ht = CommomHelper.GetQuery1("ItemUt", _columns, _where); if (_ht != null) { if (_ht.ContainsKey("ID") && _ht.ContainsKey("DESC")) { this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = _ht["ID"].ToString(); _bdSource.EndEdit(); } } } } }