82 lines
3.0 KiB
C#
82 lines
3.0 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
|
|
namespace SqlSugar
|
|
{
|
|
public class OracleUpdateBuilder : UpdateBuilder
|
|
{
|
|
protected override string TomultipleSqlString(List<IGrouping<int, DbColumnInfo>> groupList)
|
|
{
|
|
StringBuilder sb = new StringBuilder();
|
|
sb.AppendLine("Begin");
|
|
sb.AppendLine(string.Join("\r\n", groupList.Select(t =>
|
|
{
|
|
var updateTable = string.Format("UPDATE {0} SET", base.GetTableNameStringNoWith);
|
|
var setValues = string.Join(",", t.Where(s => !s.IsPrimarykey).Select(m => GetOracleUpdateColums(m)).ToArray());
|
|
var pkList = t.Where(s => s.IsPrimarykey).ToList();
|
|
List<string> whereList = new List<string>();
|
|
foreach (var item in pkList)
|
|
{
|
|
var isFirst = pkList.First() == item;
|
|
var whereString = isFirst ? " " : " AND ";
|
|
whereString += GetOracleUpdateColums(item);
|
|
whereList.Add(whereString);
|
|
}
|
|
return string.Format("{0} {1} WHERE {2};", updateTable, setValues, string.Join("",whereList));
|
|
}).ToArray()));
|
|
sb.AppendLine("End;");
|
|
return sb.ToString();
|
|
}
|
|
|
|
private string GetOracleUpdateColums(DbColumnInfo m)
|
|
{
|
|
return string.Format("\"{0}\"={1}", m.DbColumnName.ToUpper(), FormatValue(m.Value));
|
|
}
|
|
|
|
public override object FormatValue(object value)
|
|
{
|
|
if (value == null)
|
|
{
|
|
return "NULL";
|
|
}
|
|
else
|
|
{
|
|
var type = UtilMethods.GetUnderType(value.GetType());
|
|
if (type == UtilConstants.DateType)
|
|
{
|
|
var date = value.ObjToDate();
|
|
if (date < Convert.ToDateTime("1900-1-1"))
|
|
{
|
|
date = Convert.ToDateTime("1900-1-1");
|
|
}
|
|
return "to_date('" + date.ToString("yyyy-MM-dd HH:mm:ss") + "', 'YYYY-MM-DD HH24:MI:SS') ";
|
|
}
|
|
else if (type.IsEnum())
|
|
{
|
|
return Convert.ToInt64(value);
|
|
}
|
|
else if (type == UtilConstants.ByteArrayType)
|
|
{
|
|
string bytesString = "0x" + BitConverter.ToString((byte[])value).Replace("-", "");
|
|
return bytesString;
|
|
}
|
|
else if (type == UtilConstants.BoolType)
|
|
{
|
|
return value.ObjToBool() ? "1" : "0";
|
|
}
|
|
else if (type == UtilConstants.StringType || type == UtilConstants.ObjType)
|
|
{
|
|
return "N'" + value.ToString().ToSqlFilter() + "'";
|
|
}
|
|
else
|
|
{
|
|
return "N'" + value.ToString() + "'";
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|