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;
}
}
}