public static void UpdateUniSalProjectCode(string SalProjectCode, string ProjectCode)
{
try
{
if (SalProjectCode != "")
{
ProjectStrategyBuilder builder = new ProjectStrategyBuilder();
builder.AddStrategy(new Strategy(ProjectStrategyName.SalProjectCode, SalProjectCode));
builder.AddStrategy(new Strategy(ProjectStrategyName.ProjectCodeNot, ProjectCode));
string queryString = builder.BuildMainQueryString();
QueryAgent agent = new QueryAgent();
EntityData data = agent.FillEntityData("Project", queryString);
agent.Dispose();
if (data.HasRecord())
{
foreach (DataRow row in data.CurrentTable.Rows)
{
string text2 = row["ProjectCode"].ToString();
agent.ExecuteScalar(string.Format("update project set SalProjectCode = '' where ProjectCode = '{0}'", text2));
}
}
data.Dispose();
}
}
catch (Exception exception)
{
throw exception;
}
}
public static bool IsProjectNameExists(string name, string code)
{
bool flag2;
try
{
bool flag = false;
ProjectStrategyBuilder builder = new ProjectStrategyBuilder();
builder.AddStrategy(new Strategy(ProjectStrategyName.ProjectName, name));
builder.AddStrategy(new Strategy(ProjectStrategyName.ProjectCodeNot, code));
string queryString = builder.BuildMainQueryString();
QueryAgent agent = new QueryAgent();
EntityData data = agent.FillEntityData("Project", queryString);
agent.Dispose();
if (data.HasRecord())
{
flag = true;
}
flag2 = flag;
}
catch (Exception exception)
{
throw exception;
}
return(flag2);
}
public static DataTable GetAllProject()
{
DataTable currentTable;
try
{
ProjectStrategyBuilder builder = new ProjectStrategyBuilder();
QueryAgent agent = new QueryAgent();
EntityData data = agent.FillEntityData("Project", builder.BuildMainQueryString());
agent.Dispose();
currentTable = data.CurrentTable;
}
catch (Exception exception)
{
throw exception;
}
return(currentTable);
}
public static EntityData GetProjectByUnit(string unitCode)
{
EntityData data2;
try
{
ProjectStrategyBuilder builder = new ProjectStrategyBuilder();
builder.AddStrategy(new Strategy(ProjectStrategyName.UnitCode, unitCode));
QueryAgent agent = new QueryAgent();
EntityData data = agent.FillEntityData("Project", builder.BuildMainQueryString());
agent.Dispose();
data2 = data;
}
catch (Exception exception)
{
throw exception;
}
return(data2);
}
protected void btnInput_ServerClick(object sender, System.EventArgs e)
{
string inputProjectName = this.txtInputProjectName.Value.Trim();
string projectCode = Request["ProjectCode"] + "";
if (inputProjectName == "")
{
Response.Write(Rms.Web.JavaScript.Alert(true, "请输入项目源项目名称 ！"));
}
try
{
// 找到输入的源项目
ProjectStrategyBuilder sb = new ProjectStrategyBuilder();
sb.AddStrategy(new Strategy(ProjectStrategyName.ProjectName, inputProjectName));
string sql = sb.BuildMainQueryString();
QueryAgent qa = new QueryAgent();
EntityData inputProjectEntity = qa.FillEntityData("Project", sql);
qa.Dispose();
string inputProjectCode = "";
if (inputProjectEntity.HasRecord())
{
inputProjectCode = inputProjectEntity.GetString("ProjectCode");
}
inputProjectEntity.Dispose();
if (inputProjectCode == "")
{
Rms.Web.JavaScript.Alert(true, "没有找到这个项目：" + inputProjectName + "， 请输入完整正确的名称 ！ ");
return;
}
// 删除本项目中的字典项
EntityData entityItem = DAL.EntityDAO.SystemManageDAO.GetDictionaryItemByProjectCode(projectCode);
entityItem.DeleteAllTableRow("DictionaryItem");
DAL.EntityDAO.SystemManageDAO.DeleteDictionaryItem(entityItem);
entityItem.Dispose();
EntityData entityName = RmsPM.DAL.EntityDAO.SystemManageDAO.GetDictionaryNameByProjectCode(projectCode);
entityName.DeleteAllTableRow("DictionaryName");
DAL.EntityDAO.SystemManageDAO.DeleteDictionaryName(entityName);
entityName.Dispose();
// 复制源项目中的内容
EntityData entityInputName = RmsPM.DAL.EntityDAO.SystemManageDAO.GetDictionaryNameByProjectCode(inputProjectCode);
EntityData entity = new EntityData("Standard_DictionaryName");
int iCount = entityInputName.CurrentTable.Rows.Count;
for (int i = 0; i < iCount; i++)
{
entityInputName.SetCurrentRow(i);
string dictionaryNameCodeInput = entityInputName.GetString("DictionaryNameCode");
EntityData entityInput = DAL.EntityDAO.SystemManageDAO.GetStandard_DictionaryNameByCode(dictionaryNameCodeInput);
string dictionaryNameCode = DAL.EntityDAO.SystemManageDAO.GetNewSysCode("DictionaryNameCode");
entity.SetCurrentTable("DictionaryName");
DataRow dr = entity.GetNewRecord();
dr["Name"] = entityInput.CurrentRow["Name"];
dr["Remark"] = entityInput.CurrentRow["Remark"];
dr["ProjectCode"] = projectCode;
dr["DictionaryNameCode"] = dictionaryNameCode;
entity.AddNewRecord(dr);
entity.SetCurrentTable("DictionaryItem");
entityInput.SetCurrentTable("DictionaryItem");
int iICount = entityInput.CurrentTable.Rows.Count;
for (int j = 0; j < iICount; j++)
{
entityInput.SetCurrentRow(j);
DataRow drItem = entity.Tables["DictionaryItem"].NewRow();
drItem["DictionaryItemCode"] = DAL.EntityDAO.SystemManageDAO.GetNewSysCode("DictionaryItemCode");
drItem["Name"] = entityInput.CurrentRow["Name"];
drItem["SortID"] = entityInput.CurrentRow["SortID"];
drItem["ProjectCode"] = projectCode;
drItem["DictionaryNameCode"] = dictionaryNameCode;
entity.Tables["DictionaryItem"].Rows.Add(drItem);
}
entityInput.Dispose();
}
DAL.EntityDAO.SystemManageDAO.SubmitAllStandard_DictionaryName(entity);
entity.Dispose();
entityInputName.Dispose();
Response.Write(Rms.Web.JavaScript.ScriptStart);
Response.Write(Rms.Web.JavaScript.Alert(false, "导入成功 ！"));
Response.Write(Rms.Web.JavaScript.PageTo(false, "Dictionary.aspx?ProjectCode=" + projectCode));
Response.Write(Rms.Web.JavaScript.ScriptEnd);
Response.End();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(Rms.Web.JavaScript.Alert(true, "导入出错"));
}
}
