private EntityData GetGradeMainDefineByCode(string code) { EntityData data2; try { EntityData data; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("GradeMainDefine")) { data = ydao.SelectbyPrimaryKey(code); } } else { this.dao.EntityName = "GradeMainDefine"; data = this.dao.SelectbyPrimaryKey(code); } data2 = data; } catch (Exception exception) { throw exception; } return(data2); }
public void SubmitAllPurchaseFlowSelSupplyHistory(EntityData entity) { Exception exception; try { using (SingleEntityDAO ydao = new SingleEntityDAO("PurchaseFlowSelSupplyHistory")) { ydao.BeginTrans(); try { ydao.SubmitEntity(entity); ydao.CommitTrans(); } catch (Exception exception1) { exception = exception1; ydao.RollBackTrans(); throw exception; } } } catch (Exception exception2) { exception = exception2; throw exception; } }
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); }
private EntityData GetAllGradeMainDefine() { EntityData data2; try { EntityData data; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("GradeMainDefine")) { data = ydao.SelectAll(); } } else { this.dao.EntityName = "GradeMainDefine"; data = this.dao.SelectAll(); } data2 = data; } catch (Exception exception) { throw exception; } return(data2); }
public static void SubmitAllBiddingDtlPlan(EntityData entity) { Exception exception; try { using (SingleEntityDAO ydao = new SingleEntityDAO("BiddingDtlPlan")) { ydao.BeginTrans(); try { ydao.SubmitEntity(entity); ydao.CommitTrans(); } catch (Exception exception1) { exception = exception1; ydao.RollBackTrans(); throw exception; } } } catch (Exception exception2) { exception = exception2; throw exception; } }
private void SubmitAllOAContact(EntityData entity) { Exception exception; try { using (SingleEntityDAO ydao = new SingleEntityDAO("OAContact")) { ydao.BeginTrans(); try { ydao.SubmitEntity(entity); ydao.CommitTrans(); } catch (Exception exception1) { exception = exception1; ydao.RollBackTrans(); throw exception; } } } catch (Exception exception2) { exception = exception2; throw exception; } }
public static void Delete(EntityData entity) { using (SingleEntityDAO ydao = new SingleEntityDAO("StampDuty")) { ydao.DeleteAllRow(entity); ydao.DeleteEntity(entity); } }
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); }
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); }
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 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); }
public static EntityData GetList() { EntityData data; using (SingleEntityDAO ydao = new SingleEntityDAO("StampDuty")) { data = ydao.SelectAll(); ydao.Dispose(); } return(data); }
public static string GetSupplierNameByCode(string supplierCode) { using (SingleEntityDAO ydao = new SingleEntityDAO("Supplier")) { EntityData data = ydao.SelectbyPrimaryKey(supplierCode); if (data.HasRecord()) { return(data.GetString("SupplierName")); } return(""); } }
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 _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); }
public static string GetSystemGroupNameByCode(string groupCode) { using (SingleEntityDAO ydao = new SingleEntityDAO("SystemGroup")) { EntityData data = ydao.SelectbyPrimaryKey(groupCode); if (data.HasRecord()) { return(data.GetString("GroupName")); } return(""); } }
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); }
public static void UpdateGroundWork(EntityData entity) { try { using (SingleEntityDAO ydao = new SingleEntityDAO("GroundWork")) { ydao.UpdateEntity(entity); } } catch (Exception exception) { throw exception; } }
public static void UpdateConstructProgressStep(EntityData entity) { try { using (SingleEntityDAO ydao = new SingleEntityDAO("ConstructProgressStep")) { ydao.UpdateEntity(entity); } } catch (Exception exception) { throw exception; } }
public static void UpdateConstructAnnualPlan(EntityData entity) { try { using (SingleEntityDAO ydao = new SingleEntityDAO("ConstructAnnualPlan")) { ydao.UpdateEntity(entity); } } catch (Exception exception) { throw exception; } }
public static void InsertRiskIndex(EntityData entity) { try { using (SingleEntityDAO ydao = new SingleEntityDAO("RiskIndex")) { ydao.InsertEntity(entity); } } catch (Exception exception) { throw exception; } }
public static void InsertConstructProgressRisk(EntityData entity) { try { using (SingleEntityDAO ydao = new SingleEntityDAO("ConstructProgressRisk")) { ydao.InsertEntity(entity); } } catch (Exception exception) { throw exception; } }
public static void UpdateSubjectSet(EntityData entity) { try { using (SingleEntityDAO ydao = new SingleEntityDAO("SubjectSet")) { ydao.UpdateEntity(entity); } } catch (Exception exception) { throw exception; } }
public static void InsertSubject(EntityData entity) { try { using (SingleEntityDAO ydao = new SingleEntityDAO("Subject")) { ydao.InsertEntity(entity); } } catch (Exception exception) { throw exception; } }
public static void UpdateRiskType(EntityData entity) { try { using (SingleEntityDAO ydao = new SingleEntityDAO("RiskType")) { ydao.UpdateEntity(entity); } } catch (Exception exception) { throw exception; } }
public static void UpdateVisualProgress(EntityData entity) { try { using (SingleEntityDAO ydao = new SingleEntityDAO("VisualProgress")) { ydao.UpdateEntity(entity); } } catch (Exception exception) { throw exception; } }
private void UpdateOACachet(EntityData entity) { try { using (SingleEntityDAO ydao = new SingleEntityDAO("OACachet")) { ydao.UpdateEntity(entity); } } catch (Exception exception) { throw exception; } }