工資發(fā)放復(fù)核及查詢

北風(fēng)網(wǎng)項目培訓(xùn)第30講：實現(xiàn)薪酬發(fā)放復(fù)核及查詢講師：風(fēng)舞煙TheOneHR人力資源管理系統(tǒng)本講目錄薪酬發(fā)放復(fù)核功能實現(xiàn)薪酬發(fā)放查詢功能實現(xiàn)本講知識點DataTable封裝業(yè)務(wù)邏輯的運(yùn)用DataTable封裝業(yè)務(wù)邏輯的運(yùn)用

///<summary>///根據(jù)工資發(fā)放登記ID產(chǎn)生員工工資發(fā)放明細(xì)報表

///</summary>///<paramname="sId">工資發(fā)放登記ID</param>///<returns></returns>publicstaticDataTableGetGrantDetailInfoByBranchId(intsId){//得機(jī)構(gòu)IDintbranchId=BLL.Salary_grantManager.GetSalary_grantById(sId).Ctk_no.Id;///得到所有工資標(biāo)準(zhǔn)項

IList<Salary_item>sItems=BLL.Salary_itemManager.GetAllSalary_items();

///得到某機(jī)構(gòu)下所有員工列表

IList<Human_file>humans=BLL.Human_fileManager.GetHumanFileByBranchId(branchId);DataTabledt=newDataTable("CgrantDetailTable");//keyDataColumncolkey=newDataColumn();colkey.ColumnName="序號";colkey.DataType=typeof(Int32);dt.Columns.Add(colkey);//col2DataColumncolName=newDataColumn();colName.ColumnName="姓名";colName.DataType=typeof(string);dt.Columns.Add(colName);//col3foreach(Salary_itemsiteminsItems){DataColumncolsItem=newDataColumn();colsItem.ColumnName=sitem.Salary_items_name;colsItem.DataType=typeof(string);dt.Columns.Add(colsItem);}s

//col-處罰

DataColumncolDecMoney=newDataColumn();colDecMoney.ColumnName="應(yīng)扣金額";colDecMoney.DataType=typeof(decimal);dt.Columns.Add(colDecMoney);foreach(Human_filehumaninhumans){DataRowrow=dt.NewRow();row["序號"]=human.Id;row["姓名"]=human.Human_name;foreach(Salary_itemsiteminsItems){//得到每個員工的工資標(biāo)準(zhǔn)的每項明細(xì)

row[sitem.Salary_items_name]=BLL.Salary_standard_detailManager.GetSalaryBySalaryItemIdAndSalaryStandardId(human.Ss_no.Id,sitem.Id).ToString("F2");}Models.Salary_grant_detailsd=BLL.Salary_grant_detailManager.GetSalaryGrantDetailBySalaryIDAndHumanId(sId,human.Id);row["獎勵金額"]=sd.Bouns_sum;row["應(yīng)扣金額"]=sd.Deduct_sum;dt.Rows