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;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TextileCity.Entity.Material DataRowToModel(DataRow row)
{
TextileCity.Entity.Material model = new TextileCity.Entity.Material();
if (row != null)
{
foreach (DataColumn col in row.Table.Columns)
{
if (row[col] != null && row[col].ToString() != "")
{
switch (col.ColumnName)
{
case "id":
model.MaterialID = int.Parse(row[col].ToString());
break;
case "category_id":
model.CategoryID = int.Parse(row[col].ToString());
break;
case "type":
model.CategoryType = row[col].ToString();
break;
case "name":
model.Name = row[col].ToString();
break;
case "price":
model.Price = decimal.Parse(row[col].ToString());
break;
case "price_high":
model.PriceHigh = decimal.Parse(row[col].ToString());
break;
case "price_fancy":
model.PriceFancy = decimal.Parse(row[col].ToString());
break;
case "styles":
model.StylesList = row[col].ToString();
break;
case "intro":
model.Intro = row[col].ToString();
break;
case "main_image":
model.MainImage = row[col].ToString();
break;
case "images":
model.Images = row[col].ToString();
break;
}
}
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TextileCity.Entity.Material GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,category_id,type,name,price,price_high,price_fancy,styles,intro,main_image,images from material ");
strSql.Append(" where id=?id");
MySqlParameter[] parameters = {
new MySqlParameter("?id", MySqlDbType.Int32)
};
parameters[0].Value = id;
TextileCity.Entity.Material model = new TextileCity.Entity.Material();
DataSet ds = MysqlHelper.ExecuteDataSet(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Material model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Material model)
{
return dal.Update(model);
}