protected SqlParameter CreateParemeter(ETT_Condition pETT_Field, int pIndex, ref string pParaName)
{
try
{
pParaName = "@" + pETT_Field.DBColumnName + pIndex.ToString();
SqlParameter para = CreateParameter(pParaName, pETT_Field.Value, pETT_Field.DBDataType);
return(para);
}
catch (Exception)
{
throw;
}
}
public virtual bool Insert()
{
try
{
_lstMessage = new List <string>();
bool NotExists = true;
foreach (ETT_Field properties in _lstProperties)
{
if (properties.IsUnique)
{
List <ETT_Condition> lstCondition = new List <ETT_Condition>();
ETT_Condition EqualValue = new ETT_Condition(properties.DBColumnName);
EqualValue.Value = properties.Value;
lstCondition.Add(EqualValue);
if (Exists(lstCondition))
{
NotExists = false;
_lstMessage.Add("Exists " + properties.DisplayName + " = " + properties.Value.ToString());
}
}
}
if (NotExists)
{
List <ETT_Field> Values = new List <ETT_Field>();
foreach (ETT_Field ett in _lstProperties)
{
if (!ett.IsAutoIncrease)
{
Values.Add(ett);
}
}
int effected = _dal.Insert(_TableName, Values);
if (effected > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
