private EntityData _GetLocalConsiderDepartments() { EntityData data2; try { EntityData entitydata = new EntityData("GradeConsiderDepartment"); string sqlString = "select * from GradeConsiderDepartment"; sqlString = sqlString + " where GradeConsiderDepartment.ConsiderDiathesisCode in (select GradeConsiderDiathesis.ConsiderDiathesisCode from GradeConsiderDiathesis where ParentCode='') " + " order by GradeConsiderDepartmentCode desc"; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("GradeConsiderDepartment")) { ydao.FillEntity(sqlString, entitydata); } } else { this.dao.EntityName = "GradeConsiderDepartment"; this.dao.FillEntity(sqlString, entitydata); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
private EntityData _GetGradeMainDefines() { EntityData entitydata = new EntityData("GradeMainDefine"); GradeMainDefineStrategyBuilder builder = new GradeMainDefineStrategyBuilder(); if (this._MainDefineCode != null) { builder.AddStrategy(new Strategy(GradeMainDefineStrategyName.MainDefineCode, this._MainDefineCode)); } if (this._Name != null) { builder.AddStrategy(new Strategy(GradeMainDefineStrategyName.Name, this._Name)); } if (this._state != null) { builder.AddStrategy(new Strategy(GradeMainDefineStrategyName.state, this._state)); } string sqlString = builder.BuildMainQueryString() + " order by MainDefineCode"; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("GradeMainDefine")) { ydao.FillEntity(sqlString, entitydata); } return(entitydata); } this.dao.EntityName = "GradeMainDefine"; this.dao.FillEntity(sqlString, entitydata); return(entitydata); }
public static int GetPBSTypeMaxSortID(string projectCode, string parentCode) { int num2; try { int @int; EntityData entitydata = new EntityData("PBSType"); using (SingleEntityDAO ydao = new SingleEntityDAO("PBSType")) { string[] Params = new string[] { "@ProjectCode", "@ParentCode" }; object[] values = new object[] { projectCode, parentCode }; ydao.FillEntity(SqlManager.GetSqlStruct("PBSType", "SelectMaxSortID").SqlString, Params, values, entitydata, "PBSType"); } if (entitydata.Tables[0].Rows.Count > 0) { @int = entitydata.GetInt("SortID"); } else { @int = 0; } entitydata.Dispose(); num2 = @int; } catch (Exception exception) { throw exception; } return(num2); }
private EntityData _GetBiddingGradeConsiderDiathesiss() { EntityData data2; try { EntityData entitydata = new EntityData("BiddingGradeConsiderDiathesis"); BiddingGradeConsiderDiathesisStrategyBuilder builder = new BiddingGradeConsiderDiathesisStrategyBuilder(); if (this._BiddingConsiderDiathesisCode != null) { builder.AddStrategy(new Strategy(BiddingGradeConsiderDiathesisStrategyName.BiddingConsiderDiathesisCode, this._BiddingConsiderDiathesisCode)); } if (this._BiddingMainDefineCode != null) { builder.AddStrategy(new Strategy(BiddingGradeConsiderDiathesisStrategyName.BiddingMainDefineCode, this._BiddingMainDefineCode)); } if (this._ParentCode != null) { builder.AddStrategy(new Strategy(BiddingGradeConsiderDiathesisStrategyName.ParentCode, this._ParentCode)); } if (this._BiddingConsiderDiathesis != null) { builder.AddStrategy(new Strategy(BiddingGradeConsiderDiathesisStrategyName.BiddingConsiderDiathesis, this._BiddingConsiderDiathesis)); } if (this._GradeGuideline != null) { builder.AddStrategy(new Strategy(BiddingGradeConsiderDiathesisStrategyName.GradeGuideline, this._GradeGuideline)); } builder.AddStrategy(new Strategy(BiddingGradeConsiderDiathesisStrategyName.Percentage, this._Percentage.ToString())); if (this._State != null) { builder.AddStrategy(new Strategy(BiddingGradeConsiderDiathesisStrategyName.state, this._State)); } if (this._BiddingGradeTypeCode != null) { builder.AddStrategy(new Strategy(BiddingGradeConsiderDiathesisStrategyName.BiddingGradeTypeCode, this._BiddingGradeTypeCode)); } string sqlString = builder.BuildMainQueryString() + " order by BiddingConsiderDiathesisCode desc"; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("BiddingGradeConsiderDiathesis")) { ydao.FillEntity(sqlString, entitydata); } } else { this.dao.EntityName = "BiddingGradeConsiderDiathesis"; this.dao.FillEntity(sqlString, entitydata); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
private EntityData _GetBiddingLogs() { EntityData data2; try { EntityData entitydata = new EntityData("BiddingLog"); BiddingLogStrategyBuilder builder = new BiddingLogStrategyBuilder(); if (this._BiddingLogCode != null) { builder.AddStrategy(new Strategy(BiddingLogStrategyName.BiddingLogCode, this._BiddingLogCode)); } if (this._BiddingCode != null) { builder.AddStrategy(new Strategy(BiddingLogStrategyName.BiddingCode, this._BiddingCode)); } if (this._Type != null) { builder.AddStrategy(new Strategy(BiddingLogStrategyName.Type, this._Type)); } if (this._UserCode != null) { builder.AddStrategy(new Strategy(BiddingLogStrategyName.UserCode, this._UserCode)); } if (this._UpdateTime != null) { builder.AddStrategy(new Strategy(BiddingLogStrategyName.UpdateTime, this._UpdateTime)); } if (this._State != null) { builder.AddStrategy(new Strategy(BiddingLogStrategyName.State, this._State)); } if (this._Flag != null) { builder.AddStrategy(new Strategy(BiddingLogStrategyName.Flag, this._Flag)); } string sqlString = builder.BuildMainQueryString() + " order by BiddingLogCode desc"; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("BiddingLog")) { ydao.FillEntity(sqlString, entitydata); } } else { this.dao.EntityName = "BiddingLog"; this.dao.FillEntity(sqlString, entitydata); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
public EntityData _GetBiddingSuppliersOrderbyPy() { EntityData entitydata = new EntityData("BiddingSupplier"); BiddingSupplierStrategyBuilder builder = new BiddingSupplierStrategyBuilder(); if (this._BiddingSupplierCode != null) { builder.AddStrategy(new Strategy(BiddingSupplierStrategyName.BiddingSupplierCode, this._BiddingSupplierCode)); } if (this._BiddingPrejudicationCode != null) { builder.AddStrategy(new Strategy(BiddingSupplierStrategyName.BiddingPrejudicationCode, this._BiddingPrejudicationCode)); } if (this._SupplierCode != null) { builder.AddStrategy(new Strategy(BiddingSupplierStrategyName.SupplierCode, this._SupplierCode)); } if (this._NominateUser != null) { builder.AddStrategy(new Strategy(BiddingSupplierStrategyName.NominateUser, this._NominateUser)); } if (this._NominateDate != null) { builder.AddStrategy(new Strategy(BiddingSupplierStrategyName.NominateDate, this._NominateDate)); } if (this._UserCode != null) { builder.AddStrategy(new Strategy(BiddingSupplierStrategyName.UserCode, this._UserCode)); } if (this._OrderCode != null) { builder.AddStrategy(new Strategy(BiddingSupplierStrategyName.OrderCode, this._OrderCode)); } if (this._State != null) { builder.AddStrategy(new Strategy(BiddingSupplierStrategyName.State, this._State)); } if (this._Flag != null) { builder.AddStrategy(new Strategy(BiddingSupplierStrategyName.Flag, this._Flag)); } string sqlString = builder.BuildMainQueryString() + " order by BiddingSupplierCode"; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("BiddingSupplier")) { ydao.FillEntity(sqlString, entitydata); } return(entitydata); } this.dao.EntityName = "BiddingSupplier"; this.dao.FillEntity(sqlString, entitydata); return(entitydata); }
private EntityData _GetSendMsgs() { EntityData entitydata = new EntityData("SendMsg"); SendMsgStrategyBuilder builder = new SendMsgStrategyBuilder(); if (this._SendMsgCode != null) { builder.AddStrategy(new Strategy(SendMsgStrategyName.SendMsgCode, this._SendMsgCode)); } if (this._SendUsercode != null) { builder.AddStrategy(new Strategy(SendMsgStrategyName.SendUsercode, this._SendUsercode)); } if (this._ToUsercode != null) { builder.AddStrategy(new Strategy(SendMsgStrategyName.ToUsercode, this._ToUsercode)); } if (this._Msg != null) { builder.AddStrategy(new Strategy(SendMsgStrategyName.Msg, this._Msg)); } if (this._Sendtime != null) { builder.AddStrategy(new Strategy(SendMsgStrategyName.Sendtime, this._Sendtime)); } if (this._State != null) { builder.AddStrategy(new Strategy(SendMsgStrategyName.State, this._State)); } if (this._senddel != null) { builder.AddStrategy(new Strategy(SendMsgStrategyName.senddel, this._senddel)); } if (this._todel != null) { builder.AddStrategy(new Strategy(SendMsgStrategyName.todel, this._todel)); } if (this._Flag != null) { builder.AddStrategy(new Strategy(SendMsgStrategyName.Flag, this._Flag)); } string sqlString = builder.BuildMainQueryString() + " order by SendMsgCode desc"; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("SendMsg")) { ydao.FillEntity(sqlString, entitydata); } return(entitydata); } this.dao.EntityName = "SendMsg"; this.dao.FillEntity(sqlString, entitydata); return(entitydata); }
private EntityData _GetSupplierSurveyOpinions() { EntityData entitydata = new EntityData("SupplierSurveyOpinion"); SupplierSurveyOpinionStrategyBuilder builder = new SupplierSurveyOpinionStrategyBuilder(); if (this._SupplierSurveyOpinionCode != null) { builder.AddStrategy(new Strategy(SupplierSurveyOpinionStrategyName.SupplierSurveyOpinionCode, this._SupplierSurveyOpinionCode)); } if (this._WorkName != null) { builder.AddStrategy(new Strategy(SupplierSurveyOpinionStrategyName.WorkName, this._WorkName)); } if (this._SupplierCode != null) { builder.AddStrategy(new Strategy(SupplierSurveyOpinionStrategyName.SupplierCode, this._SupplierCode)); } if (this._ZYName != null) { builder.AddStrategy(new Strategy(SupplierSurveyOpinionStrategyName.ZYName, this._ZYName)); } if (this._SurveyDate != null) { builder.AddStrategy(new Strategy(SupplierSurveyOpinionStrategyName.SurveyDate, this._SurveyDate)); } if (this._Grade != null) { builder.AddStrategy(new Strategy(SupplierSurveyOpinionStrategyName.Grade, this._Grade)); } if (this._AdviceGrade != null) { builder.AddStrategy(new Strategy(SupplierSurveyOpinionStrategyName.AdviceGrade, this._AdviceGrade)); } if (this._Flag != null) { builder.AddStrategy(new Strategy(SupplierSurveyOpinionStrategyName.Flag, this._Flag)); } if (this._State != null) { builder.AddStrategy(new Strategy(SupplierSurveyOpinionStrategyName.State, this._State)); } string sqlString = builder.BuildMainQueryString() + " order by SupplierSurveyOpinionCode Desc"; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("SupplierSurveyOpinion")) { ydao.FillEntity(sqlString, entitydata); } return(entitydata); } this.dao.EntityName = "SupplierSurveyOpinion"; this.dao.FillEntity(sqlString, entitydata); return(entitydata); }
public EntityData _GetBiddingPrejudications() { EntityData entitydata = new EntityData("BiddingPrejudication"); BiddingPrejudicationStrategyBuilder builder = new BiddingPrejudicationStrategyBuilder(); if (this._BiddingPrejudicationCode != null) { builder.AddStrategy(new Strategy(BiddingPrejudicationStrategyName.BiddingPrejudicationCode, this._BiddingPrejudicationCode)); } if (this._BiddingCode != null) { builder.AddStrategy(new Strategy(BiddingPrejudicationStrategyName.BiddingCode, this._BiddingCode)); } if (this._WorkConfine != null) { builder.AddStrategy(new Strategy(BiddingPrejudicationStrategyName.WorkConfine, this._WorkConfine)); } if (this._Number != null) { builder.AddStrategy(new Strategy(BiddingPrejudicationStrategyName.Number, this._Number)); } if (this._Remark != null) { builder.AddStrategy(new Strategy(BiddingPrejudicationStrategyName.Remark, this._Remark)); } if (this._UserCode != null) { builder.AddStrategy(new Strategy(BiddingPrejudicationStrategyName.UserCode, this._UserCode)); } if (this._CreateDate != null) { builder.AddStrategy(new Strategy(BiddingPrejudicationStrategyName.CreateDate, this._CreateDate)); } if (this._State != null) { builder.AddStrategy(new Strategy(BiddingPrejudicationStrategyName.State, this._State)); } if (this._Flag != null) { builder.AddStrategy(new Strategy(BiddingPrejudicationStrategyName.Flag, this._Flag)); } string sqlString = builder.BuildMainQueryString() + " order by BiddingPrejudicationCode"; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("BiddingPrejudication")) { ydao.FillEntity(sqlString, entitydata); } return(entitydata); } this.dao.EntityName = "BiddingPrejudication"; this.dao.FillEntity(sqlString, entitydata); return(entitydata); }
public int ConvertFileToAttachment(int i, ref int beginCode) { EntityData entitydata = new EntityData(); using (SingleEntityDAO ydao = new SingleEntityDAO("AttachMent")) { ydao.FillEntity("select top " + i.ToString() + " * from attachment where content is null and attachmentcode>" + ((int)beginCode).ToString() + " order by attachmentcode", "", "", entitydata, "AttachMent"); } DataTable currentTable = entitydata.CurrentTable; int num = 0; Rms.LogHelper.LogHelper.Warn("附件转换 子阶段开始 code>" + ((int)beginCode).ToString()); try { if (currentTable.Rows.Count == 0) { return(0); } foreach (DataRow row in currentTable.Rows) { if (beginCode < int.Parse(row["attachmentcode"].ToString())) { beginCode = int.Parse(row["attachmentcode"].ToString()); } if (row["content"] == DBNull.Value) { string fileName = GetFileName(row["guidname"].ToString(), row["CreateDate"].ToString()); FileInfo info = new FileInfo(fileName); if (info.Exists) { byte[] buffer = new byte[info.Length]; info.OpenRead().Read(buffer, 0, (int)info.Length); row["content"] = buffer; row["guidname"] = DBNull.Value; } else { Rms.LogHelper.LogHelper.Warn("附件转换 文件没找到:" + fileName); } num++; } } DAOFactory.GetAttachmentDAO().SubmitAllAttachMent(entitydata); } catch (Exception exception) { Log.WriteLog("DocumentRule", exception.ToString()); entitydata.Dispose(); throw exception; } Rms.LogHelper.LogHelper.Warn("附件转换 子阶段结束 code>" + ((int)beginCode).ToString()); entitydata.Dispose(); return(num); }
private EntityData _GetBiddings() { EntityData data2; try { EntityData entitydata = new EntityData("BiddingGradeMessage"); BiddingGradeMessageStrategyBuilder builder = new BiddingGradeMessageStrategyBuilder(); if (this._BiddingGradeMessageCode != null) { builder.AddStrategy(new Strategy(BiddingGradeMessageStrategyName.BiddingGradeMessageCode, this._BiddingGradeMessageCode)); } if (this._ApplicationCode != null) { builder.AddStrategy(new Strategy(BiddingGradeMessageStrategyName.ApplicationCode, this._ApplicationCode)); } if (this._BiddingGradeTypeCode != null) { builder.AddStrategy(new Strategy(BiddingGradeMessageStrategyName.BiddingGradeTypeCode, this._BiddingGradeTypeCode)); } if (this._MainDefineCode != null) { builder.AddStrategy(new Strategy(BiddingGradeMessageStrategyName.MainDefineCode, this._MainDefineCode)); } if (this._ProjectManage != null) { builder.AddStrategy(new Strategy(BiddingGradeMessageStrategyName.ProjectManage, this._ProjectManage)); } if (this._State != null) { builder.AddStrategy(new Strategy(BiddingGradeMessageStrategyName.State, this._State)); } string sqlString = builder.BuildMainQueryString() + " order by BiddingGradeMessageCode desc"; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("BiddingGradeMessage")) { ydao.FillEntity(sqlString, entitydata); } } else { this.dao.EntityName = "BiddingGradeMessage"; this.dao.FillEntity(sqlString, entitydata); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
private EntityData _GetLinkManages() { EntityData data2; try { EntityData entitydata = new EntityData("LinkManage"); LinkManageStrategyBuilder builder = new LinkManageStrategyBuilder(); if (this._LinkManageCode != null) { builder.AddStrategy(new Strategy(LinkManageStrategyName.LinkManageCode, this._LinkManageCode)); } if (this._Linkname != null) { builder.AddStrategy(new Strategy(LinkManageStrategyName.Linkname, this._Linkname)); } if (this._LinkUrl != null) { builder.AddStrategy(new Strategy(LinkManageStrategyName.LinkUrl, this._LinkUrl)); } if (this._CreateDate != null) { builder.AddStrategy(new Strategy(LinkManageStrategyName.CreateDate, this._CreateDate)); } if (this._State != null) { builder.AddStrategy(new Strategy(LinkManageStrategyName.state, this._State)); } if (this._Flag != null) { builder.AddStrategy(new Strategy(LinkManageStrategyName.flag, this._Flag)); } string sqlString = builder.BuildMainQueryString() + " order by LinkManageCode desc"; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("LinkManage")) { ydao.FillEntity(sqlString, entitydata); } } else { this.dao.EntityName = "LinkManage"; this.dao.FillEntity(sqlString, entitydata); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
private EntityData _GetEmailHistorys() { EntityData entitydata = new EntityData("EmailHistory"); EmailHistoryStrategyBuilder builder = new EmailHistoryStrategyBuilder(); if (this._EmailHistoryCode != null) { builder.AddStrategy(new Strategy(EmailHistoryStrategyName.EmailHistoryCode, this._EmailHistoryCode)); } if (this._EmailType != null) { builder.AddStrategy(new Strategy(EmailHistoryStrategyName.EmailType, this._EmailType)); } if (this._MasterCode != null) { builder.AddStrategy(new Strategy(EmailHistoryStrategyName.MasterCode, this._MasterCode)); } if (this._EmailTitle != null) { builder.AddStrategy(new Strategy(EmailHistoryStrategyName.EmailTitle, this._EmailTitle)); } if (this._Receiver != null) { builder.AddStrategy(new Strategy(EmailHistoryStrategyName.Receiver, this._Receiver)); } if (this._Sender != null) { builder.AddStrategy(new Strategy(EmailHistoryStrategyName.Sender, this._Sender)); } if (this._EmailContent != null) { builder.AddStrategy(new Strategy(EmailHistoryStrategyName.EmailContent, this._EmailContent)); } if (this._SendDate != null) { builder.AddStrategy(new Strategy(EmailHistoryStrategyName.SendDate, this._SendDate)); } string sqlString = builder.BuildMainQueryString() + " order by EmailHistoryCode"; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("EmailHistory")) { ydao.FillEntity(sqlString, entitydata); } return(entitydata); } this.dao.EntityName = "EmailHistory"; this.dao.FillEntity(sqlString, entitydata); return(entitydata); }
private EntityData _GetBiddings() { EntityData data2; try { EntityData entitydata = new EntityData("BiddingFile"); BiddingFileStrategyBuider buider = new BiddingFileStrategyBuider(); if (this._BiddingFileCode != null) { buider.AddStrategy(new Strategy(BiddingFileStrategyName.BiddingFileCode, this._BiddingFileCode)); } if (this._BiddingCode != null) { buider.AddStrategy(new Strategy(BiddingFileStrategyName.BiddingCode, this._BiddingCode)); } if (this._BiddingFileNumber != null) { buider.AddStrategy(new Strategy(BiddingFileStrategyName.BiddingFileNumber, this._BiddingFileNumber)); } if (this._State != null) { buider.AddStrategy(new Strategy(BiddingFileStrategyName.State, this._State)); } if (this._Remark != null) { buider.AddStrategy(new Strategy(BiddingFileStrategyName.Remark, "%" + this._Remark + "%")); } string sqlString = buider.BuildMainQueryString() + " order by BiddingFileCode desc"; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("BiddingFile")) { ydao.FillEntity(sqlString, entitydata); } } else { this.dao.EntityName = "BiddingFile"; this.dao.FillEntity(sqlString, entitydata); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
private EntityData _GetSupplierTitles() { EntityData data2; try { EntityData entitydata = new EntityData("SupplierTitle"); SupplierTitleStrategyBuilder builder = new SupplierTitleStrategyBuilder(); if (this._SupplierTitleCode != null) { builder.AddStrategy(new Strategy(SupplierTitleStrategyName.SupplierTitleCode, this._SupplierTitleCode)); } if (this._Title != null) { builder.AddStrategy(new Strategy(SupplierTitleStrategyName.Title, this._Title)); } if (this._SupplierCode != null) { builder.AddStrategy(new Strategy(SupplierTitleStrategyName.SupplierCode, this._SupplierCode)); } if (this._BankAccount != null) { builder.AddStrategy(new Strategy(SupplierTitleStrategyName.BankAccount, this._BankAccount)); } if (this._Remark != null) { builder.AddStrategy(new Strategy(SupplierTitleStrategyName.Remark, this._Remark)); } string sqlString = builder.BuildMainQueryString() + " order by SupplierTitleCode desc"; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("SupplierTitle")) { ydao.FillEntity(sqlString, entitydata); } } else { this.dao.EntityName = "SupplierTitle"; this.dao.FillEntity(sqlString, entitydata); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
private EntityData _GetGradeDepartmentPercentages() { EntityData data2; try { EntityData entitydata = new EntityData("GradeDepartmentPercentage"); GradeDepartmentPercentageStrategyBuilder builder = new GradeDepartmentPercentageStrategyBuilder(); if (this._DepartmentPercentageCode != null) { builder.AddStrategy(new Strategy(GradeDepartmentPercentageStrategyName.DepartmentPercentageCode, this._DepartmentPercentageCode)); } if (this._MainDefineCode != null) { builder.AddStrategy(new Strategy(GradeDepartmentPercentageStrategyName.MainDefineCode, this._MainDefineCode)); } if (this._GradeMessageCode != null) { builder.AddStrategy(new Strategy(GradeDepartmentPercentageStrategyName.GradeMessageCode, this._GradeMessageCode)); } if (this._DepartmentDefineCode != null) { builder.AddStrategy(new Strategy(GradeDepartmentPercentageStrategyName.DepartmentDefineCode, this._DepartmentDefineCode)); } if (this._Percentage != 0M) { builder.AddStrategy(new Strategy(GradeDepartmentPercentageStrategyName.Percentage, this._Percentage.ToString())); } string sqlString = builder.BuildMainQueryString() + " order by DepartmentPercentageCode desc"; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("GradeDepartmentPercentage")) { ydao.FillEntity(sqlString, entitydata); } } else { this.dao.EntityName = "GradeDepartmentPercentage"; this.dao.FillEntity(sqlString, entitydata); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
private EntityData _GetBiddingReturnCosts() { EntityData entitydata = new EntityData("BiddingReturnCost"); BiddingReturnCostStrategyBuilder builder = new BiddingReturnCostStrategyBuilder(); if (this._BiddingReturnCode != null) { builder.AddStrategy(new Strategy(BiddingReturnCostStrategyName.BiddingReturnCode, this._BiddingReturnCode)); } if (this._BiddingReturnCostCode != null) { builder.AddStrategy(new Strategy(BiddingReturnCostStrategyName.BiddingReturnCostCode, this._BiddingReturnCostCode)); } if (this._BiddingReturnCostID != null) { builder.AddStrategy(new Strategy(BiddingReturnCostStrategyName.BiddingReturnCostID, this._BiddingReturnCostID)); } if (this._Cash != null) { builder.AddStrategy(new Strategy(BiddingReturnCostStrategyName.Cash, this._Cash)); } if (this._MoneyType != null) { builder.AddStrategy(new Strategy(BiddingReturnCostStrategyName.MoneyType, this._MoneyType)); } if (this._MoneyTypeID != null) { builder.AddStrategy(new Strategy(BiddingReturnCostStrategyName.MoneyTypeID, this._MoneyTypeID)); } if (this._ExchangeRate != null) { builder.AddStrategy(new Strategy(BiddingReturnCostStrategyName.ExchangeRate, this._ExchangeRate)); } string sqlString = builder.BuildMainQueryString() + " order by BiddingReturnCostCode"; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("BiddingReturnCost")) { ydao.FillEntity(sqlString, entitydata); } return(entitydata); } this.dao.EntityName = "BiddingReturnCost"; this.dao.FillEntity(sqlString, entitydata); return(entitydata); }
private EntityData _GetGradeMessages() { EntityData entitydata = new EntityData("GradeMessage"); GradeMessageStrategyBuilder builder = new GradeMessageStrategyBuilder(); if (this._GradeMessageCode != null) { builder.AddStrategy(new Strategy(GradeMessageStrategyName.GradeMessageCode, this._GradeMessageCode)); } if (this._ProjectCode != null) { builder.AddStrategy(new Strategy(GradeMessageStrategyName.ProjectCode, this._ProjectCode)); } if (this._SupplierCode != null) { builder.AddStrategy(new Strategy(GradeMessageStrategyName.SupplierCode, this._SupplierCode)); } if (this._MainDefineCode != null) { builder.AddStrategy(new Strategy(GradeMessageStrategyName.MainDefineCode, this._MainDefineCode)); } if (this._ProjectManage != null) { builder.AddStrategy(new Strategy(GradeMessageStrategyName.ProjectManage, this._ProjectManage)); } if (this._CreateDate != null) { builder.AddStrategy(new Strategy(GradeMessageStrategyName.CreateDate, this._CreateDate)); } if (this._State != null) { builder.AddStrategy(new Strategy(GradeMessageStrategyName.State, this._State)); } string sqlString = builder.BuildMainQueryString() + " order by GradeMessageCode Desc"; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("GradeMessage")) { ydao.FillEntity(sqlString, entitydata); } return(entitydata); } this.dao.EntityName = "GradeMessage"; this.dao.FillEntity(sqlString, entitydata); return(entitydata); }
private EntityData _GetGradeConsiderDiathesiss() { EntityData entitydata = new EntityData("GradeConsiderDiathesis"); GradeConsiderDiathesisStrategyBuilder builder = new GradeConsiderDiathesisStrategyBuilder(); if (this._ConsiderDiathesisCode != null) { builder.AddStrategy(new Strategy(GradeConsiderDiathesisStrategyName.ConsiderDiathesisCode, this._ConsiderDiathesisCode)); } if (this._MainDefineCode != null) { builder.AddStrategy(new Strategy(GradeConsiderDiathesisStrategyName.MainDefineCode, this._MainDefineCode)); } if (this._ParentCode != null) { builder.AddStrategy(new Strategy(GradeConsiderDiathesisStrategyName.ParentCode, this._ParentCode)); } if (this._ConsiderDiathesis != null) { builder.AddStrategy(new Strategy(GradeConsiderDiathesisStrategyName.ConsiderDiathesis, this._ConsiderDiathesis)); } if (this._GradeGuideline != null) { builder.AddStrategy(new Strategy(GradeConsiderDiathesisStrategyName.GradeGuideline, this._GradeGuideline)); } if (this._Percentage != null) { builder.AddStrategy(new Strategy(GradeConsiderDiathesisStrategyName.Percentage, this._Percentage)); } if (this._state != null) { builder.AddStrategy(new Strategy(GradeConsiderDiathesisStrategyName.state, this._state)); } string sqlString = builder.BuildMainQueryString() + " order by ConsiderDiathesisCode"; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("GradeConsiderDiathesis")) { ydao.FillEntity(sqlString, entitydata); } return(entitydata); } this.dao.EntityName = "GradeConsiderDiathesis"; this.dao.FillEntity(sqlString, entitydata); return(entitydata); }
private EntityData _GetGradeConsiderDepartments() { EntityData data2; try { EntityData entitydata = new EntityData("GradeConsiderDepartment"); GradeConsiderDepartmentStrategyBuilder builder = new GradeConsiderDepartmentStrategyBuilder(); if (this._GradeConsiderDepartmentCode != null) { builder.AddStrategy(new Strategy(GradeConsiderDepartmentStrategyName.GradeConsiderDepartmentCode, this._GradeConsiderDepartmentCode)); } if (this._DepartmentDefineCode != null) { builder.AddStrategy(new Strategy(GradeConsiderDepartmentStrategyName.DepartmentDefineCode, this._DepartmentDefineCode)); } if (this._ConsiderDiathesisCode != null) { builder.AddStrategy(new Strategy(GradeConsiderDepartmentStrategyName.ConsiderDiathesisCode, this._ConsiderDiathesisCode)); } if (this._Flag != null) { builder.AddStrategy(new Strategy(GradeConsiderDepartmentStrategyName.Flag, this._Flag)); } string sqlString = builder.BuildMainQueryString() + " order by GradeConsiderDepartmentCode desc"; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("GradeConsiderDepartment")) { ydao.FillEntity(sqlString, entitydata); } } else { this.dao.EntityName = "GradeConsiderDepartment"; this.dao.FillEntity(sqlString, entitydata); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetV_ParityByPurchaseCode(string code) { EntityData data2; try { EntityData entitydata = new EntityData("V_Parity"); using (SingleEntityDAO ydao = new SingleEntityDAO("V_Parity")) { ydao.FillEntity(SqlManager.GetSqlStruct("V_Parity", "SelectV_ParityByPurchaseCode").SqlString, "@PurchaseCode", code, entitydata, "V_Parity"); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetTakingDetailByTakingCode(string TakingCode) { EntityData data2; try { EntityData entitydata = new EntityData("TakingDetail"); using (SingleEntityDAO ydao = new SingleEntityDAO("TakingDetail")) { ydao.FillEntity(SqlManager.GetSqlStruct("TakingDetail", "SelectTakingDetailByTakingCode").SqlString, "@TakingCode", TakingCode, entitydata, "TakingDetail"); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetReceivingDetailByPurchaseDetailCode(string purchaseDetailCode) { EntityData data2; try { EntityData entitydata = new EntityData("ReceivingDetail"); using (SingleEntityDAO ydao = new SingleEntityDAO("ReceivingDetail")) { ydao.FillEntity(SqlManager.GetSqlStruct("ReceivingDetail", "SelectReceivingDetailByPurchaseDetailCode").SqlString, "@PurchaseDetailCode", purchaseDetailCode, entitydata, "ReceivingDetail"); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetAlreadyEnquiryPurchaseDetail(string code) { EntityData data2; try { EntityData entitydata = new EntityData("PurchaseDetail"); using (SingleEntityDAO ydao = new SingleEntityDAO("PurchaseDetail")) { ydao.FillEntity(SqlManager.GetSqlStruct("PurchaseDetail", "SelectAlreadyEnquiryPurchaseDetail").SqlString, "@purchasecode", code, entitydata, "PurchaseDetail"); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetPBSTypeLayoutByProject(string strProjectCode) { EntityData data2; try { EntityData entitydata = new EntityData("PBSTypeLayout"); using (SingleEntityDAO ydao = new SingleEntityDAO("PBSTypeLayout")) { ydao.FillEntity(SqlManager.GetSqlStruct("PBSTypeLayout", "SelectByProjectCode").SqlString, "@ProjectCode", strProjectCode, entitydata, "PBSTypeLayout"); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetRemindStrategyByProjectCode(string code) { EntityData data2; try { EntityData entitydata = new EntityData("RemindStrategy"); using (SingleEntityDAO ydao = new SingleEntityDAO("RemindStrategy")) { ydao.FillEntity(SqlManager.GetSqlStruct("RemindStrategy", "SelectRemindStrategyByProjectCode").SqlString, "@ProjectCode", code, entitydata, "RemindStrategy"); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetDocumentTypeChildByParentCode(string code) { EntityData data2; try { EntityData entitydata = new EntityData("DocumentType"); using (SingleEntityDAO ydao = new SingleEntityDAO("DocumentType")) { ydao.FillEntity(SqlManager.GetSqlStruct("DocumentType", "SelectChildByParentCode").SqlString, "@ParentCode", code, entitydata, "DocumentType"); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetAllSalProjectCode() { EntityData data2; try { EntityData entitydata = new EntityData("Project"); using (SingleEntityDAO ydao = new SingleEntityDAO("Project")) { ydao.FillEntity(SqlManager.GetSqlStruct("Project", "SelectAllSalProjectCode").SqlString, (string[])null, (object[])null, entitydata, "Project"); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetSubjectBySubjectSet(string subjectSetCode) { EntityData data2; try { EntityData entitydata = new EntityData("Subject"); using (SingleEntityDAO ydao = new SingleEntityDAO("Subject")) { ydao.FillEntity(SqlManager.GetSqlStruct("Subject", "SelectBySubjectSet").GetSqlStringWithOrder(), "@SubjectSetCode", subjectSetCode, entitydata, "Subject"); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetDocumentIDByGroupCode(string groupcode) { EntityData data2; try { EntityData entitydata = new EntityData("Document"); using (SingleEntityDAO ydao = new SingleEntityDAO("Document")) { ydao.FillEntity(SqlManager.GetSqlStruct("Document", "SelectByGroupCode").SqlString, "@GroupCode", groupcode, entitydata, "Document"); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }