public DescTypeInfo FindBOMDescrById(int id)
{
try
{
DescTypeInfo ret = null;
MethodBase mthObj = MethodBase.GetCurrentMethod();
int tk = mthObj.MetadataToken;
SQLContextNew sqlCtx = null;
lock (mthObj)
{
if (!SQLCache.PeerTheSQL(tk, out sqlCtx))
{
DescType cond = new DescType();
cond.id = id;
sqlCtx = FuncNew.GetConditionedSelect<DescType>(tk, null, null, new ConditionCollection<DescType>(new EqualCondition<DescType>(cond)));
}
}
sqlCtx.Param(DescType.fn_id).Value = id;
using (SqlDataReader sqlR = _Schema.SqlHelper.ExecuteReader(_Schema.SqlHelper.ConnectionString_GetData, CommandType.Text, sqlCtx.Sentence, sqlCtx.Params))
{
ret = FuncNew.SetFieldFromColumn<DescType, DescTypeInfo>(ret, sqlR, sqlCtx);
}
return ret;
}
catch (Exception)
{
throw;
}
}
public IList<string> GetDescriptionOfDescTypeListByTpAndCode(string tp, string code)
{
try
{
IList<string> ret = null;
MethodBase mthObj = MethodBase.GetCurrentMethod();
int tk = mthObj.MetadataToken;
SQLContextNew sqlCtx = null;
lock (mthObj)
{
if (!SQLCache.PeerTheSQL(tk, out sqlCtx))
{
DescType cond = new DescType();
cond.tp = tp;
cond.code = code;
sqlCtx = FuncNew.GetConditionedSelect<DescType>(tk, "DISTINCT", new string[] { DescType.fn_description }, new ConditionCollection<DescType>(new EqualCondition<DescType>(cond)), DescType.fn_description);
}
}
sqlCtx.Param(DescType.fn_tp).Value = tp;
sqlCtx.Param(DescType.fn_code).Value = code;
using (SqlDataReader sqlR = _Schema.SqlHelper.ExecuteReader(_Schema.SqlHelper.ConnectionString_GetData, CommandType.Text, sqlCtx.Sentence, sqlCtx.Params))
{
if (sqlR != null)
{
ret = new List<string>();
while (sqlR.Read())
{
string item = g.GetValue_Str(sqlR, sqlCtx.Indexes(DescType.fn_description));
ret.Add(item);
}
}
}
return ret;
}
catch (Exception)
{
throw;
}
}
public void DeleteBOMDescrById(int id)
{
try
{
MethodBase mthObj = MethodBase.GetCurrentMethod();
int tk = mthObj.MetadataToken;
SQLContextNew sqlCtx = null;
lock (mthObj)
{
if (!SQLCache.PeerTheSQL(tk, out sqlCtx))
{
DescType cond = new DescType();
cond.id = id;
sqlCtx = FuncNew.GetConditionedDelete<DescType>(tk, new ConditionCollection<DescType>(new EqualCondition<DescType>(cond)));
}
}
sqlCtx.Param(DescType.fn_id).Value = id;
_Schema.SqlHelper.ExecuteNonQuery(_Schema.SqlHelper.ConnectionString_GetData, CommandType.Text, sqlCtx.Sentence, sqlCtx.Params);
}
catch (Exception)
{
throw;
}
}