public OperationResult <bool> UserRemind_Insert(UserRemindEntity entity) { SqlTransaction trans = null; try { string sql = string.Empty; sql += " INSERT INTO M_User_Remind(UserID,RemindTypeID,Data,UpdateTime) "; sql += " VALUES(@UserID,@RemindTypeID,@Data,@UpdateTime) "; SqlParameter[] prms = { new SqlParameter("@UserID", SqlDbType.Int), new SqlParameter("@RemindTypeID", SqlDbType.Int), new SqlParameter("@Data", SqlDbType.NVarChar,128), new SqlParameter("@UpdateTime", SqlDbType.DateTime), }; prms[0].Value = entity.UserID; prms[1].Value = entity.RemindTypeID; prms[2].Value = entity.Data; prms[3].Value = DateTime.Now; using (SqlConnection conn = new SqlConnection(SQlHelper.MyConnectStr)) { conn.Open(); trans = conn.BeginTransaction(); SQlHelper.ExecuteScalar(trans, CommandType.Text, sql, prms); trans.Commit(); } return(new OperationResult <bool>(OperationResultType.Success, "数据加入成功!", true)); } catch (Exception ex) { try { if (trans != null) { trans.Rollback(); } } catch { } return(new OperationResult <bool>(OperationResultType.Error, "异常结果:" + ex.Message, false)); } }
void LoadUseRemindComplete(object sender, EventArgs e) { UserRemindEntityDicationary.Clear(); LoadOperation loadOperation = sender as LoadOperation; foreach (user_remind user_remind in loadOperation.Entities) { UserRemindEntity lUserRemindEntity = new UserRemindEntity(); lUserRemindEntity.UserRemind = user_remind; lUserRemindEntity.Update(); UserRemindEntityDicationary.Add(lUserRemindEntity.ManufactureNumber, lUserRemindEntity); } LoadOperation <ProductManager.Web.Model.project> LoadOperationProject = productDomainContext.Load <ProductManager.Web.Model.project>(productDomainContext.GetProjectQuery()); LoadOperationProject.Completed += loadOperationProject_Completed; }