public void DoSave(object[] data)
{
using (DbHelper db = AppUtils.CreateDbHelper())
{
try
{
db.BeginTransaction();
Test001.Login.User user = ((Test001.Login.User)Session["user"]);
db.AddParameter("userid", user.Id);
db.ExecuteScalerSQL("delete from btypeconfig where userid=@userid");
for (int i = 0; i < data.Length; i++)
{
IHashObject item = (IHashObject)data[i];
db.AddParameter("size", item["size"]);
db.AddParameter("color", item["color"]);
db.AddParameter("price", item["price"]);
db.AddParameter("userid", user.Id);
db.ExecuteIntSQL("insert into btypeconfig values(@size, @color, @price, @userid)");
}
db.CommitTransaction();
}
catch (Exception e)
{
if (db.HasBegunTransaction)
{
db.RollbackTransaction();
}
throw e;
}
}
}
public override void Initialize()
{
base.Initialize(); using (DbHelper db = AppUtils.CreateDbHelper())
{
Test001.Login.User user = ((Test001.Login.User)Session["user"]);
db.AddParameter("userid", user.Id);
IHashObjectList list = db.Select("select * from btypeconfig where userid=@userid");
Context["grid"] = list;
Context["dataTableTree"] = new DbTreeDataSource(GetData(list), "name", "id", "parentId", 0);
}
}
public override void Initialize()
{
base.Initialize();
Test001.Login.User user = (Test001.Login.User)Session["user"];
var list = new Test001.StockBill.list(new Test001.Login.User()
{
Id = user.Id, Power = user.Power, Name = user.Name
}, true);
IHashObject item = new HashObject();
item["kind"] = "2";
list.SetQueryParams(item);
Context["list"] = list;
}
public override void Initialize()
{
base.Initialize();
using (DbHelper db = AppUtils.CreateDbHelper())
{
Test001.Login.User user = ((Test001.Login.User)Session["user"]);
db.AddParameter("userid", user.Id);
IHashObjectList userList = db.Select("select color, size, price from btypeconfig where userid=@userid");
List <string> color = new List <string>();
List <string> size = new List <string>();
foreach (IHashObject hash in userList)
{
if (!color.Contains(hash.GetValue <string>("color")))
{
color.Add(hash.GetValue <string>("color"));
}
if (!size.Contains(hash.GetValue <string>("size")))
{
size.Add(hash.GetValue <string>("size"));
}
}
Context["size"] = size;
Context["color"] = color;
Context["sizecolor"] = userList;
if (this.Request.QueryString["id"] == null)
{
IHashObject data = new HashObject();
data["date"] = DateTime.Now;
data["amount"] = 1;
data["size"] = size.Count > 0 ? size[0] : "";
data["color"] = color.Count > 0 ? color[0] : "";
data["csendway"] = "送货到小区";
data["dobtotal"] = user.Power == 99 ? 1 : 0;
data["sizecolor"] = userList;
decimal total = userList.Count > 0 ? userList[0].GetValue <decimal>("price") : 0;
if (user.Power == 99)
{
data["btotal"] = 0;
}
else
{
data["btotal"] = (total * (decimal)0.05);
}
data["total"] = total;
Context["bill"] = data;
Context["enable"] = true;
return;
}
string id = Request.QueryString["id"].ToString();
db.AddParameter("id", id);
IHashObject bill = db.SelectSingleRow(@"select id,DATE_FORMAT(date, '%Y-%m-%d') as date,taobaocode,cname,ctel,caddress,carea,csendway,cremark,btotal,ltotal,preferential, status from bill where id=@id");
db.AddParameter("id", id);
//todo 一个单对多个商品时会报错
IHashObject billDetial = db.SelectSingleRow("select * from billdetail where bid=@id");
foreach (string key in billDetial.Keys)
{
if (key.ToLower() == "id")
{
continue;
}
bill[key] = billDetial[key];
}
bill["dobtotal"] = user.Power == 99 ? 1 : 0;
bill["sizecolor"] = userList;
Context["bill"] = bill;
Context["enable"] = true;// bill.GetValue<int>("status") < 1;
}
}
