/// <summary>
/// 根据订单状态查询
/// </summary>
/// <param name="Ostate"></param>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <returns></returns>
//public static List<Order> GetOrdersByOstate(int Ostate,int PageSize,int PageIndex) {
// List<Order> list = new List<Order>();
// String sql = string.Format("select top(5) * from dbo.Orders where OID not in(select top(@PageSize*(@PageIndex-1)) OID from Orders where OState = @Ostate) and OState=@Ostate;");
// SqlParameter[] sp = new SqlParameter[] {
// new SqlParameter("@PageSize",PageSize),
// new SqlParameter("@PageIndex",PageIndex),
// new SqlParameter("@Ostate",Ostate),
// new SqlParameter("@Ostate",Ostate)
// };
// using (SqlDataReader sdr = DBHelp.MyExecuteReader(sql, null))
// {
// while (sdr.Read())
// {
// Order o = new Order();
// o.MID = Convert.ToInt32(sdr["MID"]);
// o.OAddress = sdr["OAddress"].ToString();
// o.OConsignee = sdr["OConsignee"].ToString();
// o.ODate = Convert.ToDateTime(sdr["ODate"]);
// o.OID = sdr["OID"].ToString();
// o.OState = Convert.ToInt32(sdr["OState"]);
// o.OSumPrice = Convert.ToInt32(sdr["OSumPrice"]);
// o.OTelephone = sdr["OTelephone"].ToString();
// list.Add(o);
// }
// }
// return list;
//}
//public static int getOrdersRowsByOstate(int Ostate) {
// String sql = string.Format("select COUNT(*) from Orders where OState=@Ostate");
// SqlParameter[] sp = new SqlParameter[] {
// new SqlParameter("@Ostate",Ostate),
// };
// int count = Convert.ToInt32(DBHelp.MyExecuteNonQuery(sql,sp));
// return count;
//}
/// <summary>
/// 获取行数
/// </summary>
/// <param name="ID"></param>
/// <param name="name"></param>
/// <returns></returns>
public static int getOrdersRows(string ID, string name)
{
string sql = string.Format("select count(*) from dbo.Orders where OID like '%{0}%' and OConsignee like '%{1}%'", ID, name);
int count = Convert.ToInt32(DBHelp.MyExecuteScalar(sql, null));
return(count);
}
/// <summary>
/// 生成新订单编号
/// </summary>
/// <returns></returns>
public static string GetNewOrderID()
{
string newOderID = "DD";
string NewDate = DateTime.Now.ToString("yyyyMMdd");
string sql = "select max(OID) from Orders";
//最大的订单号
string maxOrderID = DBHelp.MyExecuteScalar(sql, null).ToString();
//截取日期部分
if (maxOrderID != "" && maxOrderID.Substring(2, 8) == NewDate) //如果当天存在了订单
{
//就在当天订单的后面+1
//1000?
int ls = Convert.ToInt32(maxOrderID.Substring(maxOrderID.Length - 4)) + 1 + 10000; //获取最后4位流水码
//流水码
string lsm = ls.ToString().Substring(1);
//新订单
newOderID = newOderID + NewDate + lsm;
}
else //如果当天不存在订单
{
//新订单
newOderID = newOderID + NewDate + "0001";
}
return(newOderID);
}
/// <summary>
/// 根据用户名判断用户存在与否
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public static object selectByName(string name)
{
Member m = new Member();
string sql = string.Format("select * from dbo.Member where MName = @name");
SqlParameter[] pare = new SqlParameter[] { new SqlParameter("@name", name) };
object o = DBHelp.MyExecuteScalar(sql, pare);
return(o);
}
/// <summary>
/// 判断数据是否存在
/// </summary>
/// <param name="t"></param>
/// <returns></returns>
public static bool Exits(Trade t)
{
String sql = string.Format("select count(*) from trade where Bid=@Bid and Mid=@Mid");
SqlParameter[] sp = new SqlParameter[] {
new SqlParameter("@Bid", t.BID),
new SqlParameter("@Mid", t.MID)
};
return(Convert.ToInt32(DBHelp.MyExecuteScalar(sql, sp)) > 0 ? true : false);
}
/// <summary>
/// 查询订单状态
/// </summary>
/// <returns></returns>
public static int selectOrderState(int state)
{
int count = 0;
string sql = string.Format("select count(*) from Orders where OState={0}", state);
object obj = DBHelp.MyExecuteScalar(sql, null);
try
{
count = Convert.ToInt32(obj);
}
catch (Exception)
{
}
return(count);
}
/// <summary>
/// 根据用户Mid查询购物车数据行
/// </summary>
/// <param name="MID"></param>
/// <returns></returns>
public static int getTradeRows(int MID)
{
SqlParameter[] pare = new SqlParameter[]
{
new SqlParameter("@MID", MID)
};
try
{
return(Convert.ToInt32(DBHelp.MyExecuteScalar("select count(*) from Trade where MID=@MID", pare)));
}
catch (Exception)
{
return(0);
}
}
/// <summary>
/// 根据MID查询购物车里面的总价
/// </summary>
/// <param name="MID"></param>
/// <returns></returns>
public static double getTradeSumPriceByMID(int MID)
{
SqlParameter[] pare = new SqlParameter[]
{
new SqlParameter("@MID", MID)
};
try
{
return(Convert.ToDouble(DBHelp.MyExecuteScalar("select sum(Trade.BCount*BPrice) from Trade inner join Book on Trade.BID=Book.BID where MID=@MID", pare)));
}
catch (Exception)
{
return(0);
}
}
/// <summary>
/// 查询总行数
/// </summary>
/// <returns></returns>
public static int dataRows(string BLID, string BSID, string BName)
{
string sql = string.Format("select count(*) from Book where BName like '%{0}%'", BName);
if (BSID != null)
{
sql = string.Format("select count(*) from Book where BSID={0}", Convert.ToInt32(BSID));
}
if (BLID != null)
{
sql = string.Format("select count(*) from dbo.Book b where BSID in (select BSID from BLCategory bl inner join BSCategory bs on bs.BLID=bl.BLID where bl.BLID={0})", Convert.ToInt32(BLID));
}
int count = Convert.ToInt32(DBHelp.MyExecuteScalar(sql, null));
return(count);
}
