protected void Page_Load(object sender, EventArgs e)
{
DataTable dt;
string code = Request["code"];
string[] ary = code.Split('-');
code = ary[0] + "-" + ary[1] + "-" + ary[2];
if (code == null || code == "")
{
msg = "無編號";
}
else
{
LessonLib.JoinData l = LessonLib.Web.Get_ord_JoinData(ary[0]);
if (l.Id == 0)
{
msg = "報名資料不存在";
}
else
{
string strsql = "select * from tbl_joindetail where joinid=@joinid ";
NameValueCollection nvc = new NameValueCollection
{
{ "joinid", ary[1] },
};
strsql = "select * from tbl_joinlog where checkcode=@checkcode ";
nvc.Clear();
nvc = new NameValueCollection
{
{ "checkcode", code },
};
dt = DbControl.Data_Get(strsql, nvc);
if (dt.Rows.Count > 0)
{
msg = "已報到過!";
}
else
{
strsql = "insert into tbl_joinlog (checkcode) values (@checkcode)";
DbControl.Data_add(strsql, nvc);
msg = "報到成功!";
}
msg += "<br>訂單編號:" + l.Ord_code + "<br>";
msg += "付款方式:" + OrderLib.getPaymode(l.OrderData.Paymode) + "<br>";
msg += "訂單狀態:" + OrderLib.get_ord_status(l.OrderData.Status) + "<br>";
}
}
}
public static string Get_JoinData(string ord_code)
{
string htmldetail = "";
string htmlstr;
LessonLib.JoinData o = LessonLib.Web.Get_ord_JoinData(ord_code);
htmlstr = unity.classlib.GetTextString(HttpContext.Current.Server.MapPath(" /templates/Lessondata0.html"));
htmldetail = unity.classlib.GetTextString(HttpContext.Current.Server.MapPath("/templates/classdetail.html"));
htmlstr = htmlstr.Replace("@subject@", o.LessonData.MainData.Subject);
htmlstr = htmlstr.Replace("@pic@", o.LessonData.MainData.Pic);
htmlstr = htmlstr.Replace("@totalprice@", o.OrderData.TotalPrice.ToString());
htmlstr = htmlstr.Replace("@classdate@", o.LessonData.StartDay.ToShortDateString() + "~" + o.LessonData.EndDay.ToShortDateString());
htmlstr = htmlstr.Replace("@address@", o.LessonData.Address);
htmlstr = htmlstr.Replace("@ord_code@", o.Ord_code);
htmlstr = htmlstr.Replace("@DeliveryPrice@", o.OrderData.ShipPrice.ToString());
htmlstr = htmlstr.Replace("@ordername@", o.OrderData.Ordname);
htmlstr = htmlstr.Replace("@ordermail@", o.OrderData.Ordemail);
htmlstr = htmlstr.Replace("@orderphone@", o.OrderData.Ordphone);
htmlstr = htmlstr.Replace("@shipname@", o.OrderData.Ordname);
htmlstr = htmlstr.Replace("@shipphone@", o.OrderData.Ordphone);
htmlstr = htmlstr.Replace("@shipaddress@", o.OrderData.Ordaddress);
htmlstr = htmlstr.Replace("@TotalPrice@", "NT$:" + o.OrderData.TotalPrice.ToString());
htmlstr = htmlstr.Replace("@paymode@", OrderLib.getPaymode(o.OrderData.Paymode));
htmlstr = htmlstr.Replace("@ShipPrice@", o.OrderData.ShipPrice.ToString());
htmlstr = htmlstr.Replace("@delivery_kind@", OrderLib.getdelivery_kind(o.OrderData.Delivery_kind));
htmlstr = htmlstr.Replace("@ticketname@", o.LessonData.MainData.Subject);
htmlstr = htmlstr.Replace("@StartDay@", o.LessonData.MainData.Lesson.StartDay.ToString("yyyy/MM/dd"));
htmlstr = htmlstr.Replace("@EndDay@", o.LessonData.MainData.Lesson.EndDay.ToString("yyyy/MM/dd"));
htmlstr = htmlstr.Replace("@Lessontime@", o.LessonData.MainData.Lesson.Lessontime);
htmlstr = htmlstr.Replace("@paymode@", OrderLib.getPaymode(o.OrderData.Paymode));
htmlstr = htmlstr.Replace("@paystatus@", OrderLib.get_ord_status(o.OrderData.Status));
SpGatewayHelper.Models.TradeInfoLog log = OrderLib.Get_Tradelog(ord_code);
string payinfo = "";
if (log.Result.TradeNo != "")
{
payinfo += "<tr><td colspan=\"4\">轉帳資訊:<br>";
payinfo += "銀行代碼:" + log.Result.BankCode + "<br>";
payinfo += "帳號:" + log.Result.CodeNo + "<br></td></tr>";
}
// string payinfo = "";
htmlstr = htmlstr.Replace("@payinfo@", payinfo);
string temp = "";
string temp1 = "";
foreach (article.LessonDetail d in o.LessonData.LessonDetail)
{
var data = o.JoinDetail.Find(y => y.LessonId == d.LessonId);
// var data = o.LessonData.LessonDetail.FindAll (y => y.LessonId == d.LessonId).Sum(c => d.Sellprice );
// var data = o.LessonData.LessonDetail.FindAll.Where(x => x.ID).Sum(c => c.price)
if (data != null)
{
temp1 += "<tr><td>" + o.LessonData.MainData.Subject + "</td>";
temp1 += "<td colspan=\"2\">" + d.Description + "</td>";
temp1 += "<td class='text-right'>";
temp1 += "NT$" + d.Sellprice + "</td></tr>";
}
}
foreach (LessonLib.JoinDetail d in o.JoinDetail)
{
string QrCode = o.Ord_code + "-" + d.JoinId.ToString() + "-" + d.LessonId;
string url = "http://www.culturelaunch.net/lib/checkjoin.aspx?code=" + QrCode;
temp += htmldetail;
temp = temp.Replace("@secno@", d.JoinId.ToString());
temp = temp.Replace("@ticketno@", QrCode);
temp = temp.Replace("@name@", d.Name.ToString());
temp = temp.Replace("@email@", d.Email.ToString());
temp = temp.Replace("@phone@", d.Phone.ToString());
temp = temp.Replace("@qrcode@", QrCode);
temp = temp.Replace("@orderno@", ord_code);
QR_Encode qr = new QR_Encode();
qr.BackColor = Color.White;
qr.ForeColor = Color.Black;
int i = qr.EncodeData(1, 0, true, -1, 5, url, HttpContext.Current.Server.MapPath("upload/" + QrCode + ".gif"), false, 255, 255);
//Bitmap b = qr.GetBMP; //輸出至前端
//Response.ContentType = "image/jpeg";
//b.Save(Response.OutputStream, ImageFormat.Gif);
//b.Dispose();
}
htmlstr = htmlstr.Replace("@detail@", temp1);
htmlstr = htmlstr.Replace("@classdetail@", temp);
return(htmlstr);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["userid"] == null || Session["Backmenu"] == null || Session["Backmenu"].ToString() == "")
{
Response.Redirect("~/account/login.aspx?ReturnUrl=" + Request.RawUrl.ToString());
Response.End();
}
string articleid = Request.QueryString["articleid"];
string strsql = @"select * FROM tbl_Joindata where articleid=@articleid";
NameValueCollection nvc = new NameValueCollection
{
{ "articleid", articleid }
};
DataTable dt = DbControl.Data_Get(strsql, nvc);
List <LessonLib.JoinData> JoinData = new List <LessonLib.JoinData>();
foreach (DataRow dr in dt.Rows)
{
LessonLib.JoinData j = LessonLib.Web.Get_ord_JoinData(dr["ord_code"].ToString());
JoinData.Add(j);
}
dt.Dispose();
int i = 0;
int total = 0;
foreach (LessonLib.JoinData j in JoinData)
{
foreach (LessonLib.JoinDetail d in j.JoinDetail)
{
var data = j.LessonData.LessonDetail.Find(y => y.LessonId == d.LessonId);
string qr = j.Ord_code + "-" + d.JoinId + "-" + d.LessonId;
total++;
html += "<tr>";
html += "<td>";
html += "<button type=\"button\"class=\"btn btn-primary\" data-ord_code=\"" + j.Ord_code + "\" data-toggle=\"modal\" data-target=\"#exampleModal\">";
html += j.Ord_code + "</button></td>";
html += "<td>" + OrderLib.getPaymode(j.OrderData.Paymode) + "</td>";
html += "<td>" + OrderLib.get_ord_status(j.OrderData.Status) + "</td>";
html += "<td>" + d.Name + "</td>";
html += "<td>" + d.Email + "</td>";
html += "<td>" + d.Phone + "</td>";
html += "<td>" + d.Unitname + "</td>";
html += "<td>" + d.Postion + "</td>";
html += "<td>" + d.checkin + "</td>";
html += "</tr>" + "\r\n";
if (d.checkin == "Y")
{
i++;
}
//string QrCode = j.Ord_code + "-" + d.JoinId.ToString() + "-" + d.LessonId;
//string url = "http://www.culturelaunch.net/lib/checkjoin.aspx?code=" + QrCode;
//QR_Encode qr = new QR_Encode
//{
// BackColor = Color.White,
// ForeColor = Color.Black
//};
//qr.EncodeData(1, 0, true, -1, 5, url, HttpContext.Current.Server.MapPath("/upload/" + QrCode + ".gif"), false, 255, 255);
}
}
//html += "<Tr><td></td><td>總報名人數</td><td>" + total + "</td>";
//html += "<td>已報到人數</td><td>" + i + "</td>";
//html += "<td><a href=\"javascript:window.print();\">列印</a></td><td></td><td></td><td></td></tr>";
////html += "</table>";
JoinData = null;
}