You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
32 lines
1.3 KiB
32 lines
1.3 KiB
namespace CounsellorBL.PRD.ConstDefinition
|
|
{
|
|
using OT.COM.ArsenalDB;
|
|
using OT.COM.ArsenalDB.SQL;
|
|
using SoldierData.EnterprizeV4;
|
|
|
|
|
|
internal class PrdSQLLib : DirectSQLLibBase
|
|
{
|
|
public PrdSQLLib(ADirectSQLHelper i_sqlLibBase) : base(i_sqlLibBase) { }
|
|
|
|
public virtual string GetArticleProduct(string i_sArticleUid, out Command o_cResult)
|
|
{
|
|
ADirectCmdParameter cp = GetParamter();
|
|
|
|
string sSQL = $@"SELECT a.{tb_prd_product.CN_UID}
|
|
, a.{tb_prd_product.CN_NAME}
|
|
, a.{tb_prd_product.CN_MEMO}
|
|
, b.{tb_prd_article2product.CN_WHOLESALE_PRICE}
|
|
, b.{tb_prd_article2product.CN_PRICE}
|
|
, b.{tb_prd_article2product.CN_SEQ}
|
|
, b.{tb_prd_article2product.CN_SPECIFICATION}
|
|
FROM {GetFormalTableName<tb_prd_product>()} a
|
|
LEFT JOIN {GetFormalTableName<tb_prd_article2product>()} b
|
|
on a.{tb_prd_product.CN_UID} = b.{tb_prd_article2product.CN_PRD_UID}
|
|
where b.{tb_prd_article2product.CN_ARTICLE_UID} = {cp.Add(i_sArticleUid)}
|
|
order by b.{tb_prd_article2product.CN_SEQ}";
|
|
|
|
return GenerateCommand<tb_prd_product>(sSQL, cp, out o_cResult);
|
|
}
|
|
}
|
|
}
|