public override global::System.Data.DataSet Clone()
{
IncentiveGradeSummaryDataSet cln = ((IncentiveGradeSummaryDataSet)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
IncentiveGradeSummaryDataSet ds = new IncentiveGradeSummaryDataSet();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
void threadShow_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
object[] results = e.Result as object[];
List <PersonalModel> personalList_D1 = results[0] as List <PersonalModel>;
List <SourceModel> sourceList = results[1] as List <SourceModel>;
List <WorkerLeaveModel> workerLeaveList = results[2] as List <WorkerLeaveModel>;
//List<LinePerformanceDetailModel> performanceDetailList = results[6] as List<LinePerformanceDetailModel>;
List <HolidayModel> holidayList = results[4] as List <HolidayModel>;
List <WorkerFilterModel> workerFilterList = WorkerFilterModel.Create(section.SectionId);
DataTable dt = new LineIncentiveSummaryDataSet().Tables["LineIncentiveSummaryTable"];
int i = 1;
foreach (PersonalModel personal in personalList_D1)
{
List <LinePerformanceDetailModel> performanceDetailList_D1 = performanceDetailList.Where(p => p.WorkerId == personal.WorkerId).ToList();
List <String> icentiveGradeList = performanceDetailList_D1.Select(p => p.IncentiveGrade).Distinct().OrderBy(g => g).ToList();
DataRow dr = dt.NewRow();
dr["NumberOf"] = i;
dr["WorkerId"] = personal.WorkerId;
dr["Name"] = personal.Name;
string incentiveGrade = "";
for (int l = 0; l <= icentiveGradeList.Count - 1; l++)
{
incentiveGrade += String.Format("{0}; ", icentiveGradeList[l]);
}
//dr["Position"] = personal.Position;
dr["Position"] = incentiveGrade;
int numberOfDayAbsent = CalculateNumberOfDayAbsent(year, month,
sourceList.Where(s => s.CardId == personal.CardId).ToList(),
workerLeaveList.Where(w => w.WorkerId == personal.WorkerId).ToList(), holidayList);
dr["NumberOfDayAbsent"] = numberOfDayAbsent;
double minusLevel = 0;
MinusIncentiveModel minusIncentiveLast = minusIncentiveList.OrderBy(m => m.NumberOfDayAbsent).Last();
if (numberOfDayAbsent >= minusIncentiveLast.NumberOfDayAbsent)
{
minusLevel = minusIncentiveLast.MinusLevel;
}
else
{
MinusIncentiveModel minusIncentive = minusIncentiveList.Where(m => m.NumberOfDayAbsent == numberOfDayAbsent).FirstOrDefault();
if (minusIncentive != null)
{
minusLevel = minusIncentive.MinusLevel;
}
}
//double workerRatio = 0;
//DateTime firstDate = new DateTime(year, month, 1);
//WorkerFilterModel workerFilter = workerFilterList.Where(w => CalculateHelper.CalculateMonth(personal.HiredDate, firstDate) >= w.MinMonth && CalculateHelper.CalculateMonth(personal.HiredDate, firstDate) < w.MaxMonth).FirstOrDefault();
//if (workerFilter != null)
//{
// workerRatio = workerFilter.Ratio;
//}
double incentive = performanceDetailList_D1.Select(p => (p.Incentive + p.SpecsIncentive + p.ExcessIncentive)).Sum();
dr["Incentive"] = incentive - (minusLevel * incentive);
dt.Rows.Add(dr);
i++;
}
dgMain.ItemsSource = null;
dgMain.ItemsSource = dt.AsDataView();
List <String> incentiveGradeList = performanceDetailList.Select(p => p.IncentiveGrade).Distinct().OrderBy(g => g).ToList();
DataTable dtIncentiveGradeSummary = new IncentiveGradeSummaryDataSet().Tables["IncentiveGradeSummaryTable"];
foreach (string incentiveGrade in incentiveGradeList)
{
DataRow dr = dtIncentiveGradeSummary.NewRow();
dr["IncentiveGrade"] = incentiveGrade;
dr["Count"] = performanceDetailList.Where(p => p.IncentiveGrade == incentiveGrade).Select(p => p.WorkerId).Distinct().Count();
dtIncentiveGradeSummary.Rows.Add(dr);
}
dgIncentiveGradeSummary.ItemsSource = null;
dgIncentiveGradeSummary.ItemsSource = dtIncentiveGradeSummary.AsDataView();
btnShow.IsEnabled = true;
btnPrint.IsEnabled = true;
this.Cursor = null;
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
IncentiveGradeSummaryDataSet ds = new IncentiveGradeSummaryDataSet();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "IncentiveGradeSummaryTableDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}