/// <summary> /// 更新 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int Update(ProductPropInfo model) { string strSQL = "UPDATE ProductProps SET Name = @Name WHERE Id = @Id"; SqlParameter[] parms = { new SqlParameter("Id",SqlDbType.Int), new SqlParameter("Name",SqlDbType.NVarChar), }; parms[0].Value = model.Id; parms[1].Value = model.Name.Replace('"', '”'); ; return SQLPlus.ExecuteNonQuery(CommandType.Text,strSQL,parms); }
/// <summary> /// 添加或编辑 /// </summary> /// <param name="model"></param> /// <returns></returns> public static ProductPropInfo Create(ProductPropInfo model) { if (string.IsNullOrEmpty(model.Name)) { return model; } if (model.Id == 0) { model.Id = ProductPropManage.Insert(model); } else { ProductPropManage.Update(model); } return model; }
/// <summary> /// 添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int Insert(ProductPropInfo model) { string strSQL = "INSERT INTO ProductProps(CategoryId,Name,IsDeleted) VALUES(@CategoryId,@Name,0);SELECT @@IDENTITY;"; SqlParameter[] parms = { new SqlParameter("Id",SqlDbType.Int), new SqlParameter("CategoryId",SqlDbType.Int), new SqlParameter("Name",SqlDbType.NVarChar), }; parms[0].Value = model.Id; parms[1].Value = model.CategoryId; parms[2].Value = model.Name.Replace('"', '”'); ; return Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text,strSQL,parms)); }