private void GetBasicEmployeeInfo()
{
DateTime startDate;
DateTime endDate;
Ultis.DatesRange(out startDate, out endDate, month, year);
string text = GenerateEmployeeInfo() + GenerateServiceSession() + GeneratePTCommLevel();
SqlCommand myCmd = new SqlCommand(text);
myCmd.Parameters.Add("@nnEmployeeID", nEmployeeID);
myCmd.Parameters.Add("@dtStartDate", startDate);
myCmd.Parameters.Add("@dtEndDate", endDate);
if (strBranchCode.Length != 0)
{
myCmd.Parameters.Add("@sstrBranchCode", strBranchCode);
}
myDBCommon.SelectDataSet(myCmd, myResultDataSet);
myResultDataSet.Tables[0].TableName = EMPLOYEEINFO;
myResultDataSet.Tables[1].TableName = SERVICESESSION;
myResultDataSet.Tables[2].TableName = PTCOMMLEVEL;
Ultis.AddColumn(myResultDataSet.Tables[EMPLOYEEINFO], "mCommission", "System.Decimal");
Ultis.AddColumn(myResultDataSet.Tables[SERVICESESSION], "mCommission", "System.Decimal");
}
private void GetBasicEmployeeInfo()
{
string text = GenerateEmployeeInfo() + GenerateEmployeeCommission();
SqlCommand myCmd = new SqlCommand(text);
myCmd.Parameters.Add("@nnEmployeeID", nEmployeeID);
myDBCommon.SelectDataSet(myCmd, myResultDataSet);
myResultDataSet.Tables[0].TableName = EMPLOYEEINFO;
myResultDataSet.Tables[1].TableName = EMPLOYEECOMMISSIONCODE;
Ultis.AddColumn(myResultDataSet.Tables[EMPLOYEEINFO], "mCommission", "System.Decimal");
}
