/// <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); } }