/// <summary>
/// 获取最大单号
/// </summary>
/// <returns>最大单号</returns>
public static string GetMaxDT()
{
string sql = " select MAX(CBID) from dbo.ConsumerBill where CBID like '%'+CONVERT(varchar,GETDATE(),112)+'%' ";
object d = DBhelper.MyExecuteScalar(sql, null);
return(d.ToString());
}
public static string selectpwd(AdminsMDL a)
{
string sql = "select usercompellation from admins where username=@username and userpwd=@userpwd";
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@username", a.UserName));
list.Add(new SqlParameter("@userpwd", a.UserPWD));
return(DBhelper.MyExecuteScalar(sql, list.ToArray()).ToString());
}
public static int GetMaxID()
{
string sql = "select max(VipID) from dbo.Vips";
object o = DBhelper.MyExecuteScalar(sql, null);
if (!(o is DBNull))
{
return(Convert.ToInt32(o));
}
else
{
return(0);
}
}
public static string billYY(string Date)
{
string sql = "select sum(CBSale) from dbo.ConsumerBill where CBID like @Date";
SqlParameter [] sp =
{
new SqlParameter("@Date", "%" + Date + "%")
};
object o = DBhelper.MyExecuteScalar(sql, sp);
if (o.ToString() == "")
{
return("0");
}
return(o.ToString());
}
public static string GetCBID(int TableID)
{
string sql = @"select CBID
from Tables t join ConsumerBill c
on t.TableID=c.TableID
where t.TableID=@TableID and CBClose=0 ";
SqlParameter[] sp =
{
new SqlParameter("@TableID", TableID)
};
object c = DBhelper.MyExecuteScalar(sql, sp);
if (c != null)
{
return(c.ToString());
}
return("尚未开单");
}
/// <summary>
/// 查询剩余的桌子数
/// </summary>
/// <param name="RTID">房间类型</param>
/// <returns>剩余的桌子数</returns>
public static int GetTableCount(int RTID)
{
string sql = "select RTMount-(select COUNT(*) from Tables where RTID=@RTID) from RoomType where RTID=@RTID";
SqlParameter[] sp =
{
new SqlParameter("@RTID", RTID)
};
object o = DBhelper.MyExecuteScalar(sql, sp);
//有数据
if (!(o is DBNull))
{
return(Convert.ToInt32(o));
}
else
{
return(10000);
}
}