public void Add(ETT_Field pETT, object pValue) { try { Add(pETT, pValue, true); } catch (Exception) { throw; } }
public void Add(ETT_Field pETT) { try { _ListCondition.Add(pETT); } catch (Exception) { throw; } }
protected SqlParameter CreateParemeter(ETT_Field pETT_Field) { try { SqlParameter para = CreateParameter(pETT_Field.DBColumnName, pETT_Field.Value, pETT_Field.DBDataType); return(para); } catch (Exception) { throw; } }
protected SqlParameter CreateParemeterNewValue(ETT_Field pETT_Field, int pIndex, ref string pParaName) { try { pParaName = "@" + pETT_Field.DBColumnName + pIndex.ToString(); SqlParameter para = CreateParameter(pParaName, pETT_Field.NewValue, pETT_Field.DBDataType); return(para); } catch (Exception) { throw; } }
public virtual void Select(ETT_Field pEtt) { try { List <ETT_Field> Conditions = new List <ETT_Field>(); Conditions.Add(pEtt); DataTable dt = _dal.Select(_TableName, Conditions).Tables[_TableName]; SetValue(dt); } catch (Exception) { throw; } }
public virtual void Select(int pID) { try { List <ETT_Field> Conditions = new List <ETT_Field>(); ETT_Field ID = new ETT_Field("ID"); ID.DBDataType = SqlDbType.Int; ID.Value = pID; Conditions.Add(ID); DataTable dt = _dal.Select(_TableName, Conditions).Tables[_TableName]; SetValue(dt); } catch (Exception) { throw; } }
public virtual void Delete(int pID) { try { List <ETT_Field> Conditions = new List <ETT_Field>(); ETT_Field ID = new ETT_Field("ID"); ID.DBDataType = SqlDbType.Int; ID.Value = pID; Conditions.Add(ID); int effected = _dal.Delete(_TableName, Conditions); foreach (ETT_Field ett in _lstProperties) { ett.Value = new object(); } } catch (Exception) { throw; } }
public void Add(ETT_Field pETT, bool NotAddEmpty) { try { if (NotAddEmpty) { if (!_cmm.IsNullOrEmpty(pETT.Value)) { _ListCondition.Add(pETT); } } else { _ListCondition.Add(pETT); } } catch (Exception) { throw; } }