protected void LoadProject() { int totalRowsCount = 0; AspNetPager1.PageSize = 10; StringBuilder sbWhere = new StringBuilder(); string anyCondition = txtAnyCondition.Text.Trim(); if (!string.IsNullOrEmpty(anyCondition)) { sbWhere.Append(anyCondition); } DataTable dtProject = prjDal.GetProjectForEmployeeHome(Convert.ToString(EmployeeID ?? string.Empty), sbWhere.ToString(), AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, out totalRowsCount); if (dtProject != null && dtProject.Rows.Count > 0) { StringBuilder sbPrjId = new StringBuilder(); dtProject.AsEnumerable().Select(item => (string)item["prjID"]).ToList().ForEach(item => sbPrjId.AppendFormat("'{0}',", item)); projectIdNeed = sbPrjId.ToString().TrimEnd(','); lstTcje = new TransactionDetailsBLL().GetModelList(" AND employeeId = '" + Convert.ToString(EmployeeID ?? string.Empty) + "' AND TRANSACTIONTYPE = 7 AND PROJECTID IN (" + projectIdNeed + ") "); lstPrjProportion = new ProjectProportionBLL().GetModelList(" projectId IN (" + projectIdNeed + ")"); } empProportion = epBll.GetModelList(" AND EMPLOYEEID = '" + Convert.ToString(EmployeeID ?? string.Empty) + "'").FirstOrDefault(); if (string.IsNullOrEmpty(sbWhere.ToString())) { lblFinishedTaskCount.Text = string.Format("{0}", totalRowsCount); } AspNetPager1.RecordCount = totalRowsCount; gvProject.DataSource = dtProject; gvProject.DataBind(); gvProject.Columns[1].Visible = IsExternal; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string prjID = Request.QueryString["prjID"].ToString(); decimal amount = Convert.ToDecimal(Request.QueryString["amount"]); string parentEmployeeID = Convert.ToString(Request.QueryString["parentEmployeeID"]); string where = " AND employeeId = '" + parentEmployeeID + "'"; decimal proportion = 0m; ProjectProportion projectProportion = new ProjectProportionBLL().GetModelList(" projectId = '" + prjID + "'").FirstOrDefault(); if (projectProportion != null) { proportion = projectProportion.PROPORTION ?? 0m; } else { EmployeeProportion empPro = epBll.GetModelList(where).FirstOrDefault(); proportion = empPro?.PROPORTION ?? 0m; } hidAmount.Value = lblAmount.Text = (amount * proportion).ToString(); LoadCanTransferEmp(); } }