public bool UpdateCount(Model.shop_log model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update " + databaseprefix + "shop_order ");
strSql.Append("set quantity=@quantity,");
strSql.Append("createDate=@createDate");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@quantity", SqlDbType.Int, 10),
new SqlParameter("@createDate", SqlDbType.DateTime, 10),
new SqlParameter("@id", SqlDbType.Int, 10)
};
parameters[0].Value = model.quantity;
parameters[1].Value = DateTime.Now;
parameters[2].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.shop_log model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into " + databaseprefix + "shop_order(");
strSql.Append("shop_id,goods_id,user_id,quantity,createDate)");
strSql.Append(" values (");
strSql.Append("@shop_id,@goods_id,@user_id,@quantity,@createDate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@shop_id", SqlDbType.Int, 10),
new SqlParameter("@goods_id", SqlDbType.Int, 10),
new SqlParameter("@user_id", SqlDbType.Int, 10),
new SqlParameter("@quantity", SqlDbType.Int, 10),
new SqlParameter("@createDate", SqlDbType.DateTime, 20)
};
parameters[0].Value = model.shop_id;
parameters[1].Value = model.goods_id;
parameters[2].Value = model.user_id;
parameters[3].Value = model.quantity;
parameters[4].Value = DateTime.Now;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public bool Update(int id, int quantity)
{
Model.shop_log model = new Model.shop_log();
model.id = id;
model.quantity = quantity;
return(dal.UpdateCount(model));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.shop_log GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from " + databaseprefix + "shop_order ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Model.shop_log model = new Model.shop_log();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["order_id"] != null && ds.Tables[0].Rows[0]["order_id"].ToString() != "")
{
model.shop_id = int.Parse(ds.Tables[0].Rows[0]["linkman"].ToString());
}
if (ds.Tables[0].Rows[0]["goods_id"] != null && ds.Tables[0].Rows[0]["goods_id"].ToString() != "")
{
model.goods_id = int.Parse(ds.Tables[0].Rows[0]["goods_id"].ToString());
}
if (ds.Tables[0].Rows[0]["user_id"] != null && ds.Tables[0].Rows[0]["user_id"].ToString() != "")
{
model.user_id = int.Parse(ds.Tables[0].Rows[0]["user_id"].ToString());
}
if (ds.Tables[0].Rows[0]["shop_name"] != null && ds.Tables[0].Rows[0]["shop_name"].ToString() != "")
{
model.shop_name = ds.Tables[0].Rows[0]["shop_name"].ToString();
}
if (ds.Tables[0].Rows[0]["quantity"] != null && ds.Tables[0].Rows[0]["quantity"].ToString() != "")
{
model.quantity = int.Parse(ds.Tables[0].Rows[0]["quantity"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(Model.shop_log model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from " + databaseprefix + "shop_order");
strSql.Append(" where shop_id=@shop_id ");
strSql.Append(" and goods_id=@goods_id ");
SqlParameter[] parameters =
{
new SqlParameter("@shop_id", SqlDbType.Int, 10),
new SqlParameter("@goods_id", SqlDbType.Int, 10)
};
parameters[0].Value = model.shop_id;
parameters[1].Value = model.goods_id;
return(DbHelperSQL.Exists(strSql.ToString(), parameters));
}
protected void Getstr()
{
int tolcount = 0;
List <Model.shop_log> list = new List <Model.shop_log>();
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
// int state = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidState")).Value);
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
if (cb.Checked)
{
Model.shop_log shop = new Model.shop_log();
Model.users userModel = new Web.UI.BasePage().GetUserInfo();
shop.user_id = userModel.id;
int count;
if (!int.TryParse(((TextBox)rptList.Items[i].FindControl("txtQuantity")).Text.Trim(), out count))
{
count = 0;
}
shop.quantity = count;
shop.goods_id = this.id;
shop.shop_id = id;
list.Add(shop);
tolcount = tolcount + count;
}
}
string message = "";
if (quantity == tolcount)
{
BLL.shop_log shop = new BLL.shop_log();
shop.AddList(list);
message = "true";
}
else
{
message = "错误：请与加入购物车数量保持一致";
ClientScript.RegisterStartupScript(page.GetType(), "message", "<script language='javascript' defer>alert('" + message + "');</script>");
return;
}
ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>setData(" + message + "," + quantity + "," + quantity * price + "," + this.id + ");</script>");//后台调用前台JS
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.shop_log model)
{
return(dal.Add(model));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(Model.shop_log model)
{
return(dal.Exists(model));
}