public void DeleteSelectedACAdaptor(int id)
{
try
{
MethodBase mthObj = MethodBase.GetCurrentMethod();
int tk = mthObj.MetadataToken;
SQLContextNew sqlCtx = null;
lock (mthObj)
{
if (!SQLCache.PeerTheSQL(tk, out sqlCtx))
{
AcAdapMaintain cond = new AcAdapMaintain();
cond.id = id;
sqlCtx = FuncNew.GetConditionedDelete<AcAdapMaintain>(tk, new ConditionCollection<AcAdapMaintain>(new EqualCondition<AcAdapMaintain>(cond)));
}
}
sqlCtx.Param(AcAdapMaintain.fn_id).Value = id;
_Schema.SqlHelper.ExecuteNonQuery(_Schema.SqlHelper.ConnectionString_BOM, CommandType.Text, sqlCtx.Sentence, sqlCtx.Params);
}
catch (Exception)
{
throw;
}
}
public void UpdateOneAcAdaptor(ACAdaptor newItem)
{
try
{
MethodBase mthObj = MethodBase.GetCurrentMethod();
int tk = mthObj.MetadataToken;
SQLContextNew sqlCtx = null;
lock (mthObj)
{
if (!SQLCache.PeerTheSQL(tk, out sqlCtx))
{
AcAdapMaintain cond = new AcAdapMaintain();
cond.id = newItem.id;
AcAdapMaintain setv = FuncNew.SetColumnFromField<AcAdapMaintain, ACAdaptor>(newItem, AcAdapMaintain.fn_id);
setv.udt = DateTime.Now;
sqlCtx = FuncNew.GetConditionedUpdate<AcAdapMaintain>(tk, new SetValueCollection<AcAdapMaintain>(new CommonSetValue<AcAdapMaintain>(setv)), new ConditionCollection<AcAdapMaintain>(new EqualCondition<AcAdapMaintain>(cond)));
}
}
sqlCtx.Param(AcAdapMaintain.fn_id).Value = newItem.id;
sqlCtx = FuncNew.SetColumnFromField<AcAdapMaintain, ACAdaptor>(sqlCtx, newItem, true);
DateTime cmDt = _Schema.SqlHelper.GetDateTime();
sqlCtx.Param(g.DecSV(AcAdapMaintain.fn_udt)).Value = cmDt;
_Schema.SqlHelper.ExecuteNonQuery(_Schema.SqlHelper.ConnectionString_BOM, CommandType.Text, sqlCtx.Sentence, sqlCtx.Params);
}
catch (Exception)
{
throw;
}
}
public IList<ACAdaptor> GetACAdaptorByAssembly(string Assembly)
{
try
{
IList<ACAdaptor> ret = null;
MethodBase mthObj = MethodBase.GetCurrentMethod();
int tk = mthObj.MetadataToken;
SQLContextNew sqlCtx = null;
lock (mthObj)
{
if (!SQLCache.PeerTheSQL(tk, out sqlCtx))
{
AcAdapMaintain cond = new AcAdapMaintain();
cond.assemb = Assembly + "%";
sqlCtx = FuncNew.GetConditionedSelect<AcAdapMaintain>(tk, null, null, new ConditionCollection<AcAdapMaintain>(new LikeCondition<AcAdapMaintain>(cond)), AcAdapMaintain.fn_assemb);
}
}
sqlCtx.Param(AcAdapMaintain.fn_assemb).Value = Assembly + "%";
using (SqlDataReader sqlR = _Schema.SqlHelper.ExecuteReader(_Schema.SqlHelper.ConnectionString_BOM, CommandType.Text, sqlCtx.Sentence, sqlCtx.Params))
{
ret = FuncNew.SetFieldFromColumn<AcAdapMaintain, ACAdaptor, ACAdaptor>(ret, sqlR, sqlCtx);
}
return ret;
}
catch (Exception)
{
throw;
}
}
