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=Usr_ID,Desc_01=Name "; Dictionary <string, object> _ht = new Dictionary <string, object>(); _ht = CommomHelper.GetQuery1("Usr1", _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 textBoxContainButton1_Click(object sender, EventArgs e) { TextBoxContainButton _txt = (TextBoxContainButton)sender; string _where = "and UsrCompany1.Usr_id='" + txtUsr.Text + "'"; string _columns = " ID=Usr_Id,Desc_01=Usr_Id "; Dictionary <string, object> _ht = new Dictionary <string, object>(); _ht = CommomHelper.GetQuery1("UsrCompany1", _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 _company_id = string.IsNullOrEmpty(this.textBoxContainButton1.ID) ? "" : this.textBoxContainButton1.ID; string _where = "and UsrRole.Usr_id='" + txtUsr.Text + "' and UsrRole.Company_Id='" + _company_id + "' "; string _columns = " ID=Role_Id,Desc_01=Role_Id "; Dictionary <string, object> _ht = new Dictionary <string, object>(); _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(); } } }