public void SaveChange(LibTableObj[] tableObjs, bool IsTrans = true)
{
if (tableObjs == null || tableObjs.Length == 0)
{
return;
}
try
{
if (IsTrans)
{
this.BeginTrans();
}
DataTable dt = null;
StringBuilder fields = null;
StringBuilder cols = null;
StringBuilder fieldtypes = null;
StringBuilder fieldvalue = null;
StringBuilder updateFields = null;
StringBuilder updatefldtypes = null;
StringBuilder updatefldval = null;
StringBuilder updatewhere = null;
string sql = string.Empty;
ColExtendedProperties colextprop = null;
TableExtendedProperties tbextprop = null;
List <object> updatevalue = null;
foreach (LibTableObj tableObj in tableObjs)
{
dt = tableObj.DataTable;
tbextprop = Newtonsoft.Json.JsonConvert.DeserializeObject <TableExtendedProperties>(dt.ExtendedProperties[SysConstManage.ExtProp].ToString());
if (tbextprop == null)
{
//520：系统无法识别的表对象，请使用模型实例化表对象。
throw new LibExceptionBase(520);
}
if (!tbextprop.Ignore)
{
continue;
}
fields = new StringBuilder();
cols = new StringBuilder();
fieldtypes = new StringBuilder();
fieldvalue = new StringBuilder();
List <int> bytecols = new List <int>();
foreach (DataColumn col in dt.Columns)
{
colextprop = Newtonsoft.Json.JsonConvert.DeserializeObject <ColExtendedProperties>(col.ExtendedProperties[SysConstManage.ExtProp].ToString());
if (!colextprop.IsActive)
{
continue;
}
if (fields.Length > 0)
{
fields.Append(",");
fieldtypes.Append(",");
fieldvalue.Append(",");
cols.Append(",");
}
fields.AppendFormat("@{0}", col.ColumnName);
fieldtypes.AppendFormat("@{0} ", col.ColumnName);
cols.AppendFormat("{0}", col.ColumnName);
if (col.DataType == typeof(byte[]))
{
bytecols.Add(dt.Columns.IndexOf(col));
}
SetColmnTypeAndValue(col, col.ColumnName, colextprop, fieldtypes, fieldvalue, dt.Columns.IndexOf(col));
}
foreach (DataRow row in dt.Rows)
{
switch (row.RowState)
{
case DataRowState.Added:
row[SysConstManage.Sdp_LogId] = LogHelp.GenerateLogId();
object[] vals = new object[row.ItemArray.Length];
if (bytecols.Count > 0)
{
for (int a = 0; a < row.ItemArray.Length; a++)
{
vals[a] = bytecols.Contains(a) && row.ItemArray[a] != DBNull.Value ? Convert.ToBase64String((byte[])row.ItemArray[a]) : row.ItemArray[a];
}
}
else
{
vals = row.ItemArray;
}
sql = string.Format(string.Format("EXEC sp_executesql N'insert into {0}({1}) values({2}) ',N'{3}',{4}",
dt.TableName, cols.ToString(), fields.ToString(), fieldtypes.ToString(), fieldvalue.ToString()
),
vals);
break;
case DataRowState.Modified:
updateFields = new StringBuilder();
updatefldtypes = new StringBuilder();
updatefldval = new StringBuilder();
updatewhere = new StringBuilder();
updatevalue = new List <object>();
int index = 0;
foreach (DataColumn c in dt.Columns)
{
colextprop = Newtonsoft.Json.JsonConvert.DeserializeObject <ColExtendedProperties>(c.ExtendedProperties[SysConstManage.ExtProp].ToString());
if (!colextprop.IsActive)
{
continue;
}
if (!LibSysUtils.Compare(row[c, DataRowVersion.Original], row[c, DataRowVersion.Current], false))
{
if (updateFields.Length > 0)
{
updateFields.Append(",");
}
if (updatefldtypes.Length > 0)
{
updatefldtypes.Append(",");
}
if (updatefldval.Length > 0)
{
updatefldval.Append(",");
}
updateFields.AppendFormat("{0}=@{0}", c.ColumnName);
updatefldtypes.AppendFormat("@{0} ", c.ColumnName);
SetColmnTypeAndValue(c, c.ColumnName, colextprop, updatefldtypes, updatefldval, index);
index++;
if (c.DataType.Equals(typeof(byte[])))
{
updatevalue.Add(Convert.ToBase64String((byte[])row[c, DataRowVersion.Current]));
}
else
{
updatevalue.Add(row[c, DataRowVersion.Current]);
}
}
if (dt.PrimaryKey.Contains(c))
{
if (updatewhere.Length > 0)
{
updatewhere.Append(" And ");
}
if (updatefldtypes.Length > 0)
{
updatefldtypes.Append(",");
updatefldval.Append(",");
}
updatewhere.AppendFormat("{0}=@{1}", c.ColumnName, string.Format("{0}1", c.ColumnName));
updatefldtypes.AppendFormat("@{0} ", string.Format("{0}1", c.ColumnName));
SetColmnTypeAndValue(c, string.Format("{0}1", c.ColumnName), colextprop, updatefldtypes, updatefldval, index);
index++;
updatevalue.Add(row[c, DataRowVersion.Original]);
}
}
if (updateFields.Length > 0)
{
sql = string.Format(string.Format("EXEC sp_executesql N'Update {0} Set {1} where {2}',N'{3}',{4}",
dt.TableName,
updateFields.ToString(),
updatewhere.ToString(),
updatefldtypes.ToString(),
updatefldval.ToString()
),
updatevalue.ToArray());
break;
}
continue;
case DataRowState.Deleted:
updatefldtypes = new StringBuilder();
updatefldval = new StringBuilder();
updatewhere = new StringBuilder();
updatevalue = new List <object>();
index = 0;
foreach (DataColumn col in dt.PrimaryKey)
{
colextprop = Newtonsoft.Json.JsonConvert.DeserializeObject <ColExtendedProperties>(col.ExtendedProperties[SysConstManage.ExtProp].ToString());
if (updatewhere.Length > 0)
{
updatewhere.Append(" And ");
}
if (updatefldtypes.Length > 0)
{
updatefldtypes.Append(",");
updatefldval.Append(",");
}
updatewhere.AppendFormat("{0}=@{1}", col.ColumnName, string.Format("{0}1", col.ColumnName));
updatefldtypes.AppendFormat("@{0} ", string.Format("{0}1", col.ColumnName));
SetColmnTypeAndValue(col, string.Format("{0}1", col.ColumnName), colextprop, updatefldtypes, updatefldval, index);
index++;
updatevalue.Add(row[col, DataRowVersion.Original]);
}
if (updatefldval.Length > 0)
{
sql = string.Format(string.Format("EXEC sp_executesql N'Delete from {0} where {1}',N'{2}',{3}",
dt.TableName,
updatewhere.ToString(),
updatefldtypes.ToString(),
updatefldval.ToString()
),
updatevalue.ToArray());
break;
}
continue;
//break;
default:
continue;
//break;
}
this.ExecuteNonQuery(sql);
}
}
if (IsTrans)
{
this.CommitTrans();
WriteDataLog(tableObjs);
}
}
catch (Exception ex)
{
if (IsTrans)
{
this.RollbackTrans();
}
throw ex;
}
}