public ActionResult Update(ItemclassInfo itemclassInfo) { try { itemclassInfo.UpdatedBy = CurrentUserInfo.UserName; itemclassInfo.UpdatedDate = DateTime.Now; IItemclassService itemclassService = UnityHelper.UnityResolve <IItemclassService>(); var data = itemclassService.UpdateItemclass(itemclassInfo); LogHelper.LogOperation(CurrentUserInfo.UserCode, string.Format("Update ItemclassInfo {0},{1}", LogHelper.ChangeEntityToLog(itemclassInfo), data)); if (data > 0) { return(Content("OK")); } else { return(Content("Failed")); } } catch (BusinessException bex) { return(Content(bex.Message)); } catch (Exception ex) { LogHelper.LogError(ex, ""); return(Content(ex.Message)); } }
/// <summary> /// 设置SQL参数表 /// </summary> /// <param name="Itemclass">Itemclass对象</param> /// <returns>Itemclass参数数组</returns> private SqlParameter[] Set_Itemclass_Parameters(ItemclassInfo itemclassInfo) { SqlParameter[] paramArray = new SqlParameter[] { new SqlParameter("@ClassID", itemclassInfo.ClassID), new SqlParameter("@ClassName", itemclassInfo.ClassName), new SqlParameter("@IsActive", itemclassInfo.IsActive), new SqlParameter("@CreatedBy", string.IsNullOrEmpty(itemclassInfo.CreatedBy)?"":itemclassInfo.CreatedBy), new SqlParameter("@UpdatedBy", string.IsNullOrEmpty(itemclassInfo.UpdatedBy)?"":itemclassInfo.UpdatedBy) }; return(paramArray); }
public ActionResult Edit(ItemclassInfo itemclassInfo) { if (itemclassInfo.ClassID == 0) { return(Insert(itemclassInfo)); } else { return(Update(itemclassInfo)); } }
/// <summary> /// 更新一条Itemclass记录 /// </summary> /// <param name="db">DataBase对象</param> /// <param name="tran">一个有效的DbTransaction</param> /// <param name="itemclass">Itemclass对象</param> /// <param name="whLoginID">要查询的仓库的前缀</param> /// <returns>执行更新对数据库影响的行数</returns> public int UpdateItemclass(Database db, DbTransaction tran, ItemclassInfo itemclassInfo) { int result = 0; SqlParameter[] paras = Set_Itemclass_Parameters(itemclassInfo); if (paras != null) { result += DBHelper.ExecuteNonQuery(db, tran, CommandType.Text, SQL_UPDATE_ITEMCLASS, paras); } return(result); }
/// <summary> /// 新增一条Itemclass记录 /// </summary> /// <param name="itemclass">Itemclass对象</param> /// <param name="whLoginID">要查询的仓库的前缀</param> /// <returns>执行新增对数据库影响的行数</returns> public int InsertItemclass(ItemclassInfo itemclassInfo) { int result = 0; SqlParameter[] paras = Set_Itemclass_Parameters(itemclassInfo); if (paras != null) { result = DBHelper.ExecuteNonQuery(CommandType.Text, SQL_INSERT_ITEMCLASS, paras); } return(result); }
/// <summary> /// 初始化ItemclassInfo /// </summary> private ItemclassInfo InitItemclassInfoByDataReader(ItemclassInfo itemclassInfo, IDataReader reader) { itemclassInfo = new ItemclassInfo(reader["ClassID"].ToString() != "" ? Int32.Parse(reader["ClassID"].ToString()) : 0, reader["ClassName"].ToString(), reader["IsActive"].ToString(), reader["CreatedBy"].ToString(), reader["CreatedDate"].ToString() != "" ? DateTime.Parse(reader["CreatedDate"].ToString()) : new DateTime(), reader["UpdatedBy"].ToString(), reader["UpdatedDate"].ToString() != "" ? DateTime.Parse(reader["UpdatedDate"].ToString()) : new DateTime()); return(itemclassInfo); }
/// <summary> /// 根据itemclassID得到一条Itemclass记录 /// </summary> /// <param name="itemclassID">itemclassID</param> /// <param name="whLoginID">要查询的仓库的前缀</param> /// <returns>根据itemclassID得到一条Itemclass记录</returns> public ItemclassInfo GetItemclassByID(string itemclassID) { string sql = SQL_SELECT_ALL_ITEMCLASS + " AND CLASSID = @CLASSID "; SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@CLASSID", itemclassID) }; ItemclassInfo itemclassInfo = null; using (IDataReader reader = DBHelper.ExecuteReader(CommandType.Text, sql, paras)) { if (reader.Read()) { itemclassInfo = InitItemclassInfoByDataReader(itemclassInfo, reader); } } return(itemclassInfo); }
/// <summary> /// 根据itemclassID得到一条Itemclass记录 /// </summary> /// <param name="db">DataBase对象</param> /// <param name="tran">一个有效的DbTransaction</param> /// <param name="itemclassID">itemclassID</param> /// <param name="whLoginID">要查询的仓库的前缀</param> /// <returns>根据itemclassID得到一条Itemclass记录</returns> public ItemclassInfo GetItemclassByID(Database db, DbTransaction tran, string itemclassID) { string sql = SQL_SELECT_ALL_ITEMCLASS + " AND CLASSID = @CLASSID "; SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@CLASSID", itemclassID) }; ItemclassInfo itemclassInfo = null; IDataReader reader = DBHelper.ExecuteReader(db, tran, CommandType.Text, sql, paras); if (reader.Read()) { itemclassInfo = InitItemclassInfoByDataReader(itemclassInfo, reader); } if (!reader.IsClosed) { reader.Close(); } return(itemclassInfo); }
/// <summary> /// 新增一条Itemclass记录 /// </summary> /// <param name="itemclass">Itemclass对象</param> /// <param name="whLoginID">要查询的仓库的前缀</param> /// <returns>执行新增对数据库影响的行数</returns> public int InsertItemclass(ItemclassInfo itemclassInfo) { return(itemclassDA.InsertItemclass(itemclassInfo)); }
/// <summary> /// 更新一条Itemclass记录 /// </summary> /// <param name="itemclass">Itemclass对象</param> /// <param name="whLoginID">要查询的仓库的前缀</param> /// <returns>执行更新对数据库影响的行数</returns> public int UpdateItemclass(ItemclassInfo itemclassInfo) { return(itemclassDA.UpdateItemclass(itemclassInfo)); }