public OCA.Common.DataSets.BaseInformation.Unit IsExistUnit(string UnitName)
{
sda = new SqlDataAdapter("SELECT * FROM Tbl_Unit WHERE UnitName = '" + UnitName.Replace("ی", "ي") + "'", conn);
try
{
dsunit.Clear();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
sda.Fill(dsunit.Tbl_Unit);
return(dsunit);
}
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 Boolean IsExistUnit(string UnitName)
{
try
{
dsunit.Clear();
dsunit = unitclass.IsExistUnit(UnitName);
if (dsunit.Tbl_Unit.Rows.Count == 0)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
