/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SOSOshop.Model.Stockout model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Stockout set ");
strSql.Append("UID=@UID,");
strSql.Append("Product_ID=@Product_ID,");
strSql.Append("Num=@Num,");
strSql.Append("created=@created");
strSql.Append(" where Id=@Id ");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "Id", DbType.Int32, model.Id);
db.AddInParameter(dbCommand, "UID", DbType.Int32, model.UID);
db.AddInParameter(dbCommand, "Product_ID", DbType.Int32, model.Product_ID);
db.AddInParameter(dbCommand, "Num", DbType.Int32, model.Num);
db.AddInParameter(dbCommand, "created", DbType.DateTime, model.created);
int rows = db.ExecuteNonQuery(dbCommand);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SOSOshop.Model.Stockout model)
{
if (Exists(model.UID, model.Product_ID))
{
return(0);
}
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Stockout(");
strSql.Append("UID,Product_ID,Num,created)");
strSql.Append(" values (");
strSql.Append("@UID,@Product_ID,@Num,@created)");
strSql.Append(";select @@IDENTITY");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "UID", DbType.Int32, model.UID);
db.AddInParameter(dbCommand, "Product_ID", DbType.Int32, model.Product_ID);
db.AddInParameter(dbCommand, "Num", DbType.Int32, model.Num);
db.AddInParameter(dbCommand, "created", DbType.DateTime, model.created);
int result;
object obj = db.ExecuteScalar(dbCommand);
if (!int.TryParse(obj.ToString(), out result))
{
return(0);
}
return(result);
}
protected void affirmOrder(object sender, EventArgs e)
{
if (!bll.isDispose(model.OrderId))
{
this.ClientScript.RegisterStartupScript(this.GetType(), "no", "$.jBox.alert('下单时间须超过十分钟才能处理！', '提示');", true);
return;
}
LinkButton lb = (LinkButton)sender;
string[] p = lb.CommandArgument.Split(':');
//删除商品
if (p[1] == "0")
{
bll.ExecuteNonQuery(string.Format("DELETE dbo.OrderProduct WHERE Id={0};UPDATE dbo.Orders SET TotalPrice=(SELECT SUM(ProPrice*ProNum) FROM OrderProduct WHERE OrderId='{1}') WHERE OrderId='{1}'", p[0], model.OrderId));
LogAdd("将订单：{0} 下面的商品编号: {1}删除了", model.OrderId, p[0], lb.Text);
BindList();
return;
}
if (p[1] == "3")
{
bllp.UpdateShop(p[0], model.OrderId, 4);
}
else
{
bllp.UpdateShop(p[0], model.OrderId, int.Parse(p[1]));
}
LogAdd("将订单：{0} 下面的商品编号: {1}设置为:{2}", model.OrderId, p[0], lb.Text);
//选择了缺货，写入货周期
if (p[1] == "3")
{
bll.ExecuteNonQuery(string.Format("INSERT INTO OrderProduct_Stockout values({0},'{1}')", p[0], lb.Text));
}
//选择了缺货，写入缺货通知
if (p[1] == "5")
{
SOSOshop.BLL.Stockout bllst = new SOSOshop.BLL.Stockout();
SOSOshop.Model.Stockout modelst = new SOSOshop.Model.Stockout();
System.Data.DataTable dt = bll.ExecuteTable("SELECT ProId,ProNum FROM dbo.OrderProduct WHERE Id={0}", p[0]);
modelst.Product_ID = (int)dt.Rows[0][0];
modelst.Num = (int)dt.Rows[0][1];
modelst.UID = model.ReceiverId;
modelst.created = DateTime.Now;
bllst.Add(modelst);
}
BindList();
}
