public Int32 DeleteFeeInfo(String yearMonth, String feeID)
{
FeeInfo feeInfo = this.LoadFeeInfo(yearMonth, feeID);
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
builder.AppendItem(FeeInfoDBConst.FeeID, feeID);
if (!String.IsNullOrEmpty(yearMonth))
{
builder.AppendItem(FeeMonthInfoDBConst.YearMonth, yearMonth);
}//Not 需改进
String sql = String.Format(@"DELETE FROM {0} WHERE {3};
DELETE FROM {1} WHERE {3};
DELETE FROM {2} WHERE {3}",
String.IsNullOrEmpty(yearMonth) ? FeeInfoDBConst.TableName : ORMapping.GetMappingInfo <FeeMonthInfo>().TableName,
String.IsNullOrEmpty(yearMonth) ? TaxInfoDBConst.TableName : ORMapping.GetMappingInfo <TaxMonthInfo>().TableName,
String.IsNullOrEmpty(yearMonth) ? PersonBaseFeeInfoDBConst.TableName : ORMapping.GetMappingInfo <PersonBaseFeeMonthInfo>().TableName,
builder.ToSqlString());
using (TransactionScope scope = TransactionScopeFactory.Create(TransactionScopeOption.Required))
{
int result = _DataHelper.ExecuteSql(sql);
if (!String.IsNullOrEmpty(feeInfo.ParentID))
{
this.UpdateCalculateExp(yearMonth, feeInfo.ParentID);
}
scope.Complete();
return(result);
}
}
private String ConvertCaculateToCommon(String yearMonth, String feeID)
{//将计算型的转换为基本型的
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
builder.AppendItem(FeeMonthInfoDBConst.FeeID, feeID);
FeeInfo feeInfo = GetFeeInfoList(yearMonth, builder).FirstOrDefault();
if (feeInfo.FeeType.Equals(FeeType.Common))
{
if (!String.IsNullOrEmpty(feeInfo.CalculateExp))
{
return(String.Concat("(", this.ConvertExp(yearMonth, feeInfo.CalculateExp), ")"));
}
return("(ISNULL([" + feeID + "],0))");
}
else if (feeInfo.FeeType.Equals(FeeType.Tax))
{
return(String.Concat("ISNULL(DBO.CACULATETAX(''" + yearMonth + "'',''", feeInfo.FeeID
, "'',", ConvertExp(yearMonth, this.GetTaxFeeCalculateExp(yearMonth, feeInfo.FeeID)), "),0)"));
}
else if (feeInfo.FeeType.Equals(FeeType.Parameter))
{
return(this.GetParameterFeeValue(yearMonth, feeID).ToString());
}
else
{
return("(ISNULL(" + ConvertExp(yearMonth, feeInfo.CalculateExp) + ",0))");
}
}
public List <FeeInfo> GetReportCanSelectFeeList(string reportID)
{
String sql = String.Format(@"SELECT * FROM {0} WHERE ISNULL(PARENT_ID,'')='' AND use_flag=0 AND {3} NOT IN (SELECT {3} FROM {1} WHERE {4} ='{2}') ORDER BY {5}", FeeInfoDBConst.TableName, ReportFeeDBConst.TableName, reportID, FeeInfoDBConst.FeeID, ReportInfoDBConst.ReportID, FeeInfoDBConst.FeeCode);
DataTable dt = _DataHelper.GetDataTable(sql);
List <FeeInfo> resultFeeInfoList = new List <FeeInfo>();
for (Int32 i = 0; i < dt.Rows.Count; i++)
{
FeeInfo info = new FeeInfo();
ORMapping.DataRowToObject(dt.Rows[i], info);
resultFeeInfoList.Add(info);
}
List <FeeInfo> childrenFeeInfoList = new List <FeeInfo>();
foreach (FeeInfo feeInfo in resultFeeInfoList)
{
childrenFeeInfoList.AddRange(GetReportFeeChildrenInfoList(reportID, feeInfo));
}
resultFeeInfoList.AddRange(childrenFeeInfoList);
//String sql = String.Format(@"SELECT * FROM {0} WHERE use_flag=0 AND {3} NOT IN (SELECT {3} FROM {1} WHERE {4} ='{2}') ORDER BY {5}", FeeInfoDBConst.TableName, ReportFeeDBConst.TableName, reportID, FeeInfoDBConst.FeeID, ReportInfoDBConst.ReportID, FeeInfoDBConst.FeeCode);
//DataTable dt = _DataHelper.GetDataTable(sql);
//List<FeeInfo> result = new List<FeeInfo>();
//for (Int32 i = 0; i < dt.Rows.Count; i++)
//{
// FeeInfo info = new FeeInfo();
// ORMapping.DataRowToObject(dt.Rows[i], info);
// result.Add(info);
//}
return(resultFeeInfoList);
}
public Int32 UpdateFeeInfo(FeeInfo feeInfo)
{
using (TransactionScope scope = TransactionScopeFactory.Create(TransactionScopeOption.Required))
{
String sql = sql = ORMapping.GetUpdateSql(feeInfo, BuilderEx.TSqlBuilderInstance);
int result = _DataHelper.ExecuteSql(sql);
if (!String.IsNullOrEmpty(feeInfo.ParentID))
{
this.UpdateCalculateExp((feeInfo is FeeMonthInfo) ? ((FeeMonthInfo)feeInfo).YearMonth : null, feeInfo.ParentID);
}
scope.Complete();
return(result);
}
}
private Decimal GetParameterFeeValue(String yearMonth, String parameterFeeID)
{
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
builder.AppendItem(FeeMonthInfoDBConst.FeeType, FeeType.Parameter.ToString("D"));
builder.AppendItem(String.Concat(FeeMonthInfoDBConst.StartDate, "<= DATEADD(Day,-1,CONVERT(CHAR(8),DATEADD(Month,1,'", yearMonth, "01'),120)+'1')"));
WhereSqlClauseBuilder builderOr = new WhereSqlClauseBuilder(LogicOperatorDefine.Or);
builderOr.AppendItem(FeeMonthInfoDBConst.FeeID, parameterFeeID);
builderOr.AppendItem(FeeMonthInfoDBConst.ParentID, parameterFeeID);
builder.AppendItem(builderOr.ToSqlString());
FeeInfo feeInfo = GetFeeInfoList(yearMonth, builder).OrderBy(fee => fee.StartDate).FirstOrDefault();
return(feeInfo.DefaultValue);
}
public String GetTaxFeeCalculateExp(String yearMonth, String taxFeeID)
{
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
builder.AppendItem(FeeMonthInfoDBConst.FeeType, FeeType.Tax.ToString("D"));
builder.AppendItem(String.Concat(FeeMonthInfoDBConst.StartDate, "<= DATEADD(Day,-1,CONVERT(CHAR(8),DATEADD(Month,1,'", yearMonth, "01'),120)+'1')"));
WhereSqlClauseBuilder builderOr = new WhereSqlClauseBuilder(LogicOperatorDefine.Or);
builderOr.AppendItem(FeeMonthInfoDBConst.FeeID, taxFeeID);
builderOr.AppendItem(FeeMonthInfoDBConst.ParentID, taxFeeID);
builder.AppendItem(builderOr.ToSqlString());
FeeInfo feeInfo = GetFeeInfoList(yearMonth, builder).OrderBy(fee => fee.StartDate).FirstOrDefault();
return(feeInfo.CalculateExp);
}
public List <FeeInfo> GetReportFeeChildrenInfoList(String reportID, FeeInfo feeInfo)
{
WhereSqlClauseBuilder builderChilder = new WhereSqlClauseBuilder();
builderChilder.AppendItem(FeeInfoDBConst.ParentID, feeInfo.FeeID);
builderChilder.AppendItem(String.Concat(FeeInfoDBConst.FeeID, " NOT IN (SELECT FEE_ID FROM REPORT_FEE WHERE REPORT_ID='", reportID, "')"));
List <FeeInfo> resultList = FeeInfoAdapter.Instance.GetFeeInfoList(null, builderChilder);
List <FeeInfo> childrenList = new List <FeeInfo>();
foreach (FeeInfo info in resultList)
{
childrenList.AddRange(this.GetReportFeeChildrenInfoList(reportID, info));
}
resultList.AddRange(childrenList);
return(resultList);
}
private String ConvertCommonExpToCommon(String yearMonth, String feeID)
{
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
builder.AppendItem(FeeMonthInfoDBConst.FeeID, feeID);
FeeInfo feeInfo = FeeInfoAdapter.Instance.GetFeeInfoList(yearMonth, builder).FirstOrDefault();
if (feeInfo.FeeType.Equals(FeeType.Common))
{
if (!String.IsNullOrEmpty(feeInfo.CalculateExp))
{
return(String.Concat("(", this.ConvertCommonExp(yearMonth, feeInfo.CalculateExp), ")"));
}
return("[" + feeID + "]");
}
return(feeInfo.CalculateExp);
}
public List <FeeInfo> GetFeeInfoList(String yearMonth, WhereSqlClauseBuilder builder)
{
if (!String.IsNullOrEmpty(yearMonth))
{
builder.AppendItem(FeeMonthInfoDBConst.YearMonth, yearMonth);
}
String sql = String.Format("SELECT * FROM {0} WHERE {1} ORDER BY FEE_CODE", String.IsNullOrEmpty(yearMonth) ? FeeInfoDBConst.TableName : ORMapping.GetMappingInfo <FeeMonthInfo>().TableName, builder.ToSqlString());
DataTable dt = _DataHelper.GetDataTable(sql);
List <FeeInfo> result = new List <FeeInfo>();
for (Int32 i = 0; i < dt.Rows.Count; i++)
{
FeeInfo info = String.IsNullOrEmpty(yearMonth) ? new FeeInfo() : new FeeMonthInfo();
ORMapping.DataRowToObject(dt.Rows[i], info);
result.Add(info);
}
return(result);
}
private String GetTaxFeeID(String yearMonth, String taxFeeID)
{
if (String.IsNullOrEmpty(yearMonth))
{
yearMonth = DateTime.Now.ToString("yyyyMM");
}
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
builder.AppendItem(FeeMonthInfoDBConst.FeeType, FeeType.Tax.ToString("D"));
builder.AppendItem(String.Concat(FeeMonthInfoDBConst.StartDate, "<= DATEADD(Day,-1,CONVERT(CHAR(8),DATEADD(Month,1,'", yearMonth, "01'),120)+'1')"));
WhereSqlClauseBuilder builderOr = new WhereSqlClauseBuilder(LogicOperatorDefine.Or);
builderOr.AppendItem(FeeMonthInfoDBConst.FeeID, taxFeeID);
builderOr.AppendItem(FeeMonthInfoDBConst.ParentID, taxFeeID);
builder.AppendItem(builderOr.ToSqlString());
FeeInfo feeInfo = GetFeeInfoList(yearMonth, builder).OrderBy(fee => fee.StartDate).FirstOrDefault();
return(feeInfo.FeeID);
}
private Decimal CalculateCommonFeeValue(String yearMonth, String personID, String feeID)
{
FeeInfo feeInfo = FeeInfoAdapter.Instance.LoadFeeInfo(yearMonth, feeID);
String resultExp = this.ConvertCommonExp(yearMonth, feeInfo.CalculateExp);
String parameterClausePattern = @"\[(.*?)\]";
MatchCollection parameterClauseMatchs = Regex.Matches(resultExp, parameterClausePattern, RegexOptions.Singleline);
Dictionary <String, String> para = parameterClauseMatchs.OfType <Match>().Select(i => i.Value).Distinct().ToDictionary(i => i, i => string.Empty);
if (parameterClauseMatchs.Count == 0)
{
return(0);
}
foreach (String dt in para.Keys)
{
String strFeeID = dt.Replace("[", "").Replace("]", "");
PersonBaseFeeInfo personBaseFeeInfo = this.LoadPersonBaseFeeInfo(PersonBaseFeeTarget.PersonBaseFee, yearMonth, personID, strFeeID);
resultExp = resultExp.Replace(dt, personBaseFeeInfo.FeeValue.ToString());
}
return(Decimal.Parse(resultExp));
}
private void UpdateCalculateExp(String yearMonth, String feeID)
{
FeeInfo feeInfo = this.LoadFeeInfo(yearMonth, feeID);
if (feeInfo != null)
{
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
builder.AppendItem(FeeInfoDBConst.UseFlag, Status.True.ToString("D"));
builder.AppendItem(FeeInfoDBConst.ParentID, feeID);
String exp = String.Empty;
foreach (FeeInfo fee in this.GetFeeInfoList(yearMonth, builder))
{
if (!String.IsNullOrEmpty(fee.CalculateSign.Trim()))
{
exp += String.Concat(EnumHelper.GetDescription <CalculateSign>(fee.CalculateSign), " [", fee.FeeID, "] ");//Not第一个运算符不是+怎么办
}
}
feeInfo.CalculateExp = exp.Length > 1 ? exp.StartsWith("+") ? exp.Remove(0, 2) : exp : "";
this.UpdateFeeInfo(feeInfo);
}
}
public Int32 ChangeStatus(String yearMonth, String feeID, Int32 userFlag)
{
FeeInfo feeInfo = this.LoadFeeInfo(yearMonth, feeID);
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
builder.AppendItem(FeeInfoDBConst.FeeID, feeID);
if (!String.IsNullOrEmpty(yearMonth))
{
builder.AppendItem(FeeMonthInfoDBConst.YearMonth, yearMonth);
}
String sql = String.Format("UPDATE {0} SET USE_FLAG={1} WHERE {2} ", String.IsNullOrEmpty(yearMonth) ? FeeInfoDBConst.TableName : ORMapping.GetMappingInfo <FeeMonthInfo>().TableName, userFlag, builder.ToSqlString());
using (TransactionScope scope = TransactionScopeFactory.Create(TransactionScopeOption.Required))
{
int result = _DataHelper.ExecuteSql(sql);
if (!String.IsNullOrEmpty(feeInfo.ParentID))
{
this.UpdateCalculateExp(yearMonth, feeInfo.ParentID);
}
scope.Complete();
return(result);
}
}
//将费用编码替换为名称
public String ConvertFeeCodeWithFeeNameInExp(String yearMonth, String caculateExp)
{
String rtn = caculateExp;
String parameterClausePattern = @"\[(.*?)\]";
MatchCollection parameterClauseMatchs = Regex.Matches(rtn, parameterClausePattern, RegexOptions.Singleline);
Dictionary <String, String> para = parameterClauseMatchs.OfType <Match>().Select(i => i.Value).Distinct().ToDictionary(i => i, i => string.Empty);
if (parameterClauseMatchs.Count > 0)
{
foreach (String dt in para.Keys)
{
String strReplace = "";
FeeInfo feeInfo = this.LoadFeeInfo(yearMonth, dt);
if (!String.IsNullOrEmpty(feeInfo.ParentID))
{
strReplace = String.Concat("{", feeInfo.ParentName, "}");
}
strReplace += feeInfo.FeeName;
rtn = rtn.Replace(dt, String.Concat("[", strReplace, "]"));
}
}
return(rtn);
}
public bool IsFeeNameUsed(FeeInfo feeInfo, bool isAdd)
{
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
builder.AppendItem(FeeMonthInfoDBConst.FeeName, feeInfo.FeeName);
FeeInfo info = GetFeeInfoList((feeInfo is FeeMonthInfo) ? ((FeeMonthInfo)feeInfo).YearMonth : null, builder).FirstOrDefault();
if (info == null)
{
return(false);
}
else
{
if (isAdd)
{
return(true);
}
else
{
return(info.FeeID.Equals(feeInfo.FeeID) ? false : true);
}
}
}
public String CreateFeeCode(String feeTypeValue, String parentFeeID)
{
String sql;
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
if (String.IsNullOrEmpty(parentFeeID))
{
builder.AppendItem(String.Concat("ISNULL(", FeeInfoDBConst.ParentID, ", '')"), "");
if (!String.IsNullOrEmpty(feeTypeValue))
{
builder.AppendItem(FeeInfoDBConst.FeeType, feeTypeValue);
}
sql = String.Format("SELECT ISNULL(MAX({1}) + 1,100) FROM {0} WHERE {2}", FeeInfoDBConst.TableName, FeeInfoDBConst.FeeCode, builder.ToSqlString());
}
else
{
FeeInfo parentFeeInfo = this.LoadFeeInfo(null, parentFeeID);
builder.AppendItem(FeeInfoDBConst.ParentID, parentFeeID);
sql = String.Format("SELECT ISNULL(MAX({1}) + 1,'{2}01') FROM {0} WHERE {3}", FeeInfoDBConst.TableName, FeeInfoDBConst.FeeCode, parentFeeInfo.FeeCode, builder.ToSqlString());
}
DataTable dt = _DataHelper.GetDataTable(sql);
return(dt.Rows[0][0].ToString());
}
public List<FeeInfo> GetReportFeeChildrenInfoList(String reportID, FeeInfo feeInfo)
{
WhereSqlClauseBuilder builderChilder = new WhereSqlClauseBuilder();
builderChilder.AppendItem(FeeInfoDBConst.ParentID, feeInfo.FeeID);
builderChilder.AppendItem(String.Concat(FeeInfoDBConst.FeeID, " NOT IN (SELECT FEE_ID FROM REPORT_FEE WHERE REPORT_ID='", reportID, "')"));
List<FeeInfo> resultList = FeeInfoAdapter.Instance.GetFeeInfoList(null, builderChilder);
List<FeeInfo> childrenList = new List<FeeInfo>();
foreach (FeeInfo info in resultList)
{
childrenList.AddRange(this.GetReportFeeChildrenInfoList(reportID, info));
}
resultList.AddRange(childrenList);
return resultList;
}
public List<FeeInfo> GetReportCanSelectFeeList(string reportID)
{
String sql = String.Format(@"SELECT * FROM {0} WHERE ISNULL(PARENT_ID,'')='' AND use_flag=0 AND {3} NOT IN (SELECT {3} FROM {1} WHERE {4} ='{2}') ORDER BY {5}", FeeInfoDBConst.TableName, ReportFeeDBConst.TableName, reportID, FeeInfoDBConst.FeeID, ReportInfoDBConst.ReportID, FeeInfoDBConst.FeeCode);
DataTable dt = _DataHelper.GetDataTable(sql);
List<FeeInfo> resultFeeInfoList = new List<FeeInfo>();
for (Int32 i = 0; i < dt.Rows.Count; i++)
{
FeeInfo info = new FeeInfo();
ORMapping.DataRowToObject(dt.Rows[i], info);
resultFeeInfoList.Add(info);
}
List<FeeInfo> childrenFeeInfoList = new List<FeeInfo>();
foreach (FeeInfo feeInfo in resultFeeInfoList)
{
childrenFeeInfoList.AddRange(GetReportFeeChildrenInfoList(reportID, feeInfo));
}
resultFeeInfoList.AddRange(childrenFeeInfoList);
//String sql = String.Format(@"SELECT * FROM {0} WHERE use_flag=0 AND {3} NOT IN (SELECT {3} FROM {1} WHERE {4} ='{2}') ORDER BY {5}", FeeInfoDBConst.TableName, ReportFeeDBConst.TableName, reportID, FeeInfoDBConst.FeeID, ReportInfoDBConst.ReportID, FeeInfoDBConst.FeeCode);
//DataTable dt = _DataHelper.GetDataTable(sql);
//List<FeeInfo> result = new List<FeeInfo>();
//for (Int32 i = 0; i < dt.Rows.Count; i++)
//{
// FeeInfo info = new FeeInfo();
// ORMapping.DataRowToObject(dt.Rows[i], info);
// result.Add(info);
//}
return resultFeeInfoList;
}
public bool IsFeeNameUsed(FeeInfo feeInfo, bool isAdd)
{
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
builder.AppendItem(FeeMonthInfoDBConst.FeeName, feeInfo.FeeName);
FeeInfo info = GetFeeInfoList((feeInfo is FeeMonthInfo) ? ((FeeMonthInfo)feeInfo).YearMonth : null, builder).FirstOrDefault();
if (info == null)
{
return false;
}
else
{
if (isAdd)
{
return true;
}
else
{
return info.FeeID.Equals(feeInfo.FeeID) ? false : true;
}
}
}
public Int32 UpdateFeeInfo(FeeInfo feeInfo)
{
using (TransactionScope scope = TransactionScopeFactory.Create(TransactionScopeOption.Required))
{
String sql = sql = ORMapping.GetUpdateSql(feeInfo, BuilderEx.TSqlBuilderInstance);
int result = _DataHelper.ExecuteSql(sql);
if (!String.IsNullOrEmpty(feeInfo.ParentID))
{
this.UpdateCalculateExp((feeInfo is FeeMonthInfo) ? ((FeeMonthInfo)feeInfo).YearMonth : null, feeInfo.ParentID);
}
scope.Complete();
return result;
}
}
public Int32 InsertPayMonthInfo(String yearMonth, bool rewrite)
{
using (TransactionScope scope = TransactionScopeFactory.Create(TransactionScopeOption.Required))
{
StringBuilder sql = new StringBuilder();
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
if (rewrite)
{
builder.AppendItem(PayMonthInfoDBConst.YearMonth, yearMonth);
this.DeletePayMonthInfo(builder);
//工资月表
foreach (PayMonthInfo payMonthInfo in PersonBaseFeeInfoAdapter.Instance.GetPersonBaseFeeInfoList(PersonBaseFeeTarget.PayMonth, yearMonth))
{
sql.Append(ORMapping.GetInsertSql(payMonthInfo, BuilderEx.TSqlBuilderInstance));
sql.Append(";");
}
}
else
{
builder.AppendItem(String.Concat(PersonInfoDBConst.EntryDate, "<= DATEADD(Day,-1,CONVERT(CHAR(8),DATEADD(Month,1,'", yearMonth, "01'),120)+'1')"));
builder.AppendItem(String.Concat("ISNULL(", PersonInfoDBConst.LeftDate, ",DATEADD(Month,1,GETDATE()))"), yearMonth + "01", ">=");
List <PersonInfo> personList = PersonInfoAdapter.Instance.GetPersonInfoList(builder);
//工资项目月表
foreach (FeeInfo feeInfo in FeeInfoAdapter.Instance.GetFeeInfoList(null, null))
{
FeeMonthInfo feeMonthInfo = Tools.ClassDataCopy <FeeInfo, FeeMonthInfo>(feeInfo);
feeMonthInfo.YearMonth = yearMonth;
sql.Append(ORMapping.GetInsertSql(feeMonthInfo, BuilderEx.TSqlBuilderInstance));
sql.Append(";");
}//人员基本工资月表
foreach (PersonBaseFeeMonthInfo personBaseFeeMonthInfo in PersonBaseFeeInfoAdapter.Instance.GetPersonBaseFeeInfoList(PersonBaseFeeTarget.PersonBaseFeeMonth, null).Join(personList, baseFee => baseFee.PersonID, person => person.PersonID, (baseFeeDepart, person) => baseFeeDepart).ToList())
{
personBaseFeeMonthInfo.YearMonth = yearMonth;
sql.Append(ORMapping.GetInsertSql(personBaseFeeMonthInfo, BuilderEx.TSqlBuilderInstance));
sql.Append(";");
//工资月表
FeeInfo feeInfo = FeeInfoAdapter.Instance.LoadFeeInfo(null, personBaseFeeMonthInfo.FeeID);
if (String.IsNullOrEmpty(feeInfo.CalculateExp))
{
PayMonthInfo PayMonthInfo = Tools.ClassDataCopy <PersonBaseFeeMonthInfo, PayMonthInfo>(personBaseFeeMonthInfo);
PayMonthInfo.YearMonth = yearMonth;
PayMonthInfo.PayMoney = PayMonthInfo.FeeValue;
sql.Append(ORMapping.GetInsertSql(PayMonthInfo, BuilderEx.TSqlBuilderInstance));
sql.Append(";");
}
}
//人员基本工资项目部门分摊月表
WhereSqlClauseBuilder builderDepartment = new WhereSqlClauseBuilder();
foreach (PersonBaseFeeDepartmentProjectInfo personFeeDepartmentProjectInfo in PersonBaseFeeDepartmentProjectInfoAdapter.Instance.GetPersonBaseFeeDepartmentProjectInfoList(null, null).Join(personList, baseFeeDepart => baseFeeDepart.PersonID, person => person.PersonID, (baseFeeDepart, person) => baseFeeDepart).ToList())
{
PersonBaseFeeDepartmentProjectMonthInfo personFeeDepartmentProjectMonthInfo = Tools.ClassDataCopy <PersonBaseFeeDepartmentProjectInfo, PersonBaseFeeDepartmentProjectMonthInfo>(personFeeDepartmentProjectInfo);
personFeeDepartmentProjectMonthInfo.YearMonth = yearMonth;
sql.Append(ORMapping.GetInsertSql(personFeeDepartmentProjectMonthInfo, BuilderEx.TSqlBuilderInstance));
sql.Append(";");
}
//税率月表
builder.Clear();
foreach (TaxInfo taxInfo in TaxInfoAdapter.Instance.GetTaxInfoList(null, builder))
{
TaxMonthInfo taxMonthInfo = Tools.ClassDataCopy <TaxInfo, TaxMonthInfo>(taxInfo);
taxMonthInfo.YearMonth = yearMonth;
sql.Append(ORMapping.GetInsertSql(taxMonthInfo, BuilderEx.TSqlBuilderInstance));
sql.Append(";");
}
}
int result = _DataHelper.ExecuteSql(sql.ToString());
scope.Complete();
return(result);
}
}