public IList<CtoBomInfo> GetCTOBomList(string mpno, string spno)
{
try
{
IList<CtoBomInfo> ret = null;
MethodBase mthObj = MethodBase.GetCurrentMethod();
int tk = mthObj.MetadataToken;
SQLContextNew sqlCtx = null;
lock (mthObj)
{
if (!SQLCache.PeerTheSQL(tk, out sqlCtx))
{
Ctobom cond = new Ctobom();
cond.mpno = mpno;
cond.spno = spno;
sqlCtx = FuncNew.GetConditionedSelect<Ctobom>(tk, null, null, new ConditionCollection<Ctobom>(new EqualCondition<Ctobom>(cond)), Ctobom.fn_id);
}
}
sqlCtx.Param(Ctobom.fn_mpno).Value = mpno;
sqlCtx.Param(Ctobom.fn_spno).Value = spno;
using (SqlDataReader sqlR = _Schema.SqlHelper.ExecuteReader(_Schema.SqlHelper.ConnectionString_BOM, CommandType.Text, sqlCtx.Sentence, sqlCtx.Params))
{
ret = FuncNew.SetFieldFromColumn<Ctobom, CtoBomInfo, CtoBomInfo>(ret, sqlR, sqlCtx);
}
return ret;
}
catch (Exception)
{
throw;
}
}
public IList<string> GetCTOBomDescr(string mpno, string spno)
{
try
{
IList<string> ret = null;
MethodBase mthObj = MethodBase.GetCurrentMethod();
int tk = mthObj.MetadataToken;
SQLContextNew sqlCtx = null;
lock (mthObj)
{
if (!SQLCache.PeerTheSQL(tk, out sqlCtx))
{
Ctobom cond = new Ctobom();
cond.mpno = mpno;
cond.spno = spno;
sqlCtx = FuncNew.GetConditionedSelect<Ctobom>(tk, "DISTINCT", new string[] { Ctobom.fn_descr }, new ConditionCollection<Ctobom>(new EqualCondition<Ctobom>(cond)), Ctobom.fn_descr);
}
}
sqlCtx.Param(Ctobom.fn_mpno).Value = mpno;
sqlCtx.Param(Ctobom.fn_spno).Value = spno;
using (SqlDataReader sqlR = _Schema.SqlHelper.ExecuteReader(_Schema.SqlHelper.ConnectionString_BOM, CommandType.Text, sqlCtx.Sentence, sqlCtx.Params))
{
if (sqlR != null)
{
ret = new List<string>();
while (sqlR.Read())
{
string item = g.GetValue_Str(sqlR, sqlCtx.Indexes(Ctobom.fn_descr));
ret.Add(item);
}
}
}
return ret;
}
catch (Exception)
{
throw;
}
}
