/// <summary>
/// 保存OpenIDBinding
/// </summary>
/// <param name="binding"></param>
public void SaveOpenIDBinding(OpenIDBinding binding)
{
binding.NullCheck("binding");
string sql = ORMapping.GetInsertSql(binding, TSqlBuilder.Instance);
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
using (DbContext context = DbContext.GetContext(DataAdapter.DBConnectionName))
{
Database db = DatabaseFactory.Create(DataAdapter.DBConnectionName);
try
{
db.ExecuteNonQuery(CommandType.Text, sql);
}
catch (SqlException ex)
{
if (ex.Number == 2627)
{
throw new OpenIDBindingException(Translator.Translate(Define.DefaultCategory, "OpenID已经绑定到某用户了，不能重复绑定"));
}
throw;
}
}
scope.Complete();
}
}
public void Update(string processID, WfProcessRelativeParamCollection relativeParams)
{
processID.CheckStringIsNullOrEmpty("processID");
WhereSqlClauseBuilder wBuilder = new WhereSqlClauseBuilder();
wBuilder.AppendItem("PROCESS_ID", processID);
wBuilder.AppendTenantCodeSqlClause(typeof(WfProcessCurrentActivity));
StringBuilder strB = new StringBuilder();
strB.AppendFormat("DELETE WF.PROCESS_RELATIVE_PARAMS WHERE {0}",
wBuilder.ToSqlString(TSqlBuilder.Instance));
foreach (WfProcessRelativeParam rp in relativeParams)
{
if (strB.Length > 0)
{
strB.Append(TSqlBuilder.Instance.DBStatementSeperator);
}
strB.Append(ORMapping.GetInsertSql(rp, TSqlBuilder.Instance));
}
DbHelper.RunSqlWithTransaction(strB.ToString(), GetConnectionName());
}
public void Update(WfAclItemCollection aclItems)
{
aclItems.NullCheck("aclItems");
WfAclItemCollection existedAcl = GetAclFromAclResourceIDs(aclItems);
StringBuilder strB = new StringBuilder();
foreach (WfAclItem item in aclItems)
{
if (existedAcl.Exists(a => string.Compare(a.ResourceID, item.ResourceID, true) == 0 && string.Compare(a.ObjectID, item.ObjectID, true) == 0) == false)
{
if (strB.Length > 0)
{
strB.Append(TSqlBuilder.Instance.DBStatementSeperator);
}
strB.Append(ORMapping.GetInsertSql(item, TSqlBuilder.Instance));
}
}
if (strB.Length > 0)
{
DbHelper.RunSqlWithTransaction(strB.ToString(), GetConnectionName());
}
}
/// <summary>
/// 根据已经完成系统任务创建新任务
/// </summary>
/// <param name="taskID">被移动的任务的ID</param>
/// <param name="status">重置任务的状态</param>
public void MoveToNoRunningTask(string taskID)
{
var completedTask = this.Load(taskID);
(completedTask != null).FalseThrow <ArgumentException>("ID为 {0} 的任务不存在", taskID);
PerformanceMonitorHelper.GetDefaultMonitor().WriteExecutionDuration(string.Format("MoveNoRunning({0})", this.GetType().FullName), () =>
{
Dictionary <string, object> context = new Dictionary <string, object>();
ORMappingItemCollection mappingsTask = ORMapping.GetMappingInfo <SysTask>();
var task = completedTask.CreateNewSystask(UuidHelper.NewUuidString());;
StringBuilder sql = new StringBuilder();
sql.Append(ORMapping.GetInsertSql(task, mappingsTask, TSqlBuilder.Instance));
sql.Append(TSqlBuilder.Instance.DBStatementSeperator);
using (TransactionScope scope = TransactionScopeFactory.Create())
{
DbHelper.RunSql(sql.ToString(), this.GetConnectionName());
scope.Complete();
}
});
}
public Int32 InsertPersonBaseFeeDepartmentProjectInfo(PersonBaseFeeDepartmentProjectInfo PersonBaseFeeDepartmentProjectInfo)
{
String sql = ORMapping.GetInsertSql(PersonBaseFeeDepartmentProjectInfo, BuilderEx.TSqlBuilderInstance);
int result = _DataHelper.ExecuteSql(sql);
return(result);
}
private static SCLock Insert(SCLock lockData)
{
StringBuilder sql = new StringBuilder();
sql.Append(ORMapping.GetInsertSql(lockData, TSqlBuilder.Instance));
sql.Append(TSqlBuilder.Instance.DBStatementSeperator);
sql.AppendFormat("SELECT * FROM {0} WHERE LockID = {1}",
GetMappingInfo().TableName,
TSqlBuilder.Instance.CheckUnicodeQuotationMark(lockData.LockID));
SCLock result = null;
try
{
DataTable table = DbHelper.RunSqlReturnDS(sql.ToString(), GetConnectionName()).Tables[0];
result = new SCLock();
ORMapping.DataRowToObject(table.Rows[0], GetMappingInfo(), result);
}
catch (System.Data.SqlClient.SqlException ex)
{
if (ex.Number != 2627)
{
throw;
}
}
return(result);
}
public Int32 InsertPersonInfo(PersonInfo personInfo)
{
String sql = ORMapping.GetInsertSql(personInfo, BuilderEx.TSqlBuilderInstance);
int result = _DataHelper.ExecuteSql(sql);
return(result);
}
private void InsertPostUsers(WfPostUserCollection postUsers)
{
using (TransactionScope scope = TransactionScopeFactory.Create())
{
foreach (WfPostUser postUser in postUsers)
{
string ignoreFields = "UserID";
string sql = ORMapping.GetInsertSql(postUser, TSqlBuilder.Instance, ignoreFields);
try
{
DbHelper.RunSql(sql, GetConnectionName());
}
catch (System.Data.SqlClient.SqlException ex)
{
if (ex.ErrorCode != 2627)
{
throw;
}
}
}
scope.Complete();
}
}
private void Upload(MaterialContent data)
{
data.ContentID = UuidHelper.NewUuidString();
string sql = ORMapping.GetInsertSql(data, TSqlBuilder.Instance);
DbHelper.RunSql(db => db.ExecuteNonQuery(CommandType.Text, sql), "UAT");
}
public Int32 InsertDepartmentInfo(DepartmentInfo departmentInfo)
{
String sql = ORMapping.GetInsertSql(departmentInfo, BuilderEx.TSqlBuilderInstance);
int result = _DataHelper.ExecuteSql(sql);
return(result);
}
/// <summary>
/// 在一个事件下增加频道(UI上用于频道列表)
/// </summary>
/// <param name="eventID"></param>
/// <param name="channelIDs"></param>
/// <returns></returns>
public int AddChannel(string eventID, IEnumerable <string> channelIDs)
{
eventID.CheckStringIsNullOrEmpty("eventID");
channelIDs.NullCheck("channelIDs");
StringBuilder strB = new StringBuilder();
AMSEventChannel eventChannel = new AMSEventChannel();
eventChannel.EventID = eventID;
eventChannel.State = AMSEventState.NotStart;
eventChannel.IsDefault = false;
foreach (string channelID in channelIDs)
{
eventChannel.ChannelID = channelID;
if (strB.Length > 0)
{
strB.Append(TSqlBuilder.Instance.DBStatementSeperator);
}
strB.Append(ORMapping.GetInsertSql(eventChannel, TSqlBuilder.Instance));
}
int result = 0;
if (strB.Length > 0)
{
result = DbHelper.RunSqlWithTransaction(strB.ToString(), this.GetConnectionName());
}
return(result);
}
public Int32 InsertReportPerson(ReportPerson reportPerson)
{
String sql = ORMapping.GetInsertSql(reportPerson, BuilderEx.TSqlBuilderInstance);
int result = _DataHelper.ExecuteSql(sql);
return(result);
}
/// <summary>
/// 添加数据到列表
/// </summary>
/// <param name="List"></param>
/// <returns></returns>
internal int AddMonthlyreportdetailLisr(List <A_TargetPlanDetail> List)
{
StringBuilder sb = new StringBuilder();
int i = 0;
if (List.Count > 0)
{
List.ForEach(p =>
{
sb.Append(ORMapping.GetInsertSql <A_TargetPlanDetail>(p, TSqlBuilder.Instance) + sqlSeperator);
});
if (sb.Length > 0)
{
using (TransactionScope scope = TransactionScopeFactory.Create())
{
i = ExecuteSql(sb.ToString());
scope.Complete();
}
}
return(i);
}
else
{
return(i);
}
}
/// <summary>
/// 批量插入数据
/// </summary>
/// <param name="dataList"></param>
/// <returns></returns>
public int InsertList(List <T> dataList)
{
StringBuilder sqlBuilder = new StringBuilder();
int i = 0;
if (dataList.Count > 0)
{
foreach (T data in dataList)
{
sqlBuilder.Append(ORMapping.GetInsertSql <T>(data, TSqlBuilder.Instance) + sqlSeperator);
if (sqlBuilder.Length > 7000)
{
i += ExecuteSql(sqlBuilder.ToString());
sqlBuilder.Clear();
}
}
if (sqlBuilder.Length > 0)
{
i += ExecuteSql(sqlBuilder.ToString());
}
}
return(i);
}
public void Update(string processID, WfProcessCurrentAssigneeCollection assignees)
{
processID.CheckStringIsNullOrEmpty("processID");
WhereSqlClauseBuilder wBuilder = new WhereSqlClauseBuilder();
wBuilder.AppendItem("PROCESS_ID", processID);
wBuilder.AppendTenantCodeSqlClause(typeof(WfProcessCurrentActivity));
string sqlDelete = string.Format(
"DELETE WF.PROCESS_CURRENT_ASSIGNEES WHERE {0}",
wBuilder.ToSqlString(TSqlBuilder.Instance));
StringBuilder strB = new StringBuilder();
foreach (WfProcessCurrentAssignee assignee in assignees)
{
if (strB.Length > 0)
{
strB.Append(TSqlBuilder.Instance.DBStatementSeperator);
}
strB.Append(ORMapping.GetInsertSql(assignee, TSqlBuilder.Instance));
}
string sql = sqlDelete;
if (strB.Length > 0)
{
sql += TSqlBuilder.Instance.DBStatementSeperator + strB.ToString();
}
DbHelper.RunSqlWithTransaction(sql, GetConnectionName());
}
protected override void AfterInnerUpdate(WfMatrixDefinition data, Dictionary <string, object> context)
{
StringBuilder strB = new StringBuilder();
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
builder.AppendItem("MATRIX_DEF_KEY", data.Key);
builder.AppendTenantCode(typeof(WfMatrixDimensionDefinition));
strB.AppendFormat("{0} {1}",
DELETE_DIMENSION_SQL_CLAUSE,
builder.ToSqlString(TSqlBuilder.Instance));
foreach (WfMatrixDimensionDefinition dd in data.Dimensions)
{
if (strB.Length > 0)
{
strB.Append(TSqlBuilder.Instance.DBStatementSeperator);
}
strB.Append(ORMapping.GetInsertSql(dd, TSqlBuilder.Instance));
}
if (strB.Length > 0)
{
DbHelper.RunSql(strB.ToString(), GetConnectionName());
}
CacheNotifyData notifyData = new CacheNotifyData(typeof(WfMatrixDefinitionCache), CalculateCacheKey(data.Key), CacheNotifyType.Invalid);
UdpCacheNotifier.Instance.SendNotifyAsync(notifyData);
MmfCacheNotifier.Instance.SendNotify(notifyData);
}
public void Insert(SCToDoJob job)
{
job.NullCheck("job");
string sql = ORMapping.GetInsertSql(job, TSqlBuilder.Instance);
DbHelper.RunSql(sql, this.GetConnectionName());
}
public void EncryptSubAmountProperty()
{
ContainerObject data = CreateContainerObject();
string sql = ORMapping.GetInsertSql(data, TSqlBuilder.Instance);
Console.WriteLine(sql);
Assert.AreEqual(-1, sql.IndexOf(data.ToString()));
}
/// <summary>
/// 添加一行数据，并返回新主键
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public int InsertData(UserOperationLog data)
{
ORMappingItemCollection mappings = ORMapping.GetMappingInfo <UserOperationLog>();
string sql = ORMapping.GetInsertSql(data, mappings, TSqlBuilder.Instance);
decimal result = (decimal)DbHelper.RunSqlReturnScalar(string.Format("{0} \n SELECT @@IDENTITY", sql), this.GetConnectionName());
return(decimal.ToInt32(result));
}
public Int32 KelownaPayMonthInfo(String yearMonth)
{
DateTime dt = DateTime.Parse(yearMonth.Insert(4, "-").Insert(7, "-01")).AddMonths(1);
String yearMonthD = String.Concat(dt.Year.ToString(), dt.Month.ToString());
using (TransactionScope scope = TransactionScopeFactory.Create(TransactionScopeOption.Required))
{
StringBuilder sql = new StringBuilder();
WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();
foreach (PersonBaseFeeMonthInfo PersonBaseFeeMonthInfo in PersonBaseFeeInfoAdapter.Instance.GetPersonBaseFeeInfoList(PersonBaseFeeTarget.PersonBaseFeeMonth, yearMonth))
{
PersonBaseFeeMonthInfo.YearMonth = yearMonthD;
sql.Append(ORMapping.GetInsertSql(PersonBaseFeeMonthInfo, BuilderEx.TSqlBuilderInstance));
sql.Append(";");
}
//工资月表
builder.AppendItem(PayMonthInfoDBConst.YearMonth, yearMonth);
foreach (PayMonthInfo PayMonthInfo in PayMonthInfoAdapter.Instance.GetPayMonthInfoList(builder))
{
PayMonthInfo.YearMonth = yearMonthD;
sql.Append(ORMapping.GetInsertSql(PayMonthInfo, BuilderEx.TSqlBuilderInstance));
sql.Append(";");
}
//人员基本工资项目部门分摊月表
builder.Clear();
builder.AppendItem(PersonBaseFeeDepartmentProjectMonthInfoDBConst.YearMonth, yearMonth);
foreach (PersonBaseFeeDepartmentProjectMonthInfo personFeeDepartmentProjectMonthInfo in PersonBaseFeeDepartmentProjectInfoAdapter.Instance.GetPersonBaseFeeDepartmentProjectInfoList(yearMonth, builder))
{
personFeeDepartmentProjectMonthInfo.YearMonth = yearMonthD;
sql.Append(ORMapping.GetInsertSql(personFeeDepartmentProjectMonthInfo, BuilderEx.TSqlBuilderInstance));
sql.Append(";");
}
//工资项目月表
builder.Clear();
builder.AppendItem(FeeMonthInfoDBConst.YearMonth, yearMonth);
foreach (FeeMonthInfo feeMonthInfo in FeeInfoAdapter.Instance.GetFeeInfoList(yearMonth, builder))
{
feeMonthInfo.YearMonth = yearMonthD;
sql.Append(ORMapping.GetInsertSql(feeMonthInfo, BuilderEx.TSqlBuilderInstance));
sql.Append(";");
}
//税率月表
builder.Clear();
builder.AppendItem(TaxMonthInfoDBConst.YearMonth, yearMonth);
foreach (TaxMonthInfo taxMonthInfo in TaxInfoAdapter.Instance.GetTaxInfoList(yearMonth, builder))
{
taxMonthInfo.YearMonth = yearMonthD;
sql.Append(ORMapping.GetInsertSql(taxMonthInfo, BuilderEx.TSqlBuilderInstance));
sql.Append(";");
}
int result = _DataHelper.ExecuteSql(sql.ToString());
scope.Complete();
return(result);
}
}
public void Insert(UploadFileHistory history)
{
ExceptionHelper.FalseThrow <ArgumentNullException>(history != null, "history");
string sql = ORMapping.GetInsertSql(history, TSqlBuilder.Instance) + TSqlBuilder.Instance.DBStatementSeperator +
"SELECT SCOPE_IDENTITY()";
decimal identity = (decimal)DbHelper.RunSqlReturnScalar(sql, AppLogSettings.GetConfig().ConnectionName);
history.ID = Decimal.ToInt32(identity);
}
public int AddOperationTasksLogs(UserOperationTasksLogCollection userTaskslogs)
{
StringBuilder sqlStrB = new StringBuilder();
ORMappingItemCollection mappings = ORMapping.GetMappingInfo <UserOperationTasksLog>();
foreach (UserOperationTasksLog data in userTaskslogs)
{
sqlStrB.AppendFormat("{0} ; \n", ORMapping.GetInsertSql(data, mappings, TSqlBuilder.Instance));
}
return(DbHelper.RunSql(sqlStrB.ToString(), this.GetConnectionName()));
}
protected override string GetInsertSql(AMSEvent data, ORMappingItemCollection mappings, Dictionary <string, object> context)
{
StringBuilder strB = new StringBuilder();
strB.Append(base.GetInsertSql(data, mappings, context));
strB.Append(TSqlBuilder.Instance.DBStatementSeperator);
AMSEventChannel eventChannel = AMSEventChannel.FromAMSEvent(data);
strB.Append(ORMapping.GetInsertSql(eventChannel, TSqlBuilder.Instance));
return(strB.ToString());
}
public Int32 InsertFeeInfo(FeeInfo feeInfo)
{
using (TransactionScope scope = TransactionScopeFactory.Create(TransactionScopeOption.Required))
{
String sql = ORMapping.GetInsertSql(feeInfo, BuilderEx.TSqlBuilderInstance);
int result = _DataHelper.ExecuteSql(sql);
if (!String.IsNullOrEmpty(feeInfo.ParentID))
{
this.UpdateCalculateExp((feeInfo is FeeMonthInfo) ? ((FeeMonthInfo)feeInfo).YearMonth : null, feeInfo.ParentID);
}
scope.Complete();
return(result);
}
}
/// <summary>
/// 创建一个实体对象的Insert语句
/// </summary>
/// <typeparam name="T">对象类型</typeparam>
/// <param name="data">传入的对象</param>
/// <param name="mappingType">映射类型</param>
/// <param name="isFilterByT">是否按类型进行映射过滤</param>
/// <returns>Insert语句</returns>
public static string GetInsertSql <T>(T data, Type mappingType, bool isFilterByT)
{
//获取映射关系集合
ORMappingItemCollection mappings = ORMapping.GetMappingInfo(mappingType);
//过滤
if (isFilterByT)
{
mappings = mappings.FilterMappingInfoByDeclaringType(mappingType);
}
return(String.Format("{0} {1} ",
ORMapping.GetInsertSql(data, mappings, TSqlBuilder.Instance),
TSqlBuilder.Instance.DBStatementSeperator));
}
/// <summary>
/// 移动到已经完成系统任务中
/// </summary>
/// <param name="taskID">被移动的任务的ID</param>
/// <param name="status">重置任务的状态</param>
public SysAccomplishedTask MoveToCompletedSysTask(SysTask task, SysTaskStatus status, string statusText)
{
SysAccomplishedTask result = null;
PerformanceMonitorHelper.GetDefaultMonitor().WriteExecutionDuration(string.Format("MoveToAccomplished({0})", this.GetType().FullName), () =>
{
Dictionary <string, object> context = new Dictionary <string, object>();
ORMappingItemCollection mappings = GetMappingInfo(context);
WhereSqlClauseBuilder builder = ORMapping.GetWhereSqlClauseBuilderByPrimaryKey(task, mappings);
ORMappingItemCollection mappingsCompleted = ORMapping.GetMappingInfo <SysAccomplishedTask>();
SysAccomplishedTask taskCompleted = new SysAccomplishedTask(task);
taskCompleted.Status = status;
taskCompleted.StatusText = statusText;
StringBuilder sql = new StringBuilder();
sql.AppendFormat("DELETE FROM {0} WHERE {1}", mappingsCompleted.TableName, builder.ToSqlString(TSqlBuilder.Instance));
sql.Append(TSqlBuilder.Instance.DBStatementSeperator);
sql.Append(GetMoveSysTaskSql(taskCompleted, context));
sql.Append(TSqlBuilder.Instance.DBStatementSeperator);
sql.Append("IF @@ROWCOUNT = 0");
sql.Append(TSqlBuilder.Instance.DBStatementSeperator);
sql.Append("\t" + ORMapping.GetInsertSql(taskCompleted, mappingsCompleted, TSqlBuilder.Instance));
sql.Append(TSqlBuilder.Instance.DBStatementSeperator);
sql.AppendFormat("DELETE FROM {0} WHERE {1}", mappings.TableName, builder.ToSqlString(TSqlBuilder.Instance));
using (TransactionScope scope = TransactionScopeFactory.Create())
{
DbHelper.RunSql(sql.ToString(), this.GetConnectionName());
scope.Complete();
}
result = taskCompleted;
});
return(result);
}
public void Insert(SCOperationLog log)
{
if (log != null)
{
log.CreateTime = SCActionContext.Current.TimePoint;
StringBuilder strB = new StringBuilder(256);
strB.Append(ORMapping.GetInsertSql(log, this.GetMappingInfo(), TSqlBuilder.Instance));
strB.Append(TSqlBuilder.Instance.DBStatementSeperator);
strB.Append("SELECT SCOPE_IDENTITY()");
Decimal newID = (Decimal)DbHelper.RunSqlReturnScalar(strB.ToString(), this.GetConnectionName());
log.ID = Decimal.ToInt32(newID);
}
}
public void BulkAdd(InvalidAssignessUrlCollection data)
{
ORMappingItemCollection mappings = ORMapping.GetMappingInfo <InvalidAssigneeUrl>();
StringBuilder sqlStrB = new StringBuilder();
foreach (InvalidAssigneeUrl item in data)
{
if (sqlStrB.Length > 0)
{
sqlStrB.Append(TSqlBuilder.Instance.DBStatementSeperator);
}
sqlStrB.Append(ORMapping.GetInsertSql(item, mappings, TSqlBuilder.Instance));
}
DbHelper.RunSqlWithTransaction(sqlStrB.ToString(), this.GetConnectionName());
}
public void Update(CommonInfoMappingCollection cimItems)
{
cimItems.NullCheck("cimItems");
string sqlString = string.Empty;
StringBuilder strB = new StringBuilder();
ConnectiveSqlClauseCollection connective = new ConnectiveSqlClauseCollection(LogicOperatorDefine.Or);
foreach (CommonInfoMapping cim in cimItems)
{
if (cim.ResourceID.IsNotEmpty() && cim.ProcessID.IsNotEmpty())
{
if (strB.Length > 0)
{
strB.Append(TSqlBuilder.Instance.DBStatementSeperator);
}
WhereSqlClauseBuilder wBuilder = new WhereSqlClauseBuilder();
wBuilder.AppendItem("RESOURCE_ID", cim.ResourceID);
wBuilder.AppendItem("PROCESS_ID", cim.ProcessID);
wBuilder.AppendTenantCode(typeof(CommonInfoMapping));
connective.Add(wBuilder);
strB.Append(TSqlBuilder.Instance.DBStatementSeperator);
strB.Append(ORMapping.GetInsertSql(cim, TSqlBuilder.Instance));
}
}
if (connective.Count > 0)
{
sqlString = string.Format("DELETE WF.COMMON_INFO_MAPPING WHERE {0}", connective.ToSqlString(TSqlBuilder.Instance));
sqlString += strB.ToString();
}
if (sqlString.Length > 0)
{
DbHelper.RunSqlWithTransaction(sqlString, WorkflowSettings.GetConfig().ConnectionName);
}
}
public void Insert(DemoOrderCollection orders)
{
StringBuilder strBuilder = new StringBuilder();
orders.ForEach(p =>
{
if (strBuilder.Length > 0)
{
strBuilder.Append(TSqlBuilder.Instance.DBStatementSeperator);
}
strBuilder.Append(ORMapping.GetInsertSql(p, TSqlBuilder.Instance));
});
if (strBuilder.Length > 0)
{
DbHelper.RunSqlWithTransaction(strBuilder.ToString(), DB_CONNECTION);
}
}
