/// <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); }