public static string GetSupplierAbbreviation(string code) { string text2; try { string text = ""; if (code == "") { return(text); } EntityData data = new EntityData("Supplier"); using (SingleEntityDAO ydao = new SingleEntityDAO("Supplier")) { data = ydao.SelectbyPrimaryKey(code); } if (data.HasRecord()) { text = data.GetString("Abbreviation"); } data.Dispose(); text2 = text; } catch (Exception exception) { throw exception; } return(text2); }
public EntityData GetTC_OA_BiddingContractByCode(string code) { EntityData data2; try { EntityData data; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("TC_OA_BiddingContract")) { data = ydao.SelectbyPrimaryKey(code); } } else { this.dao.EntityName = "TC_OA_BiddingContract"; data = this.dao.SelectbyPrimaryKey(code); } data2 = data; } catch (Exception exception) { throw exception; } return(data2); }
public EntityData GetSupplierSurveyOpinionByCode(string code) { EntityData data2; try { EntityData data; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("SupplierSurveyOpinion")) { data = ydao.SelectbyPrimaryKey(code); } } else { this.dao.EntityName = "SupplierSurveyOpinion"; data = this.dao.SelectbyPrimaryKey(code); } data2 = data; } catch (Exception exception) { throw exception; } return(data2); }
private EntityData GetBiddingPrejudicationByCode(string code) { EntityData data2; try { EntityData data; if (this._dao != null) { this._dao.EntityName = "BiddingPrejudication"; data = this.dao.SelectbyPrimaryKey(code); } else { using (SingleEntityDAO ydao = new SingleEntityDAO("BiddingPrejudication")) { data = ydao.SelectbyPrimaryKey(code); } } data2 = data; } catch (Exception exception) { throw exception; } return(data2); }
private EntityData GetGradeByCode(string code) { EntityData data2; try { EntityData data; if (this._dao == null) { using (SingleEntityDAO ydao = new SingleEntityDAO("Grade")) { data = ydao.SelectbyPrimaryKey(code); } } else { this.dao.EntityName = "Grade"; data = this.dao.SelectbyPrimaryKey(code); } data2 = data; } catch (Exception exception) { throw exception; } return(data2); }
public static void Delete(int StampDutyID) { using (SingleEntityDAO ydao = new SingleEntityDAO("StampDuty")) { Delete(ydao.SelectbyPrimaryKey(StampDutyID)); } }
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(""); } }
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(""); } }
public static string GetSystemGroupFullNameByCode(string groupCode) { using (SingleEntityDAO ydao = new SingleEntityDAO("SystemGroup")) { EntityData data = ydao.SelectbyPrimaryKey(groupCode); if (data.HasRecord()) { string text = ""; string[] textArray = data.GetString("FullID").Split(new char[] { '-' }); foreach (string text3 in textArray) { data = ydao.SelectbyPrimaryKey(text3); if (data.HasRecord()) { text = text + " - " + data.GetString("GroupName"); } } return(text); } return(""); } }
public static void Add(string TaxItems, string Range, decimal TaxRate, string TaxPayer, string Remarks) { using (SingleEntityDAO ydao = new SingleEntityDAO("StampDuty")) { EntityData entitydata = ydao.SelectbyPrimaryKey(0); DataRow newRecord = entitydata.GetNewRecord(); newRecord["StampDutyID"] = 0; newRecord["TaxItems"] = TaxItems; newRecord["Range"] = Range; newRecord["TaxRate"] = TaxRate; newRecord["TaxPayer"] = TaxPayer; newRecord["Remarks"] = Remarks; entitydata.AddNewRecord(newRecord); ydao.SubmitEntity(entitydata); } }
public static EntityData GetSupplierMaterialByCode(string code) { EntityData data2; try { EntityData data; using (SingleEntityDAO ydao = new SingleEntityDAO("SupplierMaterial")) { data = ydao.SelectbyPrimaryKey(code); } data2 = data; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetBiddingDtlAuditingByCode(string code) { EntityData data2; try { EntityData data; using (SingleEntityDAO ydao = new SingleEntityDAO("BiddingDtlAuditing")) { data = ydao.SelectbyPrimaryKey(code); } data2 = data; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetRemindStrategyByCode(string code) { EntityData data2; try { EntityData data; using (SingleEntityDAO ydao = new SingleEntityDAO("RemindStrategy")) { data = ydao.SelectbyPrimaryKey(code); } data2 = data; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetPBSTypeLayoutByCode(string code) { EntityData data2; try { EntityData data; using (SingleEntityDAO ydao = new SingleEntityDAO("PBSTypeLayout")) { data = ydao.SelectbyPrimaryKey(code); } data2 = data; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetPurchaseFlowSelSupplyByCode(string code) { EntityData data2; try { EntityData data; using (SingleEntityDAO ydao = new SingleEntityDAO("PurchaseFlowSelSupply")) { data = ydao.SelectbyPrimaryKey(code); } data2 = data; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetGradeDepartmentPercentageByCode(string code) { EntityData data2; try { EntityData data; using (SingleEntityDAO ydao = new SingleEntityDAO("GradeDepartmentPercentage")) { data = ydao.SelectbyPrimaryKey(code); } data2 = data; } catch (Exception exception) { throw exception; } return(data2); }
public static StampDuty GetModel(int StampDutyID) { StampDuty duty = new StampDuty(); using (SingleEntityDAO ydao = new SingleEntityDAO("StampDuty")) { EntityData data = ydao.SelectbyPrimaryKey(StampDutyID); if (data.HasRecord()) { duty._StampDutyID = data.GetInt("StampDutyID"); duty.TaxItems = data.GetString("TaxItems"); duty.Range = data.GetString("Range"); duty.TaxRate = data.GetDecimal("TaxRate"); duty.TaxPayer = data.GetString("TaxPayer"); duty.Remarks = data.GetString("Remarks"); } } return(duty); }
public static EntityData GetVisualProgressByCode(string code) { EntityData data2; try { EntityData data; using (SingleEntityDAO ydao = new SingleEntityDAO("VisualProgress")) { data = ydao.SelectbyPrimaryKey(code); } data2 = data; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetClaimsExpressionsDetailByCode(string code) { EntityData data2; try { EntityData data; using (SingleEntityDAO ydao = new SingleEntityDAO("ClaimsExpressionsDetail")) { data = ydao.SelectbyPrimaryKey(code); } data2 = data; } catch (Exception exception) { throw exception; } return(data2); }
private EntityData GetOACachetByCode(string code) { EntityData data2; try { EntityData data; using (SingleEntityDAO ydao = new SingleEntityDAO("OACachet")) { data = ydao.SelectbyPrimaryKey(code); } data2 = data; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetConstructPlanStepByCode(string code) { EntityData data2; try { EntityData data; using (SingleEntityDAO ydao = new SingleEntityDAO("ConstructPlanStep")) { data = ydao.SelectbyPrimaryKey(code); } data2 = data; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetWorkFlow_LeaveByCode(string code) { EntityData data2; try { EntityData data; using (SingleEntityDAO ydao = new SingleEntityDAO("WorkFlow_Leave")) { data = ydao.SelectbyPrimaryKey(code); } data2 = data; } catch (Exception exception) { throw exception; } return(data2); }
private EntityData GetBidding_SupplierDepartmentIdeaByCode(string code) { EntityData data2; try { EntityData data; using (SingleEntityDAO ydao = new SingleEntityDAO("Bidding_SupplierDepartmentIdea")) { data = ydao.SelectbyPrimaryKey(code); } data2 = data; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetSubjectByCode(string subjectCode, string subjectSetCode) { EntityData data2; try { EntityData data; using (SingleEntityDAO ydao = new SingleEntityDAO("Subject")) { object[] keyvalues = new object[] { subjectCode, subjectSetCode }; data = ydao.SelectbyPrimaryKey(keyvalues); } data2 = data; } catch (Exception exception) { throw exception; } return(data2); }
public void SetNewSysCodeByCode(string tableName, object code) { string text = code.ToString(); string keyvalues = this.ReturnSyscodeName(tableName); using (SingleEntityDAO ydao = new SingleEntityDAO("SysCode")) { EntityData entity = ydao.SelectbyPrimaryKey(keyvalues); if (!entity.HasRecord()) { SystemManageDAO.GetNewSysCode(keyvalues); } else { string text3 = entity.GetString("CodeRule"); if ((text3.Length > 0) & !code.Equals(0)) { int count = text3.Split("+".ToCharArray())[0].Length; text = text.Remove(0, count).Trim().ToString(); } } int num2 = Convert.ToInt32(text); if (num2 <= 0) { DataRow newRecord = entity.GetNewRecord(); num2 = 0x186a1; entity.CurrentRow["CodeValue"] = num2; } else if (num2 > ((int)entity.CurrentRow["CodeValue"])) { entity.CurrentRow["CodeValue"] = num2; } SystemManageDAO.UpdateSysCode(entity); entity.Dispose(); } }
public static string GetBiddingDtlNameByCode(string code) { string text2; try { EntityData data; string text = ""; using (SingleEntityDAO ydao = new SingleEntityDAO("BiddingDtl")) { data = ydao.SelectbyPrimaryKey(code); } if (data.HasRecord()) { text = data.CurrentRow["Title"].ToString(); } text2 = text; } catch (Exception exception) { throw exception; } return(text2); }