private static string GetValue(EnumerableRowCollection <DataRow> fieldRows, string fieldCode, string value)
{
if (Config.Constant.IsOracleDb)
{
var field = fieldRows.SingleOrDefault(c => c.Field <string>("FIELDCODE").ToUpper() == fieldCode.ToUpper());
if (string.IsNullOrEmpty(value))
{
if (field["TYPE"].ToString() != "NVARCHAR2" && field["NULLABLE"].ToString() == "1")
{
value = "NULL";
}
else
{
value = "''";
}
}
else
{
if (field["TYPE"].ToString().Contains("TIMESTAMP"))
{
value = string.Format("to_date('{0}','yyyy-MM-dd hh24:mi:ss')", DateTime.Parse(value));
}
else
{
value = "N'" + value + "'";
}
}
return(value);
}
else
{
var field = fieldRows.SingleOrDefault(c => c.Field <string>("FieldCode") == fieldCode);
if (string.IsNullOrEmpty(value))
{
if (field["Type"].ToString() != "nvarchar" && field["Nullable"].ToString() == "1")
{
value = "NULL";
}
else
{
value = "''";
}
}
else
{
if (field["Type"].ToString() == "varbinary" && field["Length"].ToString() == "500")
{
value = string.Format("EncryptByKey(KEY_GUID('SymmetricByCert'), N'{0}')", value);
}
else
{
value = "N'" + value + "'";
}
}
return(value);
}
}
private static string GetValue(EnumerableRowCollection <DataRow> fieldRows, string fieldCode, string value)
{
if (string.IsNullOrEmpty(value))
{
var field = fieldRows.SingleOrDefault(c => c.Field <string>("FieldCode") == fieldCode);
if (field["Type"].ToString() != "nvarchar" && field["Nullable"].ToString() == "1")
{
value = "NULL";
}
else
{
value = "''";
}
}
else
{
value = "'" + value + "'";
}
return(value);
}