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;
}
}
private string DoGetLogSqlStr(DataRow dr, string tablenm, int action, ILibDBHelp dBHelp)
{
//List<string> sqllist = new List<string>();
StringBuilder sql = new StringBuilder();
try
{
string logid = dr[SysConstManage.Sdp_LogId].ToString();
LibDbParameter[] parameters = new LibDbParameter[4];
parameters[0] = new LibDbParameter {
ParameterNm = "@logid", DbType = DbType.String, Value = logid
};
parameters[1] = new LibDbParameter {
ParameterNm = "@tablenm", DbType = DbType.String, Value = tablenm
};
parameters[2] = new LibDbParameter {
ParameterNm = "@ID", DbType = DbType.Int64, Direction = ParameterDirection.Output, Value = 0
};
parameters[3] = new LibDbParameter {
ParameterNm = "@logtbnm", DbType = DbType.String, Size = 35, Direction = ParameterDirection.Output, Value = string.Empty
};
dBHelp.StoredProcedureReturnValue(action == 1 ? "p_addlogM" : "p_GetlogM", parameters);
ColExtendedProperties colextprop = null;
object fieldvalue = null;
object oldfieldvalue = null;
if (!string.IsNullOrEmpty(parameters[3].Value.ToString()) && (Int64)parameters[2].Value != 0)
{
foreach (DataColumn c in dr.Table.Columns)
{
colextprop = Newtonsoft.Json.JsonConvert.DeserializeObject <ColExtendedProperties>(c.ExtendedProperties[SysConstManage.ExtProp].ToString());
if (!colextprop.IsActive)
{
continue;
}
if (action == 2 && LibSysUtils.Compare(dr[c, DataRowVersion.Original], dr[c, DataRowVersion.Current], false))
{
continue;
}
if (c.DataType == typeof(byte[]))
{
fieldvalue = dr[c] == DBNull.Value?string.Empty : Convert.ToBase64String((byte[])dr[c]);
oldfieldvalue = (action == 1 || dr[c, DataRowVersion.Original] == DBNull.Value)? string.Empty: Convert.ToBase64String((byte[])dr[c, DataRowVersion.Original]);
}
else
{
fieldvalue = dr[c];
oldfieldvalue = action == 1 ? string.Empty : dr[c, DataRowVersion.Original];
}
sql.AppendFormat(" EXEC sp_executesql N'insert into {0}(ID,Action,UserId,IP,DT,FieldNm,FieldValue,OldFieldValue) values(@ID,@Action,@UserId,@IP,@DT,@FieldNm,@FieldValue,@OldFieldValue) '", parameters[3].Value.ToString());
sql.Append(" ,N'@ID bigint,@Action char(1),@UserId nvarchar(30),@IP nvarchar(15),@DT datetime,@FieldNm nvarchar(30),@FieldValue ntext,@OldFieldValue ntext',");
sql.AppendFormat(" @ID={0},@Action='{1}',@UserId='{2}',@IP='{3}',@DT='{4}',@FieldNm='{5}',@FieldValue='{6}',@OldFieldValue='{7}' ",
(Int64)parameters[2].Value, action, this._clientInfo.UserId, this._clientInfo.IP, DateTime.Now, c.ColumnName, fieldvalue, oldfieldvalue);
//sqllist.Add(sql.ToString());
}
}
//dBHelp.ExecuteNonQuery(sql.ToString());
}
catch (Exception ex) {
}
return(sql.ToString());
}
protected override void DoSetParam(string tag, params object[] param)
{
base.DoSetParam(tag, param);
if (LibSysUtils.Compare(tag, "language"))
{
SDPCRL.COM.ModelManager.FormTemplate.LibFormPage fm = null;
SDPCRL.COM.ModelManager.LibKeyValueCollection keyValueCollection = null;
if (param.Length > 1)
{
ds = param[0] as LibDataSource;
fm = param[1] as SDPCRL.COM.ModelManager.FormTemplate.LibFormPage;
keyValueCollection = param[2] as SDPCRL.COM.ModelManager.LibKeyValueCollection;
}
if (keyValueCollection != null)
{
this.textBox1.Text = keyValueCollection.ID;
languagedt = this.BllData.Getlanguagebydsid(keyValueCollection.ID);
if (keyValueCollection.KeyValues != null)
{
foreach (LibKeyValue kv in keyValueCollection.KeyValues)
{
AddDataGridRow(string.Empty, kv.Key.ToString(), kv.Value.ToString());
}
}
}
if (ds == null)
{
return;
}
this.textBox1.Text = ds.DSID;
this.comboBox1.Items.Add(string.Empty);
languagedt = this.BllData.Getlanguagebydsid(ds.DSID);
foreach (LibDefineTable deftb in ds.DefTables)
{
foreach (LibDataTableStruct dt in deftb.TableStruct)
{
this.comboBox1.Items.Add(dt.Name);
FillDataGrid(dt, false);
}
}
if (fm != null)
{
DataTable dt = this.dataGridView1.DataSource as DataTable;
DataRow row = null;
if (dt != null)
{
AddDataGridRow(string.Empty, fm.FormId, fm.FormName);
if (fm.FormGroups != null)
{
foreach (SDPCRL.COM.ModelManager.FormTemplate.LibFormGroup fg in fm.FormGroups)
{
AddDataGridRow(string.Empty, fg.FormGroupName, fg.FormGroupDisplayNm);
}
}
if (fm.GridGroups != null)
{
foreach (SDPCRL.COM.ModelManager.FormTemplate.LibGridGroup gg in fm.GridGroups)
{
AddDataGridRow(string.Empty, gg.GridGroupName, gg.GridGroupDisplayNm);
if (gg.GdButtons == null)
{
continue;
}
foreach (LibGridButton item in gg.GdButtons)
{
AddDataGridRow(string.Empty, item.GridButtonName, item.GridButtonDisplayNm);
}
}
}
if (fm.BtnGroups != null)
{
foreach (LibButtonGroup btngroup in fm.BtnGroups)
{
if (btngroup.LibButtons == null)
{
continue;
}
//if(btngroup .LibButtons !=null )
//{
foreach (LibButton btn in btngroup.LibButtons)
{
AddDataGridRow(string.Empty, btn.LibButtonName, btn.LibButtonDisplayNm);
}
//}
}
}
}
}
}
}