/// <summary>
/// 得到套餐业务的打印内容
/// </summary>
public static StringBuilder GetFood()
{
StringBuilder s = new StringBuilder();
string sql = String.Format("select * from flw_food_sale f,t_foods t where f.ID=(select max(ID) from flw_food_sale where WorkStation='{0}') and f.FoodID=t.FoodID and f.FlowType in ('0','1')", CommonValue.WorkStation);
DataSet d = WickyDAL.Query(sql);
if (d.Tables[0].Rows.Count != 1)
{
return(s);
}
DataRow r = d.Tables[0].Rows[0];
ID = r["ID"].ToString();
s.AppendLine("购买套餐" + "\t" + r["FoodName"].ToString());
if (r["Deposit"].ToString() != "0.00")
{
s.AppendLine("入会押金" + "\t" + r["Deposit"].ToString());
}
if (r["OpenFee"].ToString() != "0.00")
{
s.AppendLine("手续费" + "\t\t" + r["OpenFee"].ToString());
}
s.AppendLine("购币数" + "\t\t" + r["CoinQuantity"].ToString());
s.AppendLine("总金额" + "\t\t" + r["TotalMoney"].ToString());
s.AppendLine("------------------------------");
s.Append(GetMember(r["ICCardID"].ToString()));
return(s);
}
/// <summary>
/// 得到门票业务的打印内容
/// </summary>
public static StringBuilder GetFoodTicket()
{
StringBuilder s = new StringBuilder();
string sql = String.Format("select * from flw_food_ticket_sale f where f.ID=(select max(ID) from flw_food_ticket_sale where WorkStation='{0}')", CommonValue.WorkStation);
DataSet d = WickyDAL.Query(sql);
if (d.Tables[0].Rows.Count != 1)
{
return(s);
}
DataRow r = d.Tables[0].Rows[0];
ID = r["ID"].ToString();
string RuleID = r["RuleID"].ToString();
sql = String.Format("select * from t_food_ticket_rule f where RuleID={0}", RuleID);
DataRow r1 = WickyDAL.Query(sql).Tables[0].Rows[0];
s.AppendLine("套餐名称" + "\t" + r1["FoodTickName"].ToString());
s.AppendLine("序列号" + "\t" + r["FoodTicketKey"].ToString());
s.AppendLine("有效期" + "\t\t" + r1["Indate"].ToString() + "天");
s.AppendLine("消费币数" + "\t" + r["Coins"].ToString());
FoodTicketKey = r["FoodTicketKey"].ToString();
return(s);
}
/// <summary>
/// 获取售币机的设置值
/// </summary>
public static void GetSaleCoinerParameter()
{
DeviceCoin m = new DeviceCoin();
string sql = String.Format("select id from t_device where WorkStation='{0}' and type='售币机' and ConnType='串口通讯' and state='启用'", CommonValue.WorkStation);
DataSet set = WickyDAL.Query(sql);
if (set.Tables[0].Rows.Count == 0)
{
return;
}
DataRow r = set.Tables[0].Rows[0];
m = (DeviceCoin) new DeviceBLL().GetDevice(r["id"].ToString());
SaleCoinerCOM = String.IsNullOrEmpty(m.port_name) ? "COM1" : m.port_name;
SaleCoinerPort = String.IsNullOrEmpty(m.baute_rate) ? "57600" : m.baute_rate;
CanWork1 = String.IsNullOrEmpty(m.motor1) ? "0" : m.motor1;
CanWork2 = String.IsNullOrEmpty(m.motor2) ? "0" : m.motor2;
WorkType = String.IsNullOrEmpty(m.nixie_tube_type) ? 1 : Convert.ToInt32(m.nixie_tube_type);
Motor1Coin = Convert.ToInt32(m.motor1_coin);
Motor2Coin = Convert.ToInt32(m.motor2_coin);
DigitEn = (m.DigitCoin == "1");
DataAccess ac = new DataAccess();
DataTable dt = ac.ExecuteQueryReturnTable("select * from t_parameters where system='chkDouble'");
if (dt.Rows.Count > 0)
{
AllowDouble = (dt.Rows[0]["ParameterValue"].ToString() == "1");
}
}
/// <summary>
/// 得到商品销售业务的打印内容
/// </summary>
public static StringBuilder GetGoods()
{
StringBuilder s = new StringBuilder();
string sql = String.Format("select f.GoodsID,f.PayType,f.ICCardID,fd.GoodsName,fd.Quantity,g.Price,g.Coin as Coin,g.Point as Point,(fd.Quantity*g.Price) as totalprice from flw_goods f,flw_good_detail fd,t_goods g where f.GoodsID=(select max(GoodsID) from flw_goods where WorkStation='{0}') and f.GoodsID=fd.GoodsID and g.Barcode=fd.Barcode", CommonValue.WorkStation);
DataSet d = WickyDAL.Query(sql);
if (d.Tables[0].Rows.Count < 1)
{
return(s);
}
DataRow r1 = d.Tables[0].Rows[0];
ID = r1["GoodsID"].ToString();
s.AppendLine("商品名称" + "\t" + "数量" + "\t" + "金额");
double m = 0.00;
int c = 0;
int p = 0;
for (int i = 0; i < d.Tables[0].Rows.Count; i++)
{
DataRow r = d.Tables[0].Rows[i];
s.AppendLine(r["GoodsName"].ToString() + "\t\t" + r["Quantity"].ToString() + "\t￥" + r["totalprice"].ToString());
m += Convert.ToDouble(r["totalprice"]);
c += Convert.ToInt32(r["Coin"]);
p += Convert.ToInt32(r["Point"]);
}
s.AppendLine("------------------------------");
s.AppendLine("合计金额" + "\t￥" + m.ToString());
string type = "现金";
if (r1["PayType"].ToString() == "2")
{
type = "电子币:" + c;
}
else if (r1["PayType"].ToString() == "3")
{
type = "积分:" + p;
}
s.AppendLine("支付方式" + "\t" + type);
s.AppendLine("------------------------------");
s.Append(GetMember(r1["ICCardID"].ToString(), true));
return(s);
}
/// <summary>
/// 得到提币业务的打印内容
/// </summary>
public static StringBuilder GetCoin()
{
StringBuilder s = new StringBuilder();
string sql = String.Format("select * from flw_coin_sale f where f.ID=(select max(ID) from flw_coin_sale where WorkStation='{0}' and WorkType in ('3','6','7'))", CommonValue.WorkStation);
DataSet d = WickyDAL.Query(sql);
if (d.Tables[0].Rows.Count != 1)
{
return(s);
}
DataRow r = d.Tables[0].Rows[0];
ID = r["ID"].ToString();
s.AppendLine("原有币数" + "\t" + GetOldBalance(r["Balance"].ToString(), r["Coins"].ToString(), true));
s.AppendLine("提取币数" + "\t" + r["Coins"].ToString());
s.AppendLine("------------------------------");
s.Append(GetMember(r["ICCardID"].ToString()));
return(s);
}
/// <summary>
/// 得到积分换币业务的打印内容
/// </summary>
public static StringBuilder GetPoint()
{
StringBuilder s = new StringBuilder();
string sql = String.Format("select * from flw_rebate f where f.ID=(select max(ID) from flw_rebate where WorkStation='{0}')", CommonValue.WorkStation);
DataSet d = WickyDAL.Query(sql);
if (d.Tables[0].Rows.Count != 1)
{
return(s);
}
DataRow r = d.Tables[0].Rows[0];
ID = r["ID"].ToString();
s.AppendLine("消耗积分" + "\t" + r["UsedPoint"].ToString());
s.AppendLine("兑换币数" + "\t" + r["PointCoin"].ToString());
s.AppendLine("原有币数" + "\t" + GetOldBalance(r["Balance"].ToString(), r["PointCoin"].ToString()));
s.AppendLine("------------------------------");
s.Append(GetMember(r["ICCardID"].ToString(), true));
return(s);
}
/// <summary>
/// 得到退币业务的打印内容
/// </summary>
public static StringBuilder GetExitCoin()
{
StringBuilder s = new StringBuilder();
string sql = String.Format("select * from flw_coin_exit f where f.ID=(select MAX(id) as ID from flw_coin_exit where WorkStation='{0}')", CommonValue.WorkStation);
DataSet d = WickyDAL.Query(sql);
if (d.Tables[0].Rows.Count != 1)
{
return(s);
}
DataRow r = d.Tables[0].Rows[0];
ID = r["ID"].ToString();
s.AppendLine("兑币： " + r["Coins"].ToString());
s.AppendLine("金额： " + r["CoinMoney"].ToString());
s.AppendLine("当前余额： " + r["Balance"].ToString());
s.AppendLine("------------------------------");
s.Append(GetMember(r["ICCardID"].ToString()));
return(s);
}
