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;
}
}
