protected string AddParameter(DataField df)
{
We7DataColumn dc = df.Column;
string _f0 = String.Format("{0}P{1}", Prefix, parametersCount++);
DataParameter _f1 = new DataParameter();
_f1.DbType = ModelDBHelper.ConvertTypeCodeToDbType(dc.DataType);
_f1.ParameterName = _f0;
_f1.Value = df.Value;
_f1.SourceColumn = dc.Name;
_f1.Size = dc.MaxLength;
_f1.IsNullable = dc.Nullable;
if (_f1.Value == null)
{
if (_f1.DbType == DbType.String)
{
_f1.Value = "";
}
else if (_f1.DbType == DbType.DateTime)
{
_f1.Value = DateTime.Now;
}
}
SQL.Parameters.Add(_f1);
return(_f0);
}
protected string AddParameter(We7DataColumn dc, object v)
{
string _f0 = String.Format("{0}P{1}", Prefix, parametersCount++);
DataParameter _f1 = new DataParameter();
_f1.DbType = ModelDBHelper.ConvertTypeCodeToDbType(dc.DataType);
_f1.ParameterName = _f0;
_f1.Value = v;
_f1.SourceColumn = dc.Name;
_f1.Size = dc.MaxLength;
_f1.IsNullable = dc.Nullable;
SQL.Parameters.Add(_f1);
return(_f0);
}