/// <summary>
/// 查询关联商品
/// </summary>
/// <param name="p1SysNo"></param>
/// <param name="pMType"></param>
/// <param name="mIndex"></param>
/// <returns></returns>
public static DataTable GetProductMappingInfo(int p1SysNo, ProductMappingType pMType, string mIndex)
{
string mIndexSerachSqlCmd = String.IsNullOrEmpty(mIndex) ? String.Empty : String.Format("and pm.M_Index like '%{0}%'", mIndex);
string sqlCmd = String.Format(getPMInfoSqlCmdTemplate, p1SysNo, (int)pMType, mIndexSerachSqlCmd);
return(new SqlDBHelper().ExecuteQuery(sqlCmd));
}
/// <summary>
/// 查询关联商品
/// </summary>
/// <param name="p1SysNo"></param>
/// <param name="pMType"></param>
/// <param name="mIndex"></param>
/// <returns></returns>
public static DataTable GetProductMappingInfo(int p1SysNo, ProductMappingType pMType, string mIndex)
{
string mIndexSerachSqlCmd = String.IsNullOrEmpty(mIndex) ? String.Empty : String.Format("and pm.M_Index like '%{0}%'", mIndex);
string sqlCmd = String.Format(getPMInfoSqlCmdTemplate, p1SysNo, (int)pMType, mIndexSerachSqlCmd);
return new SqlDBHelper().ExecuteQuery(sqlCmd);
}
