private void BindGrid() { PmsProjectCommitmentHitRateBiz pmsProjectCommitmentHitRateBiz = new PmsProjectCommitmentHitRateBiz(); PmsProjectCommitmentHitRate pmsProjectCommitmentHitRate = new PmsProjectCommitmentHitRate(); pmsProjectCommitmentHitRate.Month = Month; pmsProjectCommitmentHitRate.Week = Week; pmsProjectCommitmentHitRate.UserDept = UserDept; pmsProjectCommitmentHitRate.Status = Status; GridViewRequirement.EmptyDataText = "No Data."; IList <PmsProjectCommitmentHitRate> pmsProjectCommitmentHitRateList = pmsProjectCommitmentHitRateBiz.GetPmsProjectCommitmentHitRateList(pmsProjectCommitmentHitRate); if (pmsProjectCommitmentHitRateList != null) { foreach (var projectCommitmentHitRate in pmsProjectCommitmentHitRateList) { if (projectCommitmentHitRate.Status == "OnSchedule") { projectCommitmentHitRate.Status = "On-Schedule"; } } } GridViewRequirement.DataSource = pmsProjectCommitmentHitRateList; GridViewRequirement.DataBind(); }
public bool InsertPmsProjectCommitmentHitRate(IList <PmsProjectCommitmentHitRate> listPmsProjectCommitmentHitRate) { try { m_PMSSqlConnection.BeginTransaction(); if (listPmsProjectCommitmentHitRate.Count > 0) { PmsProjectCommitmentHitRate pmsProjectCommitmentHitRate = listPmsProjectCommitmentHitRate.FirstOrDefault(); m_PMSSqlConnection.Delete("DeletePmsProjectCommitmentHitRate", pmsProjectCommitmentHitRate); } foreach (var pmsProjectCommitmentHitRate in listPmsProjectCommitmentHitRate) { if (pmsProjectCommitmentHitRate.UserDept == null) { pmsProjectCommitmentHitRate.UserDept = ""; } m_PMSSqlConnection.Insert("InsertPmsProjectCommitmentHitRate", pmsProjectCommitmentHitRate); } m_PMSSqlConnection.CommitTransaction(); return(true); } catch (Exception ex) { m_PMSSqlConnection.RollBackTransaction(); m_Logger.Error("PmsRequirementBiz/InsertPmsRequirement:" + ex.ToString()); return(false); } }
private void InsertProjectCommitmentHitRate() { IList <string> weeks = new List <string>(); IList <string> months = GetMonths(); foreach (string month in months) { PmsProjectCommitmentHitRateBiz pmsProjectCommitmentHitRateBiz = new PmsProjectCommitmentHitRateBiz(); PmsProjectCommitmentHitRate pmsProjectCommitmentHitRate = new PmsProjectCommitmentHitRate(); IList <PmsProjectCommitmentHitRate> listPmsProjectCommitmentHitRate; if (DropDownListStatisticsInterval.SelectedValue.Trim() == "Bi-weekly") { weeks = GetWeeks(month); foreach (string week in weeks) { pmsProjectCommitmentHitRate.Week = week; pmsProjectCommitmentHitRate.UserDept = DropDownListUserDept.SelectedValue.Trim(); listPmsProjectCommitmentHitRate = pmsProjectCommitmentHitRateBiz.GetProjectCommitmentHitRatePmsHead(pmsProjectCommitmentHitRate); if (listPmsProjectCommitmentHitRate == null || listPmsProjectCommitmentHitRate.Count == 0) { return; } listPmsProjectCommitmentHitRate = SetListPmsProjectCommitmentHitRate(listPmsProjectCommitmentHitRate, month, week); pmsProjectCommitmentHitRateBiz.InsertPmsProjectCommitmentHitRate(listPmsProjectCommitmentHitRate); } } else { pmsProjectCommitmentHitRate.Month = month; pmsProjectCommitmentHitRate.UserDept = DropDownListUserDept.SelectedValue.Trim(); listPmsProjectCommitmentHitRate = pmsProjectCommitmentHitRateBiz.GetProjectCommitmentHitRatePmsHead(pmsProjectCommitmentHitRate); if (listPmsProjectCommitmentHitRate == null || listPmsProjectCommitmentHitRate.Count == 0) { return; } listPmsProjectCommitmentHitRate = SetListPmsProjectCommitmentHitRate(listPmsProjectCommitmentHitRate, month, pmsProjectCommitmentHitRate.Week); pmsProjectCommitmentHitRateBiz.InsertPmsProjectCommitmentHitRate(listPmsProjectCommitmentHitRate); } } }
public IList <PmsProjectCommitmentHitRate> GetPmsProjectCommitmentHitRateList(PmsProjectCommitmentHitRate pmsProjectCommitmentHitRate) { try { return(m_PMSSqlConnection.QueryForList <PmsProjectCommitmentHitRate>("SelectPmsProjectCommitmentHitRate", pmsProjectCommitmentHitRate)); } catch (Exception ex) { m_Logger.Error("PmsRequirementBiz/SelectPmsRequirement:" + ex.ToString()); return(null); } }
public IList <PmsProjectCommitmentHitRate> GetProjectCommitmentHitRatePmsHead(PmsProjectCommitmentHitRate pmsProjectCommitmentHitRate) { try { if (pmsProjectCommitmentHitRate.UserDept.Contains("AIC")) { pmsProjectCommitmentHitRate.UserDept = "AIC%"; } return(m_PMSSqlConnection.QueryForList <PmsProjectCommitmentHitRate>("SelecProjectCommitmentHitRatePmsHead", pmsProjectCommitmentHitRate)); } catch (Exception ex) { m_Logger.Error("PmsRequirementBiz/SelectPmsRequirement:" + ex.ToString()); return(null); } }