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