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 { }
}
