/// <summary> /// 增加一条数据 /// </summary> public int Add(DataTypeEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tbDataType("); strSql.Append("DataType,DataTypeName,Sort,CreateBy,CreateTime,UpdateBy,UpdateTime"); strSql.Append(") values ("); strSql.Append("@DataType,@DataTypeName,@Sort,@CreateBy,@CreateTime,@UpdateBy,@UpdateTime"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@DataTypeName", SqlDbType.NVarChar, 50), new SqlParameter("@CreateBy", SqlDbType.NVarChar, 50), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@UpdateBy", SqlDbType.NVarChar, 50), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@Sort", SqlDbType.Int), new SqlParameter("@DataType", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.DataTypeName; parameters[1].Value = model.CreateBy; parameters[2].Value = model.CreateTime; parameters[3].Value = model.UpdateBy; parameters[4].Value = model.UpdateTime; parameters[5].Value = model.Sort; parameters[6].Value = model.DataType; object obj = Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.connStr, CommandType.Text, strSql.ToString(), parameters)); return(Convert.ToInt32(obj)); }
/// <summary> /// 获得数据列表 /// </summary> public List <DataTypeEntity> DataTableToList(DataTable dt) { List <DataTypeEntity> modelList = new List <DataTypeEntity>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { DataTypeEntity model; for (int n = 0; n < rowsCount; n++) { model = new DataTypeEntity(); if (dt.Rows[n]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[n]["id"].ToString()); } model.DataType = dt.Rows[n]["DataType"].ToString(); model.DataTypeName = dt.Rows[n]["DataTypeName"].ToString(); model.Sort = int.Parse(dt.Rows[n]["Sort"].ToString()); model.CreateBy = dt.Rows[n]["CreateBy"].ToString(); if (dt.Rows[n]["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(dt.Rows[n]["CreateTime"].ToString()); } model.UpdateBy = dt.Rows[n]["UpdateBy"].ToString(); if (dt.Rows[n]["UpdateTime"].ToString() != "") { model.UpdateTime = DateTime.Parse(dt.Rows[n]["UpdateTime"].ToString()); } modelList.Add(model); } } return(modelList); }
public void UpdateActions(int projectId, List <SlaveAction> actions, string userId) { var project = _unitOfWork.ProjectRepository.GetById(projectId); if (project.UserId != userId) { throw new AccessDeniedException(); } foreach (var action in actions) { SlaveActionEntity slaveActionEntity = null; if (action.Id == 0) { slaveActionEntity = Mapper.Map <SlaveAction, SlaveActionEntity>(action); slaveActionEntity.ProjectId = projectId; _unitOfWork.SlaveActionRepository.Insert(slaveActionEntity); } else { slaveActionEntity = _unitOfWork.SlaveActionRepository.GetById(action.Id); slaveActionEntity.NumberOfRegisters = action.NumberOfRegisters; slaveActionEntity.ProjectId = projectId; slaveActionEntity.SlaveAddress = action.SlaveAddress; slaveActionEntity.StartAddress = action.StartAddress; slaveActionEntity.Formula = action.Formula; slaveActionEntity.ActionType = action.ActionType; _unitOfWork.SlaveActionRepository.Update(slaveActionEntity); var dataTypes = _unitOfWork.DataTypesRepository.Get(x => x.SlaveActionEntityId == slaveActionEntity.Id); foreach (var dataType in dataTypes) { _unitOfWork.DataTypesRepository.Delete(dataType.Id); } } _unitOfWork.Save(); foreach (var dataType in action.Types) { var dataTypeEntity = new DataTypeEntity() { SlaveActionEntityId = slaveActionEntity.Id, Type = dataType }; _unitOfWork.DataTypesRepository.Insert(dataTypeEntity); } } _unitOfWork.Save(); }
/// <summary> /// Creates a DataType /// </summary> /// <param name="DataTypeEntity"></param> /// <returns></returns> public int CreateDataType(DataTypeEntity DataTypeEntity) { using (var scope = new TransactionScope()) { var DataType = new DataType { DataTypeName = DataTypeEntity.DataTypeName }; _unitOfWork.DataTypeRepository.Insert(DataType); _unitOfWork.Save(); scope.Complete(); return(DataType.DataTypeId); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DataTypeEntity GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id, DataType,DataTypeName, Sort, CreateTime,CreateBy,UpdateTime,UpdateBy "); strSql.Append(" from tbDataType "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; DataTypeEntity model = new DataTypeEntity(); DataTable dt = SqlHelper.GetDataTable(SqlHelper.connStr, CommandType.Text, strSql.ToString(), parameters); if (dt.Rows.Count > 0) { if (dt.Rows[0]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[0]["id"].ToString()); } model.DataType = dt.Rows[0]["DataType"].ToString(); model.DataTypeName = dt.Rows[0]["DataTypeName"].ToString(); if (dt.Rows[0]["Sort"].ToString() != "") { model.Sort = int.Parse(dt.Rows[0]["Sort"].ToString()); } model.CreateBy = dt.Rows[0]["CreateBy"].ToString(); if (dt.Rows[0]["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(dt.Rows[0]["CreateTime"].ToString()); } model.UpdateBy = dt.Rows[0]["UpdateBy"].ToString(); if (dt.Rows[0]["UpdateTime"].ToString() != "") { model.UpdateTime = DateTime.Parse(dt.Rows[0]["UpdateTime"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// Updates a DataType /// </summary> /// <param name="DataTypeId"></param> /// <param name="DataTypeEntity"></param> /// <returns></returns> public bool UpdateDataType(int DataTypeId, DataTypeEntity DataTypeEntity) { var success = false; if (DataTypeEntity != null) { using (var scope = new TransactionScope()) { var DataType = _unitOfWork.DataTypeRepository.GetByID(DataTypeId); if (DataType != null) { DataType.DataTypeName = DataTypeEntity.DataTypeName; _unitOfWork.DataTypeRepository.Update(DataType); _unitOfWork.Save(); scope.Complete(); success = true; } } } return(success); }
/// <summary> /// 更新数据 /// </summary> public async Task <DataTypeDto> Update(DataTypeInputDto input) { try { DataTypeEntity entity = new DataTypeEntity { Id = input.Id, TypeName = input.TypeName, TypeDesc = input.TypeDesc, DictCodeID = input.DictCodeID, ParentID = input.ParentID }; var query = await _IDataTypeRepository.UpdateAsync(entity); var result = entity.MapTo <DataTypeDto>(); return(result); } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// 更新一条数据 /// </summary> public int Update(DataTypeEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tbDataType set "); strSql.Append(" DataType = @DataType , "); strSql.Append(" DataTypeName = @DataTypeName , "); strSql.Append(" Sort = @Sort , "); strSql.Append(" CreateBy = @CreateBy , "); strSql.Append(" CreateTime = @CreateTime , "); strSql.Append(" UpdateBy = @UpdateBy , "); strSql.Append(" UpdateTime = @UpdateTime "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@DataTypeName", SqlDbType.NVarChar, 50), new SqlParameter("@CreateBy", SqlDbType.NVarChar, 50), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@UpdateBy", SqlDbType.NVarChar, 50), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@Sort", SqlDbType.Int), new SqlParameter("@DataType", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.id; parameters[1].Value = model.DataTypeName; parameters[2].Value = model.CreateBy; parameters[3].Value = model.CreateTime; parameters[4].Value = model.UpdateBy; parameters[5].Value = model.UpdateTime; parameters[6].Value = model.Sort; parameters[7].Value = model.DataType; object obj = SqlHelper.ExecuteNonQuery(SqlHelper.connStr, CommandType.Text, strSql.ToString(), parameters); return(Convert.ToInt32(obj)); }
/// <summary> /// 新增 /// </summary> /// <returns></returns> public ActionResult AddDataType() { try { UserEntity uInfo = ViewData["Account"] as UserEntity; DataTypeEntity typeAdd = new DataTypeEntity(); typeAdd.DataType = Request["DataType"]; typeAdd.DataTypeName = Request["DataTypeName"]; typeAdd.Sort = int.Parse(Request["Sort"] == null ? "0" : Request["Sort"]); typeAdd.CreateBy = uInfo.AccountName; typeAdd.CreateTime = DateTime.Now; typeAdd.UpdateBy = uInfo.AccountName; typeAdd.UpdateTime = DateTime.Now; bool exists = new DataTypeBLL().Exists(typeAdd.DataTypeName); if (exists) { return(Content("{\"msg\":\"添加失败,类型名称已存在!\",\"success\":false}")); } else { int typeId = new DataTypeBLL().Add(typeAdd); if (typeId > 0) { return(Content("{\"msg\":\"添加成功!\",\"success\":true}")); } else { return(Content("{\"msg\":\"添加失败!\",\"success\":false}")); } } } catch (Exception ex) { return(Content("{\"msg\":\"添加失败," + ex.Message + "\",\"success\":false}")); } }
/// <summary> /// 更新一条数据 /// </summary> public int Update(DataTypeEntity model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DataTypeEntity model) { return(dal.Add(model)); }
public void Update(DataTypeEntity item) { _data.RemoveAll(entity => entity.Id == item.Id); _data.Add(item); }
public void Create(DataTypeEntity item) { _data.Add(item); }