public Model.Type GetTypeById(int Id) { Model.Type typ = new Model.Type(); string sql = @"[spGetType] '{0}' "; sql = string.Format(sql, Id); try { DataSet ds = new DataSet(); ds = _MB.CreaDS(ds, "Type", sql, _CN); if (ds.Tables["Type"].Rows.Count > 0) { foreach (DataRow item in ds.Tables["Type"].Rows) { typ = new Model.Type() { Id = int.Parse(item["Id"].ToString()), Description = item["Description"].ToString(), Group = new Group() { Id = int.Parse(item["IdGroup"].ToString()), Description = item["DescripGroup"].ToString() }, }; } } return(typ); } catch (Exception) { throw; } }
protected void Add_Click(object sender, EventArgs e) { Model.Type type = new Model.Type(); type.Language = 0; type.Name = this.tbName.Text.Trim(); type.Order = Int32.Parse(this.tbOrder.Text); TypeManager.Add(type); this.GridView1.DataBind(); }
public int InsertType(Model.Type pType) { try { return(_AD.InsertType(pType)); } catch (Exception ex) { throw; } }
public bool UpdateType(Model.Type pType) { try { _AD.UpdateType(pType); return(true); } catch (Exception ex) { throw; } }
/// <summary> /// 删除商品 /// </summary> /// <param name="ty"></param> /// <returns></returns> public ActionResult DeleProductManager(Model.Type ty) { bool i = ts.Delete(ty); if (i) { return(Content(Ts("删除成功", "../Frontdesk/ProductManager"))); } else { return(Content(Ts("删除失败", "../Frontdesk/ProductManager"))); } }
/// <summary> /// 修改商品类型 /// </summary> /// <param name="ty"></param> /// <returns></returns> public ActionResult UpdateProductManager(Model.Type ty) { bool i = ts.Update(ty); if (i) { return(Content(Ts("修改成功", "../Frontdesk/ProductManager"))); } else { return(Content(Ts("修改失败", "../Frontdesk/ProductManager"))); } }
/// <summary> /// 添加商品类型 /// </summary> /// <param name="ty"></param> /// <returns></returns> public ActionResult AddProductManager(Model.Type ty) { bool i = ts.Add(ty); if (i) { return(Content(Ts("添加成功", "../Frontdesk/ProductManager"))); } else { return(Content(Ts("添加失败", "../Frontdesk/ProductManager"))); } }
public void UpdateType(Model.Type pType) { string sql = @"[spUpdateType] '{0}', '{1}', '{2}'"; sql = string.Format(sql, pType.Id, pType.Description, pType.Group.Id); try { _MB.EjecutarSQL(_CN, sql); } catch (Exception err) { throw err; } }
public int InsertType(Model.Type pType) { string sql = @"[spInsertType] '{0}', '{1}'"; sql = string.Format(sql, pType.Description, pType.Group.Id); try { return(_MB.EjecutarSQL(_CN, sql)); } catch (Exception err) { throw err; } }
public static IList<Model.Type> GetAll(int language) { IList<Model.Type> types = new List<Model.Type>(); string sql = "select LType" + language.ToString() + ".*,tblMenuType.OrderId from LType" + language.ToString() + " INNER JOIN tblMenuType ON tblMenuType.id=LType" + language.ToString() +".id"; using (SqlDataReader sdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.Text, sql)) { while (sdr.Read()) { Model.Type type = new Model.Type(); type.Id = (int)sdr["id"]; type.Name = (string)sdr["name"]; type.Order = (int)sdr["orderid"]; type.Language = language; types.Add(type); } } return types; }
/// <summary> /// 类型查询及所有商品,根据ID查询相应父类下的商品信息 /// </summary> /// <returns></returns> public ActionResult product(Model.Type t) { List <Model.Type> lt = ts.select(); ViewBag.Lx = lt; int id = t.TypeID; if (id == 0) { List <Goods> lg = gs.select(); ViewData.Model = lg; } else { List <Goods> lg = gs.SelectBys(id); ViewData.Model = lg; } return(View()); }
public static Model.Type GetTypeById(int id,int language) { string sql = @"select LType" + language.ToString() + ".*,tblMenuType.OrderId from LType" + language.ToString() + " INNER JOIN tblMenuType ON tblMenuType.id=LType" + language.ToString() + ".id where tblMenuType.id =" + id.ToString(); Model.Type type = new Model.Type(); using (SqlDataReader sdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.Text, sql)) { if (sdr.Read()) { type.Id = id; type.Name = (string)sdr["name"]; type.Order = (int)sdr["orderid"]; type.Language = language; } else type = null; } return type; }
public List <Computer> Computers(Model.Type type) { return(computers.Where(x => x.Type.ID == type.ID).ToList()); }