public static int GetBudgetControlPower(string projectCode) { int num2; try { ProjectConfigStrategyBuilder builder = new ProjectConfigStrategyBuilder(); builder.AddStrategy(new Strategy(ProjectConfigStrategyName.ProjectCode, projectCode)); string queryString = builder.BuildMainQueryString(); QueryAgent agent = new QueryAgent(); EntityData data = agent.FillEntityData("ProjectConfig", queryString); agent.Dispose(); DataRow[] rowArray = data.CurrentTable.Select(string.Format(" ConfigName='BudgetControl'", new object[0])); int num = 2; if ((rowArray.Length > 0) && !rowArray[0].IsNull("ConfigData")) { num = int.Parse((string)rowArray[0]["ConfigData"]); } data.Dispose(); num2 = num; } catch (Exception exception) { throw exception; } return(num2); }
public static string GetProjectConfigValue(string ProjectCode, string ConfigName) { string text3; try { string text = ""; ProjectConfigStrategyBuilder builder = new ProjectConfigStrategyBuilder(); builder.AddStrategy(new Strategy(ProjectConfigStrategyName.ProjectCode, ProjectCode)); builder.AddStrategy(new Strategy(ProjectConfigStrategyName.ConfigName, ConfigName)); string queryString = builder.BuildMainQueryString(); QueryAgent agent = new QueryAgent(); EntityData data = agent.FillEntityData("ProjectConfig", queryString); agent.Dispose(); if (data.HasRecord()) { text = data.GetString("ConfigData"); } data.Dispose(); text3 = text; } catch (Exception exception) { throw exception; } return(text3); }
public static void UpdateProjectConfigValue(string ProjectCode, string ConfigName, object ConfigData) { try { DataRow currentRow; ProjectConfigStrategyBuilder builder = new ProjectConfigStrategyBuilder(); builder.AddStrategy(new Strategy(ProjectConfigStrategyName.ProjectCode, ProjectCode)); builder.AddStrategy(new Strategy(ProjectConfigStrategyName.ConfigName, ConfigName)); string queryString = builder.BuildMainQueryString(); QueryAgent agent = new QueryAgent(); EntityData entity = agent.FillEntityData("ProjectConfig", queryString); agent.Dispose(); if (entity.HasRecord()) { currentRow = entity.CurrentRow; } else { currentRow = entity.CurrentTable.NewRow(); currentRow["ProjectConfigCode"] = SystemManageDAO.GetNewSysCode("ProjectConfigCode"); currentRow["ProjectCode"] = ProjectCode; currentRow["ConfigName"] = ConfigName; entity.CurrentTable.Rows.Add(currentRow); } currentRow["ConfigData"] = ConfigData; SystemManageDAO.SubmitAllProjectConfig(entity); entity.Dispose(); } catch (Exception exception) { throw exception; } }
private void LoadData() { string projectCode = Request["ProjectCode"] + ""; try { ProjectConfigStrategyBuilder sb = new ProjectConfigStrategyBuilder(); sb.AddStrategy(new Strategy(ProjectConfigStrategyName.ProjectCode, projectCode)); string sql = sb.BuildMainQueryString(); QueryAgent qa = new QueryAgent(); EntityData projectConfig = qa.FillEntityData("ProjectConfig", sql); qa.Dispose(); DataRow[] drSelects = projectConfig.CurrentTable.Select(String.Format(" ConfigName='ContractOldMoney'")); if (drSelects.Length > 0) { if (!drSelects[0].IsNull("ConfigData")) { this.rblProportion.SelectedValue = (string)drSelects[0]["ConfigData"]; } } projectConfig.Dispose(); } catch (Exception ex) { ApplicationLog.WriteLog(this.ToString(), ex, ""); } }
private void LoadData() { string projectCode = Request["ProjectCode"] + ""; try { int totalPeriods = 0; int periodMonth = 12; ProjectConfigStrategyBuilder sb = new ProjectConfigStrategyBuilder(); sb.AddStrategy(new Strategy(ProjectConfigStrategyName.ProjectCode, projectCode)); string sql = sb.BuildMainQueryString(); QueryAgent qa = new QueryAgent(); EntityData projectConfig = qa.FillEntityData("ProjectConfig", sql); qa.Dispose(); DataRow[] drSelects = projectConfig.CurrentTable.Select(String.Format(" ConfigName='PeriodMonth'")); if (drSelects.Length > 0) { if (!drSelects[0].IsNull("ConfigData")) { periodMonth = int.Parse((string)drSelects[0]["ConfigData"]); this.sltPeriodMonth.Value = periodMonth.ToString(); } } drSelects = projectConfig.CurrentTable.Select(String.Format(" ConfigName='TotalPeriods'")); if (drSelects.Length > 0) { if (!drSelects[0].IsNull("ConfigData")) { totalPeriods = int.Parse((string)drSelects[0]["ConfigData"]); this.sltTotalPeriods.Value = totalPeriods.ToString(); } } projectConfig.Dispose(); EntityData periodDefine = DAL.EntityDAO.SystemManageDAO.GetPeriodDefineByProjectCode(projectCode); this.dgYearName.DataSource = new DataView(periodDefine.CurrentTable, "", "PeriodIndex", DataViewRowState.CurrentRows); this.dgYearName.DataBind(); Session["PeriodDefineData"] = periodDefine; Session["totalPeriods"] = totalPeriods.ToString(); Session["periodMonth"] = periodMonth.ToString(); periodDefine.Dispose(); } catch (Exception ex) { ApplicationLog.WriteLog(this.ToString(), ex, ""); } }
protected void btnSave_ServerClick(object sender, System.EventArgs e) { string projectCode = Request["ProjectCode"] + ""; try { ProjectConfigStrategyBuilder sb = new ProjectConfigStrategyBuilder(); sb.AddStrategy(new Strategy(ProjectConfigStrategyName.ProjectCode, projectCode)); string sql = sb.BuildMainQueryString(); QueryAgent qa = new QueryAgent(); EntityData projectConfig = qa.FillEntityData("ProjectConfig", sql); qa.Dispose(); DataRow[] drSelects = projectConfig.CurrentTable.Select(String.Format(" ConfigName='ContractOldMoney'")); DataRow drC = null; if (drSelects.Length > 0) { drC = drSelects[0]; } else { drC = projectConfig.GetNewRecord(); drC["ProjectConfigCode"] = DAL.EntityDAO.SystemManageDAO.GetNewSysCode("ProjectConfigCode"); drC["ProjectCode"] = projectCode; drC["ConfigName"] = "ContractOldMoney"; projectConfig.AddNewRecord(drC); } drC["ConfigData"] = this.rblProportion.SelectedValue; DAL.EntityDAO.SystemManageDAO.SubmitAllProjectConfig(projectConfig); projectConfig.Dispose(); Response.Write(Rms.Web.JavaScript.ScriptStart); Response.Write(Rms.Web.JavaScript.WinClose(false)); Response.Write(Rms.Web.JavaScript.ScriptEnd); Response.End(); } catch (Exception ex) { ApplicationLog.WriteLog(this.ToString(), ex, ""); } }
protected void btnSave_ServerClick(object sender, System.EventArgs e) { string projectCode = Request["ProjectCode"] + ""; try { int totalPeriods = int.Parse((string)Session["totalPeriods"]); int periodMonths = int.Parse((string)Session["periodMonth"]); EntityData periodDefine = (EntityData)Session["PeriodDefineData"]; foreach (DataGridItem li in this.dgYearName.Items) { string code = li.Cells[0].Text; string name = ((HtmlInputText)li.FindControl("txtYearName")).Value.Trim(); foreach (DataRow dr in periodDefine.CurrentTable.Select(String.Format("PeriodDefineCode='{0}'", code), "", DataViewRowState.CurrentRows)) { dr["PeriodName"] = name; } } DAL.EntityDAO.SystemManageDAO.SubmitAllPeriodDefine(periodDefine); periodDefine.Dispose(); ProjectConfigStrategyBuilder sb = new ProjectConfigStrategyBuilder(); sb.AddStrategy(new Strategy(ProjectConfigStrategyName.ProjectCode, projectCode)); string sql = sb.BuildMainQueryString(); QueryAgent qa = new QueryAgent(); EntityData projectConfig = qa.FillEntityData("ProjectConfig", sql); qa.Dispose(); DataRow[] drSelects = projectConfig.CurrentTable.Select(String.Format(" ConfigName='TotalPeriods'")); DataRow drC = null; if (drSelects.Length > 0) { drC = drSelects[0]; } else { drC = projectConfig.GetNewRecord(); drC["ProjectConfigCode"] = DAL.EntityDAO.SystemManageDAO.GetNewSysCode("ProjectConfigCode"); drC["ProjectCode"] = projectCode; drC["ConfigName"] = "TotalPeriods"; projectConfig.AddNewRecord(drC); } drC["ConfigData"] = totalPeriods.ToString(); drSelects = projectConfig.CurrentTable.Select(String.Format(" ConfigName='PeriodMonths'")); drC = null; if (drSelects.Length > 0) { drC = drSelects[0]; } else { drC = projectConfig.GetNewRecord(); drC["ProjectConfigCode"] = DAL.EntityDAO.SystemManageDAO.GetNewSysCode("ProjectConfigCode"); drC["ProjectCode"] = projectCode; drC["ConfigName"] = "PeriodMonths"; projectConfig.AddNewRecord(drC); } drC["ConfigData"] = periodMonths.ToString(); DAL.EntityDAO.SystemManageDAO.SubmitAllProjectConfig(projectConfig); projectConfig.Dispose(); Session["PeriodDefineData"] = null; Response.Write(Rms.Web.JavaScript.ScriptStart); Response.Write(Rms.Web.JavaScript.Alert(false, "设置完成 !")); Response.Write(Rms.Web.JavaScript.WinClose(false)); Response.Write(Rms.Web.JavaScript.ScriptEnd); Response.End(); } catch (Exception ex) { ApplicationLog.WriteLog(this.ToString(), ex, ""); } }
private void LoadData() { string projectCode = Request["ProjectCode"] + ""; try { int periodMonth = 12; int totalPeriods = 0; int currentPeriodIndex = 0; int periodIndex = 1; // 取项目的计划定义 EntityData planData = DAL.EntityDAO.SystemManageDAO.GetPeriodDefineByProjectCode(projectCode); if (!planData.HasRecord()) { planData.Dispose(); Response.Write(Rms.Web.JavaScript.ScriptStart); Response.Write(Rms.Web.JavaScript.Alert(false, "请先在系统管理中定义项目的计划 !")); Response.Write(Rms.Web.JavaScript.WinClose(false)); Response.Write(Rms.Web.JavaScript.ScriptEnd); Response.End(); } // 取项目定义 ProjectConfigStrategyBuilder sb = new ProjectConfigStrategyBuilder(); sb.AddStrategy(new Strategy(ProjectConfigStrategyName.ProjectCode, projectCode)); string sql = sb.BuildMainQueryString(); QueryAgent qa = new QueryAgent(); EntityData projectConfig = qa.FillEntityData("ProjectConfig", sql); DataRow[] drSelects = projectConfig.CurrentTable.Select(String.Format(" ConfigName='PeriodMonth'")); if (drSelects.Length > 0) { if (!drSelects[0].IsNull("ConfigData")) { periodMonth = int.Parse((string)drSelects[0]["ConfigData"]); } } projectConfig.Dispose(); drSelects = projectConfig.CurrentTable.Select(String.Format(" ConfigName='TotalPeriods'")); if (drSelects.Length > 0) { if (!drSelects[0].IsNull("ConfigData")) { totalPeriods = int.Parse((string)drSelects[0]["ConfigData"]); } } projectConfig.Dispose(); this.txtTotalPeriods.Value = totalPeriods.ToString(); this.txtPeriodMonth.Value = periodMonth.ToString(); // 检查所有预算,如果最新的预算是没有审核过的新预算, 就跳到这个预算 // 否则计算下一个预算Index,进入这个预算中 BudgetStrategyBuilder sb0 = new BudgetStrategyBuilder(); sb0.AddStrategy(new Strategy(BudgetStrategyName.ProjectCode, projectCode)); sb0.AddStrategy(new Strategy(BudgetStrategyName.IsDynamic, "0")); sb0.AddStrategy(new Strategy(BudgetStrategyName.Flag, "0,1,2")); sb0.AddOrder("MakeDate", false); sql = sb0.BuildMainQueryString(); EntityData budget = qa.FillEntityData("Budget", sql); qa.Dispose(); int iCurrentYear = DateTime.Now.Year; if (budget.HasRecord()) { int flag = budget.GetInt("Flag"); currentPeriodIndex = budget.GetInt("PeriodIndex"); int iYear = budget.GetInt("IYear"); string budgetCode = budget.GetString("BudgetCode"); budget.Dispose(); if (flag == 1) { Response.Write(Rms.Web.JavaScript.ScriptStart); Response.Write("window.opener.navigate( '../Cost/Budget.aspx?IsDynamic=0&BudgetCode='" + budgetCode + " );"); Response.Write("window.close();"); Response.Write(Rms.Web.JavaScript.ScriptEnd); return; } } periodIndex = currentPeriodIndex + 1; this.txtPeriodIndex.Value = periodIndex.ToString(); DataRow[] drsPlan = planData.CurrentTable.Select(String.Format(" PeriodIndex={0} ", periodIndex)); if (drsPlan.Length == 0) { planData.Dispose(); Response.Write(Rms.Web.JavaScript.ScriptStart); Response.Write(Rms.Web.JavaScript.Alert(false, "请先在系统管理中定义项目的计划 !")); Response.Write(Rms.Web.JavaScript.WinClose(false)); Response.Write(Rms.Web.JavaScript.ScriptEnd); Response.End(); } DateTime dtStart = (DateTime)drsPlan[0]["StartDate"]; DateTime dtEnd = (DateTime)drsPlan[0]["EndDate"]; this.txtStartDate.Value = dtStart.ToString("yyyy-MM-dd"); this.txtEndDate.Value = dtEnd.ToString("yyyy-MM-dd"); this.txtbudgetName.Value = dtStart.Year.ToString() + "年 年度预算"; budget.Dispose(); planData.Dispose(); } catch (Exception ex) { ApplicationLog.WriteLog(this.ToString(), ex, ""); } }