private void EcodeSearch()
{
objServicedb = new ServiceDeptDB();
DataSet dsEmp = null;
if (cbBranches.SelectedIndex > 0)
{
try
{
string[] strBranCode = cbBranches.SelectedValue.ToString().Split('@');
Cursor.Current = Cursors.WaitCursor;
cbEcode.DataSource = null;
cbEcode.Items.Clear();
dsEmp = objServicedb.ServiceLevelEcodeSearch_Get(cbCompany.SelectedValue.ToString(), strBranCode[0], CommonData.DocMonth, txtEcodeSearch.Text.ToString());
DataTable dtEmp = dsEmp.Tables[0];
if (dtEmp.Rows.Count > 0)
{
cbEcode.DataSource = dtEmp;
cbEcode.DisplayMember = "ENAME";
cbEcode.ValueMember = "ECODE";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (cbEcode.SelectedIndex > -1)
{
cbEcode.SelectedIndex = 0;
strECode = ((System.Data.DataRowView)(cbEcode.SelectedItem)).Row.ItemArray[0].ToString();
}
objServicedb = null;
Cursor.Current = Cursors.Default;
}
}
}
private void FillEmployeeData(string sCompCode, string sBranCode)
{
objServicedb = new ServiceDeptDB();
DataSet dsEmp = null;
if (sCompCode.Length > 0 && sBranCode.Length > 0)
{
try
{
Cursor.Current = Cursors.WaitCursor;
cbEcode.DataSource = null;
cbEcode.Items.Clear();
dsEmp = objServicedb.ServiceLevelEcodeSearch_Get(sCompCode, sBranCode, CommonData.DocMonth, txtEcodeSearch.Text.ToString());
DataTable dtEmp = dsEmp.Tables[0];
if (dtEmp.Rows.Count > 0)
{
cbEcode.DataSource = dtEmp;
cbEcode.DisplayMember = "ENAME";
cbEcode.ValueMember = "ECODE";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (cbEcode.SelectedIndex > -1)
{
cbEcode.SelectedIndex = 0;
strECode = ((System.Data.DataRowView)(cbEcode.SelectedItem)).Row.ItemArray[0].ToString();
}
objServicedb = null;
Cursor.Current = Cursors.Default;
}
}
}
