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, "");
}
}
