public FinanInfoSystem() { // // TODO: 在此处添加构造函数逻辑 // finanInfoRules = new FinanInfoRules(); finanInfo = new FinanInfo(); }
public DataSet GetContiAbsForMess(string getGrade,string getClass, string getName,string getNumber,DateTime balanceMonth,FinanInfo finanInfo) { using ( FinanInfoDataAccess finanInfoDataAccess = new FinanInfoDataAccess() ) { try { DataSet dsFinanBuild = finanInfoDataAccess.SetFinanStuInfo(getGrade,getClass,getName,getNumber); DataSet dsAdmRestoreDays = finanInfoDataAccess.SetContiAbsForMess(true,getGrade,getClass, getName,getNumber,balanceMonth,finanInfo.GetMessRestoreDays); DataSet dsMessRestoreDays = finanInfoDataAccess.SetContiAbsForMess(false,getGrade,getClass, getName,getNumber,balanceMonth,finanInfo.GetMessRestoreDays); DataColumn needHandDaysColumn = new DataColumn("info_needHandDays"); needHandDaysColumn.DataType = System.Type.GetType("System.Int32"); dsFinanBuild.Tables[0].Columns.Add(needHandDaysColumn); DataColumn messStopDaysColumn = new DataColumn("info_messStopDays"); messStopDaysColumn.DataType = System.Type.GetType("System.Int32"); dsFinanBuild.Tables[0].Columns.Add(messStopDaysColumn); dsFinanBuild.Tables[0].Columns.AddRange(new DataColumn[]{ new DataColumn("info_admCharge"),new DataColumn("info_messCharge"), new DataColumn("info_nightCharge"),new DataColumn("info_commCharge"), new DataColumn("info_milkCharge"),new DataColumn("info_extraCharge"), new DataColumn("info_admRestoreCharge"),new DataColumn("info_messRestoreCharge"), new DataColumn("info_currency"),new DataColumn("info_remark")}); for ( int finanRow = 0; finanRow < dsFinanBuild.Tables[0].Rows.Count; finanRow ++ ) { //应交天数 dsFinanBuild.Tables[0].Rows[finanRow][3] = GetWorkDays(balanceMonth); //停伙天数及退伙食费 dsFinanBuild.Tables[0].Rows[finanRow][4] = 0; dsFinanBuild.Tables[0].Rows[finanRow][12] = "0.00¥"; foreach(DataRow messRow in dsMessRestoreDays.Tables[0].Rows) { if ( dsFinanBuild.Tables[0].Rows[finanRow][0].ToString().Equals(messRow[0].ToString()) ) { dsFinanBuild.Tables[0].Rows[finanRow][4] = messRow[1]; dsFinanBuild.Tables[0].Rows[finanRow][12] = (finanInfo.GetMessCharge/GetWorkDays(balanceMonth)* Convert.ToDouble(messRow[1])).ToString("0.00")+"¥"; getMessRestoreCharge = finanInfo.GetMessCharge/GetWorkDays(balanceMonth)* Convert.ToDouble(messRow[1]); break; } else { dsFinanBuild.Tables[0].Rows[finanRow][4] = 0; dsFinanBuild.Tables[0].Rows[finanRow][12] = "0.00¥"; getMessRestoreCharge = 0; } } //管理费 dsFinanBuild.Tables[0].Rows[finanRow][5] = finanInfo.GetAdmCharge.ToString("0.00")+"¥"; dsFinanBuild.Tables[0].Rows[finanRow][11] = "0.00¥"; foreach(DataRow admRow in dsAdmRestoreDays.Tables[0].Rows) { if ( dsFinanBuild.Tables[0].Rows[finanRow][0].ToString().Equals(admRow[0].ToString())) { if ( Convert.ToInt32(admRow[1]) >= finanInfo.GetAdmRestoreDays ) { dsFinanBuild.Tables[0].Rows[finanRow][11] = (finanInfo.GetAdmCharge/2).ToString("0.00")+"¥"; getAdmRestoreCharge = finanInfo.GetAdmCharge/2; break; } else { dsFinanBuild.Tables[0].Rows[finanRow][11] = "0.00¥"; getAdmRestoreCharge = 0; } } // else // { // dsFinanBuild.Tables[0].Rows[finanRow][5] = finanInfo.GetAdmCharge.ToString("0.00")+"¥"; // dsFinanBuild.Tables[0].Rows[finanRow][11] = "0.00¥"; // getAdmRestoreCharge = 0; // } } //伙食费 dsFinanBuild.Tables[0].Rows[finanRow][6] = finanInfo.GetMessCharge.ToString("0.00")+"¥"; //晚托费 dsFinanBuild.Tables[0].Rows[finanRow][7] = finanInfo.GetNightCharge.ToString("0.00")+"¥"; //代办费 dsFinanBuild.Tables[0].Rows[finanRow][8] = finanInfo.GetCommCharge.ToString("0.00")+"¥"; //牛奶费 dsFinanBuild.Tables[0].Rows[finanRow][9] = finanInfo.GetMilkCharge.ToString("0.00")+"¥"; //附加费 dsFinanBuild.Tables[0].Rows[finanRow][10] = finanInfo.GetExtraCharge.ToString("0.00")+"¥"; //实收金额 dsFinanBuild.Tables[0].Rows[finanRow][13] = (finanInfo.GetMessCharge + finanInfo.GetAdmCharge + finanInfo.GetNightCharge + finanInfo.GetMilkCharge + finanInfo.GetCommCharge +finanInfo.GetExtraCharge - getMessRestoreCharge - getAdmRestoreCharge).ToString("0.00")+"¥"; //备注 dsFinanBuild.Tables[0].Rows[finanRow][14] = finanInfo.GetRemark; } return dsFinanBuild; } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return null; } } }
public DataSet ModifyFinanInfo(FinanInfo finanInfo,DataSet getDS,string getNumber,DateTime balanceMonth) { using ( FinanInfoDataAccess finanInfoDataAccess = new FinanInfoDataAccess() ) { try { DataSet dsModifyMessInfo = finanInfoDataAccess.SetContiAbsForMess(false,"","","",getNumber, balanceMonth,finanInfo.GetMessRestoreDays); DataSet dsModifyAdmInfo = finanInfoDataAccess.SetContiAbsForMess(true,"","","",getNumber, balanceMonth,finanInfo.GetMessRestoreDays); foreach(DataRow modifyRow in getDS.Tables[0].Rows) { if ( modifyRow[0].ToString().Equals(getNumber) ) { modifyRow[4] = 0; modifyRow[12] = "0.00¥"; if ( dsModifyMessInfo.Tables[0].Rows.Count != 0) { modifyRow[4] = dsModifyAdmInfo.Tables[0].Rows[0][1]; modifyRow[12] = (finanInfo.GetMessCharge/GetWorkDays(balanceMonth)* Convert.ToDouble(dsModifyAdmInfo.Tables[0].Rows[0][1])).ToString("0.00")+"¥"; getModifyMessRestoreCharge = finanInfo.GetMessCharge/GetWorkDays(balanceMonth)* Convert.ToDouble(dsModifyAdmInfo.Tables[0].Rows[0][1]); } modifyRow[5] = finanInfo.GetAdmCharge.ToString("0.00")+"¥"; modifyRow[11] = "0.00¥"; if ( dsModifyAdmInfo.Tables[0].Rows.Count !=0 ) { if ( Convert.ToInt32(dsModifyAdmInfo.Tables[0].Rows[0][1]) >= finanInfo.GetAdmRestoreDays ) { modifyRow[11] = (finanInfo.GetAdmCharge/2).ToString("0.00")+"¥"; getModifyAdmRestoreCharge = finanInfo.GetAdmCharge/2; } } modifyRow[6] = finanInfo.GetMessCharge.ToString("0.00")+"¥"; modifyRow[7] = finanInfo.GetNightCharge.ToString("0.00")+"¥"; modifyRow[8] = finanInfo.GetCommCharge.ToString("0.00")+"¥"; modifyRow[9] = finanInfo.GetMilkCharge.ToString("0.00")+"¥"; modifyRow[10] = finanInfo.GetExtraCharge.ToString("0.00")+"¥"; modifyRow[13] = (finanInfo.GetMessCharge + finanInfo.GetAdmCharge + finanInfo.GetNightCharge + finanInfo.GetMilkCharge + finanInfo.GetCommCharge +finanInfo.GetExtraCharge - getModifyMessRestoreCharge - getModifyAdmRestoreCharge).ToString("0.00")+"¥"; modifyRow[14] = finanInfo.GetRemark; } } return getDS; } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return null; } } }