public DataTable GetOldBookInfoById(string id)
{
DBOperation dbo = new DBOperation();
string sql = string.Format("SELECT * FROM OldBookSellInfo WHERE id = '{0}'", id);
return(dbo.Selectinfo(sql));
}
public DataTable GetAllJinhuoqudao()
{
DBOperation dbo = new DBOperation();
string sql = "SELECT * FROM yg_jinhuoqudao";
return(dbo.Selectinfo(sql));
}
public DataTable GetBookinfoByBookid(string id)
{
DBOperation dbo = new DBOperation();
string sql = "SELECT id,name,author,press,isbn,price FROM yg_bookinfo WHERE id = '" + id + "'";
return(dbo.Selectinfo(sql));
}
public DataTable SearchBookinfoByIsbn(string isbn)
{
DBOperation dbo = new DBOperation();
string sql = string.Format("SELECT id,name,author,press,price,isbn FROM yg_bookinfo WHERE ISBN = '{0}'", isbn);
DataTable dt = dbo.Selectinfo(sql);
return(dt);
}
public string GetLocalShopId()
{
DBOperation dbo = new DBOperation();
string sql = "SELECT * FROM yg_local_shopinfo";
DataTable dt = dbo.Selectinfo(sql);
if (dt.Rows.Count == 1)
{
return(dt.Rows[0]["shopid"].ToString());
}
else
{
return(null);
}
}
public string GetOrderIdByCreateTime(string time)
{
string sql = string.Format("SELECT id FROM yg_orderinfo WHERE datetime = '{0}'", time);
DBOperation dbo = new DBOperation();
DataTable dt = dbo.Selectinfo(sql);
if (dt.Rows.Count != 1)
{
this.DebugPrint("获取订单id错误，取到的结果集行数为：" + dt.Rows.Count.ToString());
return(null);
}
else
{
return(dt.Rows[0]["id"].ToString());
}
}
public bool InsertOrderDetail(OrderDetail od)
{
string sql = string.Format("INSERT INTO yg_orderdetail (orderid,bookid,count,off) VALUES ('{0}','{1}','{2}','{3}')",
od.orderid, od.bookid, od.count, od.off);
DBOperation dbo = new DBOperation();
if (1 == dbo.AddDelUpdate(sql))
{
sql = string.Format("SELECT * FROM yg_bookstock WHERE bookid = '{0}'", od.bookid);
DataTable dt = dbo.Selectinfo(sql);
if (dt.Rows.Count == 0)
{
sql = string.Format("INSERT INTO yg_bookstock (bookid , count) VALUES ('{0}','{1}')", od.bookid, od.count);
if (1 == dbo.AddDelUpdate(sql))
{
return(true);
}
else
{
return(false);
}
}
else if (dt.Rows.Count == 1)
{
sql = string.Format("UPDATE yg_bookstock SET count = count + {0} WHERE bookid = '{1}'", od.count, dt.Rows[0]["bookid"].ToString());
if (1 == dbo.AddDelUpdate(sql))
{
return(true);
}
else
{
return(false);
}
}
else
{
this.DebugPrint("出现了两本或更多相同bookid的库存信息");
return(false);
}
}
else
{
return(false);
}
}
public bool InsertNewBookInfo(Localbookinfo bi, out string id)
{
id = null;
string sql = string.Format("INSERT INTO yg_bookinfo (`gbookid`,`name`,`author`,`press`,`price`,`ISBN`,`imgpath`) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}')",
bi.guid, bi.name, bi.author, bi.press, bi.fixedprice, bi.isbn, bi.imgpath);
DBOperation dbo = new DBOperation();
if (1 != dbo.AddDelUpdate(sql))
{
return(false);
}
sql = string.Format("SELECT id FROM yg_bookinfo WHERE gbookid = '{0}'", bi.guid);
DataTable dt = dbo.Selectinfo(sql);
if (dt.Rows.Count > 0)
{
id = dt.Rows[0]["id"].ToString();
return(true);
}
return(false);
}
