private void InitializeCalculateExpFeeListBox() { List <FeeInfo> feeList = new List <FeeInfo>(), feeListNew = new List <FeeInfo>(); WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder(); if (action != ActionType.Add) {//if (this.ddlFee.SelectedIndex > 0){} //为完成:如果打开后又选了重新选择了父项目或改了项目编码怎么办? builder.AppendItem(FeeInfoDBConst.FeeID, feeID, "<>"); builder.AppendItem(FeeInfoDBConst.ParentID, feeID, "<>"); builder.AppendItem(FeeInfoDBConst.CalculateExp, String.Concat(@"%\[", feeID, @"\]%##ESCAPE##"), " NOT LIKE "); } builder.AppendItem(FeeInfoDBConst.FeeType, FeeType.Sum.ToString("D"));//计算型 feeList = this.ReCreateFeeID(FeeInfoAdapter.Instance.GetFeeInfoList(yearMonth, builder).Where(fee => !fee.UseFlag == bool.Parse(Status.True.ToString())).ToList()); Tools.ListBoxDataBind(this.litbCalculateFee, feeList, FeeInfoConst.FeeName, FeeInfoConst.FeeID); builder.Clear(); builder.AppendItem(FeeInfoDBConst.FeeType, FeeType.Common.ToString("D"));//组成型 feeList = this.ReCreateFeeID(FeeInfoAdapter.Instance.GetFeeInfoList(yearMonth, builder).Where(fee => !fee.UseFlag == bool.Parse(Status.True.ToString())).ToList()); Tools.ListBoxDataBind(this.litbCommonFee, feeList, FeeInfoConst.FeeName, FeeInfoConst.FeeID); builder.Clear(); builder.AppendItem(FeeInfoDBConst.FeeType, FeeType.Parameter.ToString("D"));//参数型 feeList = this.ReCreateFeeID(FeeInfoAdapter.Instance.GetFeeInfoList(yearMonth, builder).Where(parent => (!parent.UseFlag == bool.Parse(Status.True.ToString())) && (parent.ParentID == "" || parent.ParentID == null)).ToList()); Tools.ListBoxDataBind(this.litbParameterFee, feeList, FeeInfoConst.FeeName, FeeInfoConst.FeeID); builder.Clear(); builder.AppendItem(FeeInfoDBConst.FeeType, FeeType.Tax.ToString("D"));//个税型 feeList = this.ReCreateFeeID(FeeInfoAdapter.Instance.GetFeeInfoList(yearMonth, builder).Where(parent => (!parent.UseFlag == bool.Parse(Status.True.ToString())) && (parent.ParentID == "" || parent.ParentID == null)).ToList()); Tools.ListBoxDataBind(this.litbTaxFee, feeList, FeeInfoConst.FeeName, FeeInfoConst.FeeID); Tools.ListBoxDataBindByEnum(this.litbFunction, typeof(FeeFunction), false);//函数 }
public Int32 KelownaPayMonthInfo(String yearMonth) { DateTime dt = DateTime.Parse(yearMonth.Insert(4, "-").Insert(7, "-01")).AddMonths(1); String yearMonthD = String.Concat(dt.Year.ToString(), dt.Month.ToString()); using (TransactionScope scope = TransactionScopeFactory.Create(TransactionScopeOption.Required)) { StringBuilder sql = new StringBuilder(); WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder(); foreach (PersonBaseFeeMonthInfo PersonBaseFeeMonthInfo in PersonBaseFeeInfoAdapter.Instance.GetPersonBaseFeeInfoList(PersonBaseFeeTarget.PersonBaseFeeMonth, yearMonth)) { PersonBaseFeeMonthInfo.YearMonth = yearMonthD; sql.Append(ORMapping.GetInsertSql(PersonBaseFeeMonthInfo, BuilderEx.TSqlBuilderInstance)); sql.Append(";"); } //工资月表 builder.AppendItem(PayMonthInfoDBConst.YearMonth, yearMonth); foreach (PayMonthInfo PayMonthInfo in PayMonthInfoAdapter.Instance.GetPayMonthInfoList(builder)) { PayMonthInfo.YearMonth = yearMonthD; sql.Append(ORMapping.GetInsertSql(PayMonthInfo, BuilderEx.TSqlBuilderInstance)); sql.Append(";"); } //人员基本工资项目部门分摊月表 builder.Clear(); builder.AppendItem(PersonBaseFeeDepartmentProjectMonthInfoDBConst.YearMonth, yearMonth); foreach (PersonBaseFeeDepartmentProjectMonthInfo personFeeDepartmentProjectMonthInfo in PersonBaseFeeDepartmentProjectInfoAdapter.Instance.GetPersonBaseFeeDepartmentProjectInfoList(yearMonth, builder)) { personFeeDepartmentProjectMonthInfo.YearMonth = yearMonthD; sql.Append(ORMapping.GetInsertSql(personFeeDepartmentProjectMonthInfo, BuilderEx.TSqlBuilderInstance)); sql.Append(";"); } //工资项目月表 builder.Clear(); builder.AppendItem(FeeMonthInfoDBConst.YearMonth, yearMonth); foreach (FeeMonthInfo feeMonthInfo in FeeInfoAdapter.Instance.GetFeeInfoList(yearMonth, builder)) { feeMonthInfo.YearMonth = yearMonthD; sql.Append(ORMapping.GetInsertSql(feeMonthInfo, BuilderEx.TSqlBuilderInstance)); sql.Append(";"); } //税率月表 builder.Clear(); builder.AppendItem(TaxMonthInfoDBConst.YearMonth, yearMonth); foreach (TaxMonthInfo taxMonthInfo in TaxInfoAdapter.Instance.GetTaxInfoList(yearMonth, builder)) { taxMonthInfo.YearMonth = yearMonthD; sql.Append(ORMapping.GetInsertSql(taxMonthInfo, BuilderEx.TSqlBuilderInstance)); sql.Append(";"); } int result = _DataHelper.ExecuteSql(sql.ToString()); scope.Complete(); return(result); } }
public int Delete(string[] defKeys) { StringBuilder strBuilder = new StringBuilder(); foreach (string defKey in defKeys) { WhereSqlClauseBuilder whereBuilder = new WhereSqlClauseBuilder(); whereBuilder.AppendItem("DEF_KEY", defKey); whereBuilder.AppendTenantCode(typeof(WfMatrixDefinition)); strBuilder.Append(DELETE_SQL_CLAUSE); strBuilder.Append(whereBuilder.ToSqlString(TSqlBuilder.Instance)); strBuilder.Append(TSqlBuilder.Instance.DBStatementSeperator); whereBuilder.Clear(); whereBuilder.AppendItem("MATRIX_DEF_KEY", defKey); whereBuilder.AppendTenantCode(typeof(WfMatrixDimensionDefinition)); strBuilder.Append(DELETE_DIMENSION_SQL_CLAUSE); strBuilder.Append(whereBuilder.ToSqlString(TSqlBuilder.Instance)); strBuilder.Append(TSqlBuilder.Instance.DBStatementSeperator); } return(DbHelper.RunSqlWithTransaction(strBuilder.ToString())); }
private void ReplaceWhereItem(string searchField, object searchValue, string template, bool isInput) { WhereSqlClauseBuilder whereSqlClause = WhereSqlClauses.Find(builder => builder.Exists(item => ((SqlClauseBuilderItemIUW)item).DataField == searchField)); string searchText = searchValue.ToString(); string formattedSearchText = TSqlBuilder.Instance.FormatFullTextString(LogicOperatorDefine.And, searchText); //找到了已经存在的和searchField字段匹配的WhereSqlClauseBuilder if (whereSqlClause != null) { if (searchText == DeluxeSearch.ClearWhereCondition) { WhereSqlClauses.Remove(whereSqlClause); } else { if (searchText.IsNotEmpty()) { if (searchField == SearchField) { whereSqlClause.Clear(); } else { whereSqlClause.Remove(item => { var curItem = (SqlClauseBuilderItemIUW)item; bool compareResult = false; //如果是全文检索(有Template),则按照字段匹配删除,否则附加上值的匹配 if (this.SearchMethod == DeluxeSearchMethodType.FullText && template.IsNotEmpty()) { compareResult = curItem.DataField == searchField; } else { compareResult = curItem.DataField == searchField && (curItem.Data.ToString() == searchText || curItem.Data.ToString() == formattedSearchText); } return(compareResult); }); } FillSearchFieldWhereSqlClauseBuilder(whereSqlClause, searchField, searchText, template, isInput); } } } else if (searchText.IsNotEmpty() && searchText != DeluxeSearch.ClearWhereCondition) { whereSqlClause = new WhereSqlClauseBuilder(); FillSearchFieldWhereSqlClauseBuilder(whereSqlClause, searchField, searchText, template, isInput); WhereSqlClauses.Add(whereSqlClause); } }
protected void gvBaseList_DataBound(object sender, EventArgs e) { GridView gvList = (GridView)sender; if (!(gvList.Rows.Count == 1 && (gvList.Rows[0].Cells[0].Text == SalaryConst.EmptyText || gvList.DataKeys[0].Value == null))) { ImageButton ibtnEdit; Label lblFeeName; WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder(); String strAddSpace = String.Empty; Double sumValue = 0.00; for (Int32 i = 0; i < gvList.Rows.Count; i++) { String strFeeCode = gvList.DataKeys[i].Values[FeeInfoConst.FeeCode].ToString(); String strFeeID = gvList.DataKeys[i].Values[FeeInfoConst.FeeID].ToString(); lblFeeName = gvList.Rows[i].FindControl("lblFeeName") as Label; //缩进 strAddSpace = SalaryAppAdapter.Instance.AddSpaceInFrontOfFeeName(strFeeCode); lblFeeName.Text = strAddSpace + gvList.DataKeys[i].Values[FeeInfoConst.FeeName].ToString(); //gvList.Rows[i].Cells[0].Text = strAddSpace + gvList.DataKeys[i].Values[FeeInfoConst.FeeName].ToString(); builder.AppendItem(FeeInfoDBConst.ParentID, strFeeID); if (FeeInfoAdapter.Instance.GetFeeInfoList(this.yearMonth, builder).Any()) { //gvList.Rows[i].Cells[1].Text = ""; ibtnEdit = gvList.Rows[i].FindControl("btnCommonEdit") as ImageButton; ibtnEdit.Visible = false; //ibtnAddChild = gvList.Rows[i].FindControl("ibtnSave") as ImageButton; //ibtnAddChild.Visible = false; } builder.Clear(); if (strAddSpace.Length == 0) { sumValue += Double.Parse(gvList.DataKeys[i].Values[PersonBaseFeeInfoConst.FeeValue].ToString()); } } gvList.FooterRow.Cells[1].Text = sumValue.ToString("n");//"#,##0.00" } }
public Int32 KelownaPayMonthInfo(String yearMonth) { DateTime dt = DateTime.Parse(yearMonth.Insert(4, "-").Insert(7, "-01")).AddMonths(1); String yearMonthD = String.Concat(dt.Year.ToString(), dt.Month.ToString()); using (TransactionScope scope = TransactionScopeFactory.Create(TransactionScopeOption.Required)) { StringBuilder sql = new StringBuilder(); WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder(); foreach (PersonBaseFeeMonthInfo PersonBaseFeeMonthInfo in PersonBaseFeeInfoAdapter.Instance.GetPersonBaseFeeInfoList(PersonBaseFeeTarget.PersonBaseFeeMonth, yearMonth)) { PersonBaseFeeMonthInfo.YearMonth = yearMonthD; sql.Append(ORMapping.GetInsertSql(PersonBaseFeeMonthInfo, BuilderEx.TSqlBuilderInstance)); sql.Append(";"); } //工资月表 builder.AppendItem(PayMonthInfoDBConst.YearMonth, yearMonth); foreach (PayMonthInfo PayMonthInfo in PayMonthInfoAdapter.Instance.GetPayMonthInfoList(builder)) { PayMonthInfo.YearMonth = yearMonthD; sql.Append(ORMapping.GetInsertSql(PayMonthInfo, BuilderEx.TSqlBuilderInstance)); sql.Append(";"); } //人员基本工资项目部门分摊月表 builder.Clear(); builder.AppendItem(PersonBaseFeeDepartmentProjectMonthInfoDBConst.YearMonth, yearMonth); foreach (PersonBaseFeeDepartmentProjectMonthInfo personFeeDepartmentProjectMonthInfo in PersonBaseFeeDepartmentProjectInfoAdapter.Instance.GetPersonBaseFeeDepartmentProjectInfoList(yearMonth, builder)) { personFeeDepartmentProjectMonthInfo.YearMonth = yearMonthD; sql.Append(ORMapping.GetInsertSql(personFeeDepartmentProjectMonthInfo, BuilderEx.TSqlBuilderInstance)); sql.Append(";"); } //工资项目月表 builder.Clear(); builder.AppendItem(FeeMonthInfoDBConst.YearMonth, yearMonth); foreach (FeeMonthInfo feeMonthInfo in FeeInfoAdapter.Instance.GetFeeInfoList(yearMonth, builder)) { feeMonthInfo.YearMonth = yearMonthD; sql.Append(ORMapping.GetInsertSql(feeMonthInfo, BuilderEx.TSqlBuilderInstance)); sql.Append(";"); } //税率月表 builder.Clear(); builder.AppendItem(TaxMonthInfoDBConst.YearMonth, yearMonth); foreach (TaxMonthInfo taxMonthInfo in TaxInfoAdapter.Instance.GetTaxInfoList(yearMonth, builder)) { taxMonthInfo.YearMonth = yearMonthD; sql.Append(ORMapping.GetInsertSql(taxMonthInfo, BuilderEx.TSqlBuilderInstance)); sql.Append(";"); } int result = _DataHelper.ExecuteSql(sql.ToString()); 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; } }
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); } }
private void InitializeCalculateExpFeeListBox() { List<FeeInfo> feeList = new List<FeeInfo>(), feeListNew = new List<FeeInfo>(); WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder(); if (action != ActionType.Add) {//if (this.ddlFee.SelectedIndex > 0){} //为完成:如果打开后又选了重新选择了父项目或改了项目编码怎么办? builder.AppendItem(FeeInfoDBConst.FeeID, feeID, "<>"); builder.AppendItem(FeeInfoDBConst.ParentID, feeID, "<>"); builder.AppendItem(FeeInfoDBConst.CalculateExp, String.Concat(@"%\[", feeID, @"\]%##ESCAPE##"), " NOT LIKE "); } builder.AppendItem(FeeInfoDBConst.FeeType, FeeType.Sum.ToString("D"));//计算型 feeList = this.ReCreateFeeID(FeeInfoAdapter.Instance.GetFeeInfoList(yearMonth, builder).Where(fee => !fee.UseFlag == bool.Parse(Status.True.ToString())).ToList()); Tools.ListBoxDataBind(this.litbCalculateFee, feeList, FeeInfoConst.FeeName, FeeInfoConst.FeeID); builder.Clear(); builder.AppendItem(FeeInfoDBConst.FeeType, FeeType.Common.ToString("D"));//组成型 feeList = this.ReCreateFeeID(FeeInfoAdapter.Instance.GetFeeInfoList(yearMonth, builder).Where(fee => !fee.UseFlag == bool.Parse(Status.True.ToString())).ToList()); Tools.ListBoxDataBind(this.litbCommonFee, feeList, FeeInfoConst.FeeName, FeeInfoConst.FeeID); builder.Clear(); builder.AppendItem(FeeInfoDBConst.FeeType, FeeType.Parameter.ToString("D"));//参数型 feeList = this.ReCreateFeeID(FeeInfoAdapter.Instance.GetFeeInfoList(yearMonth, builder).Where(parent => (!parent.UseFlag == bool.Parse(Status.True.ToString())) && (parent.ParentID == "" || parent.ParentID == null)).ToList()); Tools.ListBoxDataBind(this.litbParameterFee, feeList, FeeInfoConst.FeeName, FeeInfoConst.FeeID); builder.Clear(); builder.AppendItem(FeeInfoDBConst.FeeType, FeeType.Tax.ToString("D"));//个税型 feeList = this.ReCreateFeeID(FeeInfoAdapter.Instance.GetFeeInfoList(yearMonth, builder).Where(parent => (!parent.UseFlag == bool.Parse(Status.True.ToString())) && (parent.ParentID == "" || parent.ParentID == null)).ToList()); Tools.ListBoxDataBind(this.litbTaxFee, feeList, FeeInfoConst.FeeName, FeeInfoConst.FeeID); Tools.ListBoxDataBindByEnum(this.litbFunction, typeof(FeeFunction), false);//函数 }
protected void gvBaseList_DataBound(object sender, EventArgs e) { GridView gvList = (GridView)sender; if (!(gvList.Rows.Count == 1 && (gvList.Rows[0].Cells[0].Text == SalaryConst.EmptyText || gvList.DataKeys[0].Value == null))) { ImageButton ibtnEdit; Label lblFeeName; WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder(); String strAddSpace = String.Empty; Double sumValue = 0.00; for (Int32 i = 0; i < gvList.Rows.Count; i++) { String strFeeCode = gvList.DataKeys[i].Values[FeeInfoConst.FeeCode].ToString(); String strFeeID = gvList.DataKeys[i].Values[FeeInfoConst.FeeID].ToString(); lblFeeName = gvList.Rows[i].FindControl("lblFeeName") as Label; //缩进 strAddSpace = SalaryAppAdapter.Instance.AddSpaceInFrontOfFeeName(strFeeCode); lblFeeName.Text = strAddSpace + gvList.DataKeys[i].Values[FeeInfoConst.FeeName].ToString(); //gvList.Rows[i].Cells[0].Text = strAddSpace + gvList.DataKeys[i].Values[FeeInfoConst.FeeName].ToString(); builder.AppendItem(FeeInfoDBConst.ParentID, strFeeID); if (FeeInfoAdapter.Instance.GetFeeInfoList(this.yearMonth, builder).Any()) { //gvList.Rows[i].Cells[1].Text = ""; ibtnEdit = gvList.Rows[i].FindControl("btnCommonEdit") as ImageButton; ibtnEdit.Visible = false; //ibtnAddChild = gvList.Rows[i].FindControl("ibtnSave") as ImageButton; //ibtnAddChild.Visible = false; } builder.Clear(); if (strAddSpace.Length == 0) { sumValue += Double.Parse(gvList.DataKeys[i].Values[PersonBaseFeeInfoConst.FeeValue].ToString()); } } gvList.FooterRow.Cells[1].Text = sumValue.ToString("n");//"#,##0.00" } }