/// <summary>
/// 获取辅料類物料列表
/// </summary>
/// <param name="strSONO">銷售單號</param>
private List<MaterialProfile_mlpf_Info> GetAccessoryMaterials(string strSONO)
{
List<MaterialProfile_mlpf_Info> listAccessoryInfos = new List<MaterialProfile_mlpf_Info>();
try
{
string strSql = GetAccessoryMaterialsSQL(strSONO);
if (!string.IsNullOrEmpty(strSql))
{
using (ICPDBDataContext db = new ICPDBDataContext())
{
var result = db.ExecuteQuery<MaterialProfile_mlpf_Info>(strSql, new object[] { });
if (result != null)
{
listAccessoryInfos.AddRange(result.ToList());
}
}
}
}
catch (Exception ex)
{
mLog.Error("run ICPDBServiceDA.GetAccessoryMaterials", ex);
}
return listAccessoryInfos;
}
/// <summary>
/// 庫存物料搜索
/// </summary>
/// <param name="p_objFilter"></param>
/// <returns></returns>
public List<MaterialProfile_mlpf_Info> MaterialInventorySearch(ERPMaterialFilter p_objFilter)
{
using (ICPDBDataContext db = new ICPDBDataContext())
{
var infos = db.ExecuteQuery<MaterialProfile_mlpf_Info>(GetInventoryMaterialSQL(p_objFilter), new object[] { });
if (infos != null)
{
return infos.ToList<MaterialProfile_mlpf_Info>();
}
}
return null;
}
/// <summary>
/// 獲取物料類型
/// </summary>
public List<ValueNameInfo> GetICPDBSort()
{
List<ValueNameInfo> retValue = new List<ValueNameInfo>();
StringBuilder l_strSQL = new StringBuilder();
l_strSQL.AppendLine("Select Distinct cat_cLevel As ID,cat_cCat As CodeID,cat_cSub1 As Display,cat_cChn As Remark From icpcat");
using (ICPDBDataContext db = new ICPDBDataContext())
{
var infos = db.ExecuteQuery<ValueNameInfo>(l_strSQL.ToString(), new object[] { });
if (infos != null)
{
retValue = infos.ToList<ValueNameInfo>();
}
}
return retValue;
}
/// <summary>
/// 獲取種類
/// </summary>
public List<ValueNameInfo> GetICPDBType()
{
List<ValueNameInfo> retValue = new List<ValueNameInfo>();
StringBuilder l_strSQL = new StringBuilder();
l_strSQL.AppendLine("Select Distinct cod_cValue As CodeID,cod_cRmk As Display From icpcod Where cod_ckey1 = 'itemtype'");
using (ICPDBDataContext db = new ICPDBDataContext())
{
var infos = db.ExecuteQuery<ValueNameInfo>(l_strSQL.ToString(), new object[] { });
if (infos != null)
{
retValue = infos.ToList<ValueNameInfo>();
}
}
return retValue;
}
/// <summary>
/// 獲取牌子
/// </summary>
public List<ValueNameInfo> GetICPDBBrand(string strMain, string strSub)
{
List<ValueNameInfo> retValue = new List<ValueNameInfo>();
StringBuilder l_strSQL = new StringBuilder();
l_strSQL.AppendLine("Select Distinct som_cESp As CodeID,som_cCSp As Display From icpsom Where 1=1 And som_cfld='BRAND'");
if (strMain != string.Empty)
l_strSQL.AppendLine(" And som_ccat='" + strMain + "'");
if (strSub != string.Empty)
l_strSQL.AppendLine(" And som_csub1='" + strSub + "'");
using (ICPDBDataContext db = new ICPDBDataContext())
{
var infos = db.ExecuteQuery<ValueNameInfo>(l_strSQL.ToString(), new object[] { });
if (infos != null)
{
retValue = infos.ToList<ValueNameInfo>();
}
}
return retValue;
}
/// <summary>
/// 獲取牌子欄位
/// </summary>
/// <param name="strMain"></param>
/// <param name="strSub"></param>
/// <returns></returns>
string GetBrandColumn(string strMain, string strSub)
{
string retValue = string.Empty;
StringBuilder strSql = new StringBuilder();
strSql.AppendLine(" select ");
strSql.AppendLine("Case When cat_cesp1='BRAND' Then 'itm_cCSp1'");
strSql.AppendLine("When cat_cesp2='BRAND' Then 'itm_cCSp2'");
strSql.AppendLine("When cat_cesp3='BRAND' Then 'itm_cCSp3'");
strSql.AppendLine("When cat_cesp4='BRAND' Then 'itm_cCSp4'");
strSql.AppendLine("When cat_cesp5='BRAND' Then 'itm_cCSp5'");
strSql.AppendLine("When cat_cesp6='BRAND' Then 'itm_cCSp6'");
strSql.AppendLine("When cat_cesp7='BRAND' Then 'itm_cCSp7'");
strSql.AppendLine("When cat_cesp8='BRAND' Then 'itm_cCSp8'");
strSql.AppendLine("When cat_cesp9='BRAND' Then 'itm_cCSp9'");
strSql.AppendLine("Else 'itm_cCSp10' End As BrandColumn");
strSql.AppendLine("from icpcat");
strSql.AppendLine("where cat_cSub1='" + strSub + "' And cat_ccat='" + strMain + "'");
using (ICPDBDataContext db = new ICPDBDataContext())
{
var infos = db.ExecuteQuery<string>(strSql.ToString(), new object[] { });
if (infos != null)
{
retValue = infos.ToList<string>()[0];
}
}
return retValue;
}
/// <summary>
/// 跟Job物料搜索
/// </summary>
/// <param name="p_objFilter"></param>
/// <returns></returns>
public List<MaterialProfile_mlpf_Info> MaterialJobSearch(ERPMaterialFilter p_objFilter)
{
//IList<IDomainObject> retValue = new List<IDomainObject>();
//Database db = DatabaseFactory.CreateDatabase("ICPDB");
//DbCommand dbCommand = db.GetSqlStringCommand(GetJobMaterialSQL(p_objFilter));
//MaterialProfile item;
//using (IDataReader dataReader = db.ExecuteReader(dbCommand))
//{
// while (dataReader.Read())
// {
// item = new MaterialProfile();
// GetERPItemData(dataReader, item);
// //GetGroupItemData(dataReader, item);
// retValue.Add(item);
// }
//}
//return retValue;
using (ICPDBDataContext db = new ICPDBDataContext())
{
var infos = db.ExecuteQuery<MaterialProfile_mlpf_Info>(GetJobMaterialSQL(p_objFilter), new object[] { });
if (infos != null)
{
return infos.ToList<MaterialProfile_mlpf_Info>();
}
}
return null;
}
