示例#1
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public Craft DataRowToModel(DataRow row)
 {
     Craft model=new Craft();
     if (row != null)
     {
         foreach (DataColumn col in row.Table.Columns)
         {
             if (row[col] != null && row[col].ToString() != "")
             {
                 switch (col.ColumnName)
                 {
                     case "id":
                         model.CraftID = int.Parse(row[col].ToString());
                         break;
                     case "name":
                         model.Name = row[col].ToString();
                         break;
                     case "price":
                         model.Price = decimal.Parse(row[col].ToString());
                         break;
                     case "intro":
                         model.Intro = row[col].ToString();
                         break;
                 }
             }
         }
     }
     return model;
 }
示例#2
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(Craft model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into craft(");
            strSql.Append("name,price,intro)");
            strSql.Append(" values (");
            strSql.Append("?name,?price,?intro)");
            MySqlParameter[] parameters = {
                    new MySqlParameter("?name", MySqlDbType.VarChar,50),
                    new MySqlParameter("?price", MySqlDbType.Decimal,12),
                    new MySqlParameter("?intro", MySqlDbType.Text)};
            parameters[0].Value = model.Name;
            parameters[1].Value = model.Price;
            parameters[2].Value = model.Intro;

            int rows=MysqlHelper.ExecuteNonQuery(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
示例#3
0
 public JsonResult AddFabric()
 {
     string strCraft = Request["craft"];
     string strStyle = Request["style"];
     string strCount = Request["count"];
     string strID = Request["materialid"];
     int id = 0;
     int count = 0;
     int carftID = 0;
     int styleID = 0;
     int.TryParse(strCraft,out carftID);
     int.TryParse(strStyle,out styleID);
     int.TryParse(strCount, out count);
     int.TryParse(strID, out id);
     JsonResult json = new JsonResult();
     json.Data = new { flag = 0 };
     if (count > 0 && carftID > 0 && styleID > 0&&id>0)
     {
         DetailItem item = new DetailItem();
         item.Craft = carftID;
         item.Style=styleID;
         item.Type=CategoryType.Fabric;
         item.MaterialID=id;
         Material model = new Material();
         MaterialOperation mop = new MaterialOperation();
         model = mop.GetModel(id);
         Craft craftModel = new Craft();
         CraftOperation craftOperation = new CraftOperation();
         craftModel = craftOperation.GetModel(carftID);
         item.Count = count;
         if (model != null)
         {
             item.StylePrice = craftModel.Price;
             switch (styleID)
             {
                 case 1:
                     item.Price = model.Price ;
                     break;
                 case 2:
                     item.Price = model.PriceHigh;
                     break;
                 case 3:
                     item.Price = model.PriceFancy;
                     break;
             }
             if (item.Price > 0)
             {
                 MyCart.Add(item);
                 json.Data = new { flag = 1,count=MyCart.Orders.Count,total=MyCart.TotalPrice };
             }
         }
     }
     json.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
     json.ContentEncoding = System.Text.Encoding.UTF8;
     return json;
 }
示例#4
0
 public JsonResult AjaxModel(int id)
 {
     JsonResult json = new JsonResult();
     if (id > 0)
     {
         Craft model = new Craft();
         CraftOperation cop = new CraftOperation();
         model = cop.GetModel(id);
         if (model != null)
         {
             json.Data = model;
             json.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
             json.ContentEncoding = System.Text.Encoding.UTF8;
         }
     }
     return json;
 }
示例#5
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Craft model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("update craft set ");
            strSql.Append("name=?name,");
            strSql.Append("price=?price,");
            strSql.Append("intro=?intro");
            strSql.Append(" where id=?id");
            MySqlParameter[] parameters = {
                    new MySqlParameter("?name", MySqlDbType.VarChar,50),
                    new MySqlParameter("?price", MySqlDbType.Decimal,12),
                    new MySqlParameter("?intro", MySqlDbType.Text),
                    new MySqlParameter("?id", MySqlDbType.Int32,10)};
            parameters[0].Value = model.Name;
            parameters[1].Value = model.Price;
            parameters[2].Value = model.Intro;
            parameters[3].Value = model.CraftID;

            int rows=MysqlHelper.ExecuteNonQuery(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
示例#6
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Craft GetModel(int id)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("select id,name,price,intro from craft ");
            strSql.Append(" where id=?id");
            MySqlParameter[] parameters = {
                    new MySqlParameter("?id", MySqlDbType.Int32)
            };
            parameters[0].Value = id;

            Craft model=new Craft();
            DataSet ds=MysqlHelper.ExecuteDataSet(strSql.ToString(),parameters);
            if(ds.Tables[0].Rows.Count>0)
            {
                return DataRowToModel(ds.Tables[0].Rows[0]);
            }
            else
            {
                return null;
            }
        }
示例#7
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public bool Add(Craft model)
 {
     return dal.Add(model);
 }
示例#8
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(Craft model)
 {
     return dal.Update(model);
 }