public JsonResult OutSys(string MyChecked) { inquiryContact n = new inquiryContact(); inquiryContactData nd = new inquiryContactData(); var array = MyChecked.Split(','); if (MyChecked != "" && MyChecked != null) { for (var i = 0; i < array.Length; i++) { //var Original = nd.Get().ToList().Where(a => a.num.ToString() == array[i]).SingleOrDefault(); //var DelPath = System.IO.Path.Combine(Server.MapPath("~/upload/News/"), Original.pic1); //System.IO.File.Delete(DelPath); //if (Original.jsonimg != "no_img.jpg") //{ // var jsonstr = JsonConvert.DeserializeObject<List<jsonSer>>(Original.jsonimg); // var DelJsonPath = Server.MapPath("~/upload/photograhy/"); // foreach (var j in jsonstr) // { // var DelJsonPathing = System.IO.Path.Combine(DelJsonPath, j.content); // System.IO.File.Delete(DelJsonPathing); // } //} n.isdel = 1; n.udate = DateTime.Now; n.num = Convert.ToInt32(array[i]); nd.Delete(n); } } return Json(""); }
public ActionResult SendMsg(inquiryContact inquiryCon) { //if (Session["Account"] != null) //{ inquiryCon.isdel = 0; inquiryCon.memberID = 0; inquiryCon.wdate = DateTime.Now; inquiryCon.udate = DateTime.Now; var prodata = pd.Get().ToList().Where(a => a.isdel == 0); Dictionary<string, object> dic = new Dictionary<string, object>(); List<proinquiryCart> list = new List<proinquiryCart>(); foreach (var i in prodata) { if (Request.Cookies["cartVal_" + i.num.ToString()] != null) { if (i.num.ToString() == Request.Cookies["cartVal_" + i.num.ToString()]["num"]) { list.Add(new proinquiryCart() { num = i.num, qty = Convert.ToInt32(Request.Cookies["cartVal_" + i.num.ToString()]["qty"]), price = i.price, total = Convert.ToInt32(Request.Cookies["cartVal_" + i.num.ToString()]["qty"]) * i.price, }); } } } inquiryCon.jsonword = JsonConvert.SerializeObject(list); iqcd.Create(inquiryCon); //var inquirydata = icd.Get().ToList().Where(a => a.memberID == mdata.num && a.isSend == 0 && a.isdel == 0); //foreach (var i in inquirydata) //{ // ic.isSend = 1; // ic.udate = DateTime.Now; // ic.num = i.num; // icd.Update_Send(ic); //} var result = "<table border='1' cellspacing='1' cellpadding='1'>"; result += "<tbody>"; result += "<tr>"; result += "<th>公司</th>"; result += "<td>" + inquiryCon.uCompany + "</td>"; result += "</tr>"; result += "<tr>"; result += "<th>國家</th>"; result += "<td>" + inquiryCon.uCountry + "</td>"; result += "</tr>"; result += "<tr>"; result += "<th>姓名</th>"; result += "<td>" + inquiryCon.uName + "</td>"; result += "</tr>"; result += "<tr>"; result += "<th>電話</th>"; result += "<td>" + inquiryCon.uPhone + "</td>"; result += "</tr>"; result += "<tr>"; result += "<th>Email</th>"; result += "<td>" + inquiryCon.uEmail + "</td>"; result += "</tr>"; result += "<tr>"; result += "<th>類別</th>"; result += "<td>" + Contact_fn.GetQA(inquiryCon.need.ToString()) + "</td>"; result += "</tr>"; result += "<tr>"; result += "<th>訊息</th>"; result += "<td>" + inquiryCon.uMsg + "</td>"; result += "</tr>"; result += "</tbody>"; result += "</table><br>"; result += "<table>"; result += "<tr>"; result += "<td>商品名稱</td>"; result += "<td>數量</td>"; result += "<td>單價</td>"; result += "<td>金額</td>"; result += "</tr>"; foreach (var i in prodata) { if (Request.Cookies["cartVal_" + i.num.ToString()] != null) { if (i.num.ToString() == Request.Cookies["cartVal_" + i.num.ToString()]["num"]) { result += "<tr>"; result += "<td>" + i.pname + "</td>"; result += "<td>" + Request.Cookies["cartVal_" + i.num.ToString()]["qty"] + "</td>"; result += "<td>" + i.price + "</td>"; result += "<td>" + Convert.ToInt32(Request.Cookies["cartVal_" + i.num.ToString()]["qty"]) * i.price + "</td>"; result += "</tr>"; } } } result += "</table>"; //[email protected] SendMailToEveryOne.SendMail("*****@*****.**", inquiryCon.uEmail, "杉魁詢價表單", "杉魁詢價表單", result, false); TempData["msg"] = "詢價標單已送出"; return RedirectToAction("Index", "Home"); //} //else //{ // TempData["msg"] = "請先登入會員"; // return RedirectToAction("Index", "login"); //} }