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