public static string GetUnitByProject(string projectCode)
{
string text3;
try
{
string text = "";
if (projectCode == "")
{
return(text);
}
UnitStrategyBuilder builder = new UnitStrategyBuilder();
builder.AddStrategy(new Strategy(UnitStrategyName.RelaCode, projectCode));
string queryString = builder.BuildMainQueryString();
QueryAgent agent = new QueryAgent();
EntityData data = agent.FillEntityData("Unit", queryString);
agent.Dispose();
if (data.HasRecord())
{
text = data.GetString("UnitCode");
}
data.Dispose();
text3 = text;
}
catch (Exception exception)
{
throw exception;
}
return(text3);
}
private void LoadData()
{
RemindObjectStrategyBuilder rsb = new RemindObjectStrategyBuilder();
rsb.AddStrategy(new Strategy(DAL.QueryStrategy.RemindObjectName.User, ((User)Session["User"]).UserCode));
if (this.txtRemindMessage.Value.Trim().Length > 0)
{
rsb.AddStrategy(new Strategy(DAL.QueryStrategy.RemindObjectName.Message, this.txtRemindMessage.Value));
}
if (this.ddlRemindType.SelectedIndex > 0)
{
rsb.AddStrategy(new Strategy(DAL.QueryStrategy.RemindObjectName.Type, this.ddlRemindType.SelectedValue));
}
if (this.dtbStartDate.Value != "")
{
rsb.AddStrategy(new Strategy(DAL.QueryStrategy.RemindObjectName.CreateDate, this.dtbStartDate.Value));
}
if (this.dtbEndDate.Value != "")
{
rsb.AddStrategy(new Strategy(DAL.QueryStrategy.RemindObjectName.EndDate, this.dtbEndDate.Value));
}
rsb.AddOrder("CreateDate", false);
string sql = rsb.BuildMainQueryString();
QueryAgent qa = new QueryAgent();
EntityData entityRemind = qa.FillEntityData("RemindObject", sql);
qa.Dispose();
this.dgRemindList.DataSource = DisposeRemind(entityRemind.CurrentTable);
this.dgRemindList.DataBind();
this.trNoRemind.Visible = (this.dgRemindList.Items.Count > 0)?false:true;
}
public static string GetSelfAccountUnitName(string subjectSetCode)
{
string text3;
try
{
string text = "";
UnitStrategyBuilder builder = new UnitStrategyBuilder();
builder.AddStrategy(new Strategy(UnitStrategyName.SubjectSetCode, subjectSetCode));
builder.AddStrategy(new Strategy(UnitStrategyName.SelfAccount, "1"));
string queryString = builder.BuildMainQueryString();
QueryAgent agent = new QueryAgent();
EntityData data = agent.FillEntityData("Unit", queryString);
agent.Dispose();
if (data.HasRecord())
{
text = data.GetString("UnitName");
}
text3 = text;
}
catch (Exception exception)
{
throw exception;
}
return(text3);
}
private void LoadDataGrid()
{
try
{
string sql = (string)this.ViewState["SearchString"];
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("WorkFlowCommon", sql);
qa.Dispose();
DataView ud_dvWorkFlowCommon = new DataView(entity.CurrentTable);
ud_dvWorkFlowCommon.Sort = "WorkFlowID";
this.dgList.DataSource = ud_dvWorkFlowCommon;
this.dgList.DataBind();
this.GridPagination1.RowsCount = entity.CurrentTable.Rows.Count.ToString();
entity.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "加载通用流程列表错误。");
Response.Write(Rms.Web.JavaScript.Alert(true, "加载通用流程列表错误：" + ex.Message));
}
}
/// <summary>
/// 判断该用户是否能访问这个资源, 如果找不到该资源返回 true;
/// </summary>
/// <param name="code"></param>
/// <param name="operationCode"></param>
/// <returns></returns>
public bool HasResourceRight(string code, string operationCode)
{
if (!AvailableFunction.isAvailableFunction(operationCode))
{
return(false);
}
string classCode = operationCode.Substring(0, 4);
string resourceCode = BLL.ResourceRule.GetResourceCode(code, classCode);
if (resourceCode == "")
{
return(true);
}
AccessRangeStrategyBuilder sb = new AccessRangeStrategyBuilder();
sb.AddStrategy(new Strategy(AccessRangeStrategyName.ResourceCode, resourceCode));
ArrayList ar = new ArrayList();
ar.Add(this.m_UserCode);
ar.Add(BuildStationCodes());
sb.AddStrategy(new Strategy(AccessRangeStrategyName.AccessRelation1, ar));
sb.AddStrategy(new Strategy(AccessRangeStrategyName.OperationCode, operationCode));
QueryAgent qa = new QueryAgent();
string sql = sb.BuildMainQueryString();
EntityData entity = qa.FillEntityData("AccessRange", sql);
qa.Dispose();
bool canAccess = entity.HasRecord();
entity.Dispose();
return(canAccess);
}
public static EntityData GetLastConstructProgressReport(string PBSUnitCode, string EndDate, int n)
{
EntityData data2;
try
{
ConstructProgressStrategyBuilder builder = new ConstructProgressStrategyBuilder();
builder.AddStrategy(new Strategy(ConstructProgressStrategyName.PBSUnitCode, PBSUnitCode));
ArrayList pas = new ArrayList();
pas.Add("");
pas.Add(EndDate);
builder.AddStrategy(new Strategy(ConstructProgressStrategyName.ReportDateRange, pas));
builder.AddOrder("ReportDate", false);
builder.AddOrder("ProgressCode", false);
string queryString = builder.BuildQueryViewString();
QueryAgent agent = new QueryAgent();
agent.SetTopNumber(n);
EntityData data = agent.FillEntityData("ConstructProgress", queryString);
agent.Dispose();
data2 = data;
}
catch (Exception exception)
{
throw exception;
}
return(data2);
}
private void LoadData()
{
string projectCode = Request["ProjectCode"] + "";
try
{
string isDynamic = Request["IsDynamic"] + "";
BudgetStrategyBuilder sb = new BudgetStrategyBuilder();
sb.AddStrategy(new Strategy(BudgetStrategyName.ProjectCode, projectCode));
if (isDynamic != "")
{
sb.AddStrategy(new Strategy(BudgetStrategyName.IsDynamic, isDynamic));
}
string sql = sb.BuildMainQueryString();
QueryAgent qa = new QueryAgent();
qa.SetTopNumber(1);
EntityData budget = qa.FillEntityData("Budget", sql);
qa.Dispose();
this.dgList.DataSource = budget.CurrentTable;
this.dgList.DataBind();
budget.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "加载列表错误");
}
}
private void LoadDataGrid()
{
try
{
string sql = (string)this.ViewState["SqlString"];
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("V_Payout", sql);
qa.Dispose();
string[] arrField = { "Money" };
decimal[] arrSum = BLL.MathRule.SumColumn(entity.CurrentTable, arrField);
this.txtSumMoney.Value = arrSum[0].ToString("N");
this.dgList.DataSource = entity.CurrentTable;
this.dgList.DataBind();
this.gpControl.RowsCount = entity.CurrentTable.Rows.Count.ToString();
entity.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(Rms.Web.JavaScript.Alert(true, "显示列表出错：" + ex.Message));
}
}
/// <summary>
/// 装载图片列表
/// </summary>
/// <param name="_MasterType">MasterType</param>
/// <param name="_MasterCode">MasterCode</param>
private void LoadPicList(string _MasterType, string _MasterCode)
{
try
{
PBSPicStrategyBuilder sb = new PBSPicStrategyBuilder();
sb.AddStrategy(new Strategy(PBSPicStrategyName.MasterTypeEq, _MasterType));
sb.AddStrategy(new Strategy(PBSPicStrategyName.MasterCodeEq, _MasterCode));
sb.AddOrder("PBSPicCode", true);
string sql = sb.BuildMainQueryString();
QueryAgent qa = new QueryAgent();
EntityData enp = qa.FillEntityData("PBSPic", sql);
qa.Dispose();
this.dlPicList.DataSource = enp.CurrentTable;
this.dlPicList.DataBind();
enp.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
}
}
private void LoadData()
{
string sYear = Request["iYear"] + "";
string projectCode = Request["ProjectCode"] + "";
if (!Rms.Check.StringCheck.IsInt(sYear))
{
this.m_iYear = DateTime.Now.Year;
}
else
{
this.m_iYear = int.Parse(sYear);
}
string sMonth = Request["iMonth"] + "";
if (!Rms.Check.StringCheck.IsInt(sMonth))
{
this.m_Month = DateTime.Now.Month;
}
else
{
this.m_Month = DateTime.Now.Month;
}
// 计算本月最后一天和前一个月份最后一天
this.m_CurrentMonthLastDate = (new DateTime(this.m_iYear, this.m_Month, 1)).AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd");
this.m_BeforeMonthLastDate = (new DateTime(this.m_iYear, this.m_Month, 1)).AddDays(-1).ToString("yyyy-MM-dd");
this.lblProjectName.Text = BLL.ProjectRule.GetProjectName(projectCode);
this.lblYear.Text = this.m_iYear.ToString();
this.lblMonth.Text = this.m_Month.ToString();
try
{
this.m_Subject = DAL.EntityDAO.SubjectDAO.GetAllSubject();
VoucherDetailStrategyBuilder sb = new VoucherDetailStrategyBuilder();
sb.AddStrategy(new Strategy(VoucherDetailStrategyName.ProjectCode, projectCode));
string sql = sb.BuildQueryViewString();
QueryAgent qa = new QueryAgent();
this.m_VoucherDetail = qa.FillEntityData("VoucherDetail", sql);
qa.Dispose();
DataRow[] drsFirst = this.m_Subject.CurrentTable.Select("layer=1");
int iCount = drsFirst.Length;
for (int i = 0; i < iCount; i++)
{
DataRow dr = drsFirst[i];
BuildRow(dr);
}
this.m_Subject.Dispose();
this.m_VoucherDetail.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
}
}
public static bool IsPBSUnitNameExists(string name, string code, string ProjectCode)
{
bool flag2;
try
{
bool flag = false;
PBSUnitStrategyBuilder builder = new PBSUnitStrategyBuilder();
builder.AddStrategy(new Strategy(PBSUnitStrategyName.ProjectCode, ProjectCode));
builder.AddStrategy(new Strategy(PBSUnitStrategyName.PBSUnitName, name));
builder.AddStrategy(new Strategy(PBSUnitStrategyName.PBSUnitCodeNot, code));
string queryString = builder.BuildMainQueryString();
QueryAgent agent = new QueryAgent();
EntityData data = agent.FillEntityData("PBSUnit", queryString);
agent.Dispose();
if (data.HasRecord())
{
flag = true;
}
flag2 = flag;
}
catch (Exception exception)
{
throw exception;
}
return(flag2);
}
private void LoadDataGrid()
{
try
{
TempRoomOutStrategyBuilder sb = new TempRoomOutStrategyBuilder();
sb.AddStrategy(new Strategy(TempRoomOutStrategyName.ProjectCode, txtProjectCode.Value));
sb.AddStrategy(new Strategy(TempRoomOutStrategyName.InRoomCode, txtRoomCode.Value));
sb.AddOrder("Out_Date", false);
string sql = sb.BuildMainQueryString();
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("TempRoomOut", sql);
qa.Dispose();
dgList.DataSource = entity;
dgList.DataBind();
entity.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(Rms.Web.JavaScript.Alert(true, "显示列表出错：" + ex.Message));
}
}
private void LoadDataGrid()
{
try
{
PBSUnitStrategyBuilder sb = new PBSUnitStrategyBuilder();
string ProjectCode = this.txtProjectCode.Value;
if (ProjectCode != "")
{
sb.AddStrategy(new Strategy(PBSUnitStrategyName.ProjectCode, ProjectCode));
}
sb.AddOrder("PBSUnitName", true);
string sql = sb.BuildMainQueryString();
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("PBSUnit", sql);
qa.Dispose();
dgList.DataSource = entity;
dgList.DataBind();
entity.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(Rms.Web.JavaScript.Alert(true, "初始化页面出错：" + ex.Message));
}
}
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 EntityData GetConstructProgressReportFirstKg(string PBSUnitCode)
{
EntityData data2;
try
{
string visualProgressNotStartInStr = PBSRule.GetVisualProgressNotStartInStr();
ConstructProgressStrategyBuilder builder = new ConstructProgressStrategyBuilder();
builder.AddStrategy(new Strategy(ConstructProgressStrategyName.PBSUnitCode, PBSUnitCode));
builder.AddStrategy(new Strategy(ConstructProgressStrategyName.VisualProgressNotIn, visualProgressNotStartInStr));
builder.AddOrder("ReportDate", true);
builder.AddOrder("ProgressCode", true);
string queryString = builder.BuildQueryViewString();
QueryAgent agent = new QueryAgent();
agent.SetTopNumber(1);
EntityData data = agent.FillEntityData("ConstructProgress", queryString);
agent.Dispose();
data2 = data;
}
catch (Exception exception)
{
throw exception;
}
return(data2);
}
protected void btnDel_ServerClick(object sender, System.EventArgs e)
{
try
{
PBSPicStrategyBuilder sb = new PBSPicStrategyBuilder();
sb.AddStrategy(new Strategy(PBSPicStrategyName.MasterTypeEq, "PicGroupLarge"));
sb.AddStrategy(new Strategy(PBSPicStrategyName.MasterCodeEq, this.HidePBSPicGroupCode.Value.Trim()));
sb.AddOrder("PBSPicCode", true);
string sql = sb.BuildMainQueryString();
QueryAgent qa = new QueryAgent();
EntityData enp = qa.FillEntityData("PBSPic", sql);
qa.Dispose();
DAL.EntityDAO.PBSDAO.DeletePBSPic(enp);
enp.Dispose();
DAL.EntityDAO.PBSDAO.DeletePBSPicGroup(DAL.EntityDAO.PBSDAO.GetPBSPicGroupByCode(this.HidePBSPicGroupCode.Value.Trim()));
Response.Write(JavaScript.ScriptStart);
Response.Write(JavaScript.OpenerReload(false));
Response.Write(JavaScript.WinClose(false));
Response.Write(JavaScript.ScriptEnd);
return;
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
}
}
public static object GetConstructProgressStepFirstKg(string PBSUnitCode)
{
object obj3;
try
{
object obj2 = DBNull.Value;
string visualProgressNotStartInStr = PBSRule.GetVisualProgressNotStartInStr();
ConstructProgressStepStrategyBuilder builder = new ConstructProgressStepStrategyBuilder();
builder.AddStrategy(new Strategy(ConstructProgressStepStrategyName.PBSUnitCode, PBSUnitCode));
builder.AddStrategy(new Strategy(ConstructProgressStepStrategyName.VisualProgressNotIn, visualProgressNotStartInStr));
builder.AddStrategy(new Strategy(ConstructProgressStepStrategyName.StartDateNotNull));
builder.AddOrder("StartDate", true);
string queryString = builder.BuildMainQueryString();
QueryAgent agent = new QueryAgent();
agent.SetTopNumber(1);
EntityData data = agent.FillEntityData("ConstructProgressStep", queryString);
agent.Dispose();
if (data.HasRecord())
{
obj2 = data.CurrentRow["StartDate"];
}
obj3 = obj2;
}
catch (Exception exception)
{
throw exception;
}
return(obj3);
}
private void LoadDataGrid()
{
try
{
UFProjectStrategyBuilder sb = new UFProjectStrategyBuilder();
string UFProjectName = this.txtSearchUFProjectName.Value.Trim();
if (UFProjectName != "")
{
sb.AddStrategy(new Strategy(UFProjectStrategyName.UFProjectName, UFProjectName));
}
sb.AddOrder("UFProjectName", true);
string sql = sb.BuildMainQueryString();
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("UFProject", sql);
qa.Dispose();
dgList.DataSource = entity;
dgList.DataBind();
entity.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(Rms.Web.JavaScript.Alert(true, "显示列表出错：" + ex.Message));
}
}
private void LoadData()
{
try
{
//temp,天阳要求时间较紧 update by kenny 20070209
string company = System.Configuration.ConfigurationManager.AppSettings["PMName"].ToLower();
switch (company)
{
case "tianyangoa":
this.dgList.Columns[7].Visible = true;
break;
default:
this.dgList.Columns[7].Visible = false;
break;
}
string sql = (string)this.ViewState["SqlString"];
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("WorkFlowAct", sql);
qa.Dispose();
this.dgList.DataSource = entity.CurrentTable;
this.dgList.DataBind();
this.gpControl.RowsCount = entity.CurrentTable.Rows.Count.ToString();
entity.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
}
}
public static string GetSystemGroupSortIDByGroupNameAndClassCode(string pm_sGroupName, string pm_sClassCode)
{
string text3;
try
{
string text = "";
SystemGroupStrategyBuilder builder = new SystemGroupStrategyBuilder();
builder.AddStrategy(new Strategy(SystemGroupStrategyName.GroupName, pm_sGroupName));
builder.AddStrategy(new Strategy(SystemGroupStrategyName.ClassCode, pm_sClassCode));
string queryString = builder.BuildMainQueryString();
QueryAgent agent = new QueryAgent();
EntityData data = agent.FillEntityData("SystemGroup", queryString);
agent.Dispose();
if (data.HasRecord())
{
text = data.GetString("SortID");
}
data.Dispose();
text3 = text;
}
catch (Exception exception)
{
throw exception;
}
return(text3);
}
private void initDDLWorkFlowCommonByRight(DropDownList pm_ddlWorkFlowCommon)
{
RmsPM.DAL.QueryStrategy.WorkFlowProcedureStrategyBuilder WFPSB = new RmsPM.DAL.QueryStrategy.WorkFlowProcedureStrategyBuilder();
ArrayList arA = new ArrayList();
arA.Add("090202");
arA.Add(user.UserCode);
arA.Add(user.BuildStationCodes());
WFPSB.AddStrategy(new Strategy(WorkFlowProcedureStrategyName.AccessRange, arA));
WFPSB.AddStrategy(new Strategy(WorkFlowProcedureStrategyName.Activity, "1"));
WFPSB.IsNeedWhere = false;
string sql = WFPSB.BuildQueryViewString();
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("WorkFlowProcedure", sql);
qa.Dispose();
pm_ddlWorkFlowCommon.DataSource = entity.CurrentTable;
pm_ddlWorkFlowCommon.DataTextField = "ProcedureName";
pm_ddlWorkFlowCommon.DataValueField = "ProcedureCode";
pm_ddlWorkFlowCommon.DataBind();
}
/// ****************************************************************************
/// <summary>
/// 数据加载
/// </summary>
/// ****************************************************************************
private void LoadData()
{
try
{
WorkFlowActStrategyBuilder sb = new WorkFlowActStrategyBuilder();
sb.AddStrategy(new Strategy(DAL.QueryStrategy.WorkFlowActStrategyName.ActCode, this.ActCode));
string sql = sb.BuildMainQueryString();
QueryAgent QA = new QueryAgent();
EntityData entity = QA.FillEntityData("WorkFlowAct", sql);
this.ViewState["_CaseCode"] = entity.CurrentRow["CaseCode"].ToString();
QA.Dispose();
entity.Dispose();
WorkCase workCase = Rms.WorkFlow.WorkCaseManager.GetWorkCase(this.ViewState["_CaseCode"].ToString());
this.ViewState["_ApplicationCode"] = workCase.ApplicationCode;
Act currentAct = workCase.GetAct(this.ActCode);
Procedure procedure = DefinitionManager.GetProcedureDifinition(workCase.ProcedureCode, true);
this.ViewState["_ProcedureCode"] = procedure.ProcedureCode;
Task currentTask = procedure.GetTask(currentAct.ToTaskCode);
this.contentspan.InnerHtml = WriteOpinion(workCase, currentTask, currentAct);
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
}
}
public string GetOperationType()
{
string temp = "";
/*if(HasOperationRight("200101"))
* temp += "Y1";
* if(HasOperationRight("200102"))
* temp += "Y2";
* if(HasOperationRight("200103"))
* temp += "Y3";
* if(HasOperationRight("200201"))
* temp += "N1";
* if(HasOperationRight("200202"))
* temp += "N2";*/
AccessRangeStrategyBuilder sb = new AccessRangeStrategyBuilder();
ArrayList ar = new ArrayList();
ar.Add(this.m_UserCode);
ar.Add(BuildStationCodes());
sb.AddStrategy(new Strategy(AccessRangeStrategyName.AccessRelation1, ar));
sb.AddStrategy(new Strategy(AccessRangeStrategyName.OperationCodeIn, "'Y1','Y2','Y3','N1','N2'"));
QueryAgent qa = new QueryAgent();
string sql = sb.BuildMainQueryString();
EntityData entity = qa.FillEntityData("AccessRange", sql);
qa.Dispose();
for (int i = 0; i < entity.CurrentTable.Rows.Count; i++)
{
temp += "," + entity.CurrentTable.Rows[i]["OperationCode"].ToString();
}
return(temp);
}
/// <summary>
/// 显示付款单明细
/// </summary>
private void BindPayoutDataGrid()
{
try
{
string PaymentCode = this.txtPaymentCode.Value;
PayoutItemStrategyBuilder sb = new PayoutItemStrategyBuilder("V_PayoutItem");
sb.AddStrategy(new Strategy(PayoutItemStrategyName.PaymentCode, PaymentCode));
// sb.AddStrategy( new Strategy( PayoutItemStrategyName.Status,"1"));
sb.AddOrder("PayoutDate", true);
sb.AddOrder("PayoutItemCode", true);
string sql = sb.BuildMainQueryString();
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("V_PayoutItem", sql);
qa.Dispose();
DataTable tb = entity.CurrentTable;
BLL.PaymentRule.VoucherDetailAddColumnSubjectName(tb, this.txtSubjectSetCode.Value);
this.dgPayoutItem.Columns[4].FooterText = BLL.MathRule.SumColumn(tb, "PayoutCash").ToString("N");
this.dgPayoutItem.DataSource = tb;
this.dgPayoutItem.DataBind();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(Rms.Web.JavaScript.Alert(true, "显示列表出错：" + ex.Message));
}
}
/// <summary>
/// 取有权限的操作列表（仅资源权限）
/// </summary>
/// <param name="code"></param>
/// <param name="className"></param>
/// <returns></returns>
public EntityData GetOperationEntityDataOfResource(string code, string className)
{
try
{
string stationCodes = BuildStationCodeString(this.BuildStationCodes());
object[] ooo = new object[] { code
, SystemClassDescription.GetItemClassCode(className)
, this.UserCode
, stationCodes
, SystemClassDescription.GetItemTableName(className)
, SystemClassDescription.GetItemKeyColumnName(className)
, SystemClassDescription.GetItemTypeColumnName(className)
, SystemClassDescription.GetItemCreateUserColumnName(className) };
string selfAccessString = String.Format(" ( AccessRange.ResourceCode = ( Select ResourceCode from Resource where RelationCode='{0}' and ClassCode='{1}' ) and ( ( AccessRange.AccessRangeType=0 and AccessRange.relationCode = '{2}' ) or ( AccessRange.AccessRangeType=1 and AccessRange.relationCode in ( {3} ) and ( RoleLevel <> 1 or RoleLevel is null ) ) or ( AccessRange.AccessRangeType=1 and AccessRange.relationCode in ( {3} ) and RoleLevel = 1 and {4}.{7}='{2}' ) ) ) "
, ooo);
string sss = String.Format("select accessrange.* from accessrange , {4} where substring (AccessRange.operationCode,1,4 )='{1}' and {4}.{5} = '{0}' and ( " + selfAccessString + " )"
, ooo);
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("AccessRange", sss);
qa.Dispose();
return(entity);
}
catch (Exception ex)
{ throw ex; }
}
private void LoadData()
{
try
{
ModelStrategyBuilder sb = new ModelStrategyBuilder();
sb.AddStrategy(new Strategy(ModelStrategyName.ProjectCode, txtProjectCode.Value));
sb.AddOrder("ModelName", true);
string sql = sb.BuildQueryDoorNumString();
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("Model", sql);
qa.Dispose();
this.dgList.DataSource = entity.CurrentTable;
this.dgList.DataBind();
entity.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
Response.Write(Rms.Web.JavaScript.Alert(true, "初始化页面出错：" + ex.Message));
}
}
private EntityData _GetOACachets()
{
EntityData entitydata = new EntityData("OACachet");
OACachetStrategyBuilder builder = new OACachetStrategyBuilder();
if (this._OACachetCode != null)
{
builder.AddStrategy(new Strategy(OACachetStrategyName.OACachetCode, this._OACachetCode));
}
if (this._Unit != null)
{
builder.AddStrategy(new Strategy(OACachetStrategyName.Unit, this._Unit));
}
if (this._ApplyDate != null)
{
builder.AddStrategy(new Strategy(OACachetStrategyName.ApplyDate, this._ApplyDate));
}
if (this._Reason != null)
{
builder.AddStrategy(new Strategy(OACachetStrategyName.Reason, this._Reason));
}
if (this._ApplyUser != null)
{
builder.AddStrategy(new Strategy(OACachetStrategyName.ApplyUser, this._ApplyUser));
}
string queryString = builder.BuildMainQueryString() + " order by OACachetCode";
if (this._dao == null)
{
QueryAgent agent = new QueryAgent();
return(agent.FillEntityData("OACachet", queryString));
}
this.dao.FillEntity(queryString, entitydata);
return(entitydata);
}
private void LoadData()
{
//初始化符合条件的数据列表
string Name = this.txtUserName.Text.Trim();
try
{
RmsPM.DAL.QueryStrategy.UserStrategyBuilder USB = new RmsPM.DAL.QueryStrategy.UserStrategyBuilder();
if (Name.Length > 0)
{
USB.AddStrategy(new Strategy(RmsPM.DAL.QueryStrategy.UserStrategyName.UserName, "%" + Name + "%"));
}
string Sql = USB.BuildMainQueryString();
QueryAgent QA = new QueryAgent();
EntityData ds = QA.FillEntityData("SystemUser", Sql);
QA.Dispose();
this.dgPersonList.DataSource = new DataView(ds.CurrentTable);
this.dgPersonList.DataBind();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "加载人员列表失败");
}
}
public static EntityData GetLastVisualProgress(string ProgressType)
{
EntityData data2;
try
{
VisualProgressStrategyBuilder builder = new VisualProgressStrategyBuilder();
if (ProgressType != "")
{
builder.AddStrategy(new Strategy(VisualProgressStrategyName.ProgressType, ProgressType.ToString()));
}
builder.AddOrder("SortID", false);
string queryString = builder.BuildMainQueryString();
QueryAgent agent = new QueryAgent();
agent.SetTopNumber(1);
EntityData data = agent.FillEntityData("VisualProgress", queryString);
agent.Dispose();
data2 = data;
}
catch (Exception exception)
{
throw exception;
}
return(data2);
}
private EntityData GetEntityData()
{
SupplierSubjectSetStrategyBuilder sb = new SupplierSubjectSetStrategyBuilder();
sb.AddStrategy(new Strategy(SupplierSubjectSetStrategyName.SupplierCode, txtSupplierCode.Value));
if (this.txtIsGroup.Value == "1")
{
sb.AddStrategy(new Strategy(SupplierSubjectSetStrategyName.ProjectCode, ""));
}
else
{
if (this.txtProjectCode.Value != "")
{
sb.AddStrategy(new Strategy(SupplierSubjectSetStrategyName.ProjectCode, this.txtProjectCode.Value));
}
}
if (this.txtSubjectSetCode.Value != "")
{
sb.AddStrategy(new Strategy(SupplierSubjectSetStrategyName.SubjectSetCode, this.txtSubjectSetCode.Value));
}
string sql = sb.BuildMainQueryString();
QueryAgent qa = new QueryAgent();
EntityData entity = qa.FillEntityData("SupplierSubjectSet", sql);
qa.Dispose();
return(entity);
}
