public OCA.Common.DataSets.Public GetCompanyInfo() { sda = new SqlDataAdapter(" select * from Tbl_Organiztion where OrgID = 1", conn); try { dspub.Clear(); if (conn.State == ConnectionState.Closed) { conn.Open(); } sda.Fill(dspub.Tbl_Organiztion); return(dspub); } catch { throw new Exception("خطا در ارتباط با بانک اطلاعاتی!"); } finally { conn.Close(); } }
private void Load_Chart() { try { TreeNode baseNode = new TreeNode(""); dspub.Clear(); dspub = puclass.GetCompanyInfo(); baseNode.Text = dspub.Tbl_Organiztion[0].OrganiztionName; CmbUpUnit.Items.Clear(); CmbUpUnit.Items.Add(dspub.Tbl_Organiztion[0].OrganiztionName); txtUnitName.Clear(); dsunit.Clear(); dsunit = unitclass.GetUnits(); for (int i = 1; i <= dsunit.Tbl_Unit.Rows.Count; i++) { InsertTree(baseNode, dsunit.Tbl_Unit[i - 1].UnitName.Trim(), dsunit.Tbl_Unit[i - 1].UpperUnit.Trim()); CmbUpUnit.Items.Add(dsunit.Tbl_Unit[i - 1].UnitName.Trim()); } treeView1.Nodes.Clear(); treeView1.Nodes.Add(baseNode); treeView1.ExpandAll(); CmbUpUnit.SelectedIndex = 0; } catch (Exception ex) { mesg.Error("خطا", ex.Message); } }
public OCA.Common.DataSets.Public GetCompanyInfo() { try { dspub.Clear(); dspub = pubclass.GetCompanyInfo(); return(dspub); } catch (Exception ex) { throw new Exception(ex.Message); } }
private void CompanyInfo_Load(object sender, EventArgs e) { dspub.Clear(); dspub = pubclass.GetCompanyInfo(); txtOrganiztionName.Text = dspub.Tbl_Organiztion[0].OrganiztionName; try { txtTel1.Text = dspub.Tbl_Organiztion[0].Tel1; } catch { } try { txtTel2.Text = dspub.Tbl_Organiztion[0].Tel2; } catch { } try { txtTel3.Text = dspub.Tbl_Organiztion[0].Tel3; } catch { } try { txtFax1.Text = dspub.Tbl_Organiztion[0].Fax1; } catch { } try { txtFax2.Text = dspub.Tbl_Organiztion[0].Fax2; } catch { } try { txtAddress1.Text = dspub.Tbl_Organiztion[0].Address1; } catch { } try { txtAddress2.Text = dspub.Tbl_Organiztion[0].Address2; } catch { } try { MemoryStream mstrm = new MemoryStream(dspub.Tbl_Organiztion[0].LogoImage); PicLogoImage.Image = Image.FromStream(mstrm); } catch { } }