public int Reply(OrderCancelResponse ocr) { try { return icancelDao.Reply(ocr); } catch (Exception ex) { throw new Exception("OrderCancelMsgMgr.Reply-->" + ex.Message, ex); } }
/// <summary> /// 對用戶的問題與意見進行回覆 /// </summary> /// <param name="cancel_id"></param> /// <param name="value"></param> /// <returns></returns> public int Reply(OrderCancelResponse ocr) { string sql = string.Empty; int i = 0; MySqlCommand mySqlCmd = new MySqlCommand(); MySqlConnection mySqlConn = new MySqlConnection(connString); try { if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Closed) { mySqlConn.Open(); } mySqlCmd.Connection = mySqlConn; mySqlCmd.Transaction = mySqlConn.BeginTransaction(); mySqlCmd.CommandType = System.Data.CommandType.Text; sql = string.Format("update order_cancel_msg set cancel_status = 1 where cancel_id ={0} and cancel_status = 0", ocr.cancel_id); mySqlCmd.CommandText = sql; i += mySqlCmd.ExecuteNonQuery(); _serialDao = new SerialDao(connString); mySqlCmd.CommandText = _serialDao.Update(37); string response_id = mySqlCmd.ExecuteScalar().ToString(); sql = string.Format("insert into order_cancel_response(response_id,cancel_id,user_id,response_content,response_createdate,response_ipfrom)"); sql += string.Format(" values({0},{1},{2},'{3}',{4},'{5}')", response_id, ocr.cancel_id,ocr.user_id,ocr.response_content,CommonFunction.GetPHPTime(DateTime.Now.ToString()), ocr.response_ipfrom); mySqlCmd.CommandText = sql; i += mySqlCmd.ExecuteNonQuery(); mySqlCmd.Transaction.Commit(); } catch (Exception ex) { mySqlCmd.Transaction.Rollback(); throw new Exception("OrderCancelMsgDao-->Reply-->" + ex.Message+sql.ToString(), ex); } finally { if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Open) { mySqlConn.Close(); } } return i; }
public HttpResponseBase Reply() { string json = string.Empty; string response_content = string.Empty; OrderCancelResponse ocr = new OrderCancelResponse(); _ptersrc = new ParameterMgr(mySqlConnectionString); int i = 0; string cancel_id = string.Empty; ; if (!string.IsNullOrEmpty(Request.Params["cancel_id"])) { cancel_id = Request.Params["cancel_id"]; ocr.cancel_id = uint.Parse(cancel_id); } string question_email = string.Empty; if (!string.IsNullOrEmpty(Request.Params["question_email"])) { question_email = Request.Params["question_email"]; } //獲取登錄用戶的user_email string user_email = (Session["caller"] as Caller).user_email; //獲取登錄用戶的user_id string user_id = (Session["caller"] as Caller).user_id.ToString(); string res; try { res = Request.Params["response"].ToString().Trim(); res = res.Replace("\n", ""); if (res.Length > 0) { response_content = Request.Params["response"] + " "; ocr.user_id = uint.Parse(user_id); ocr.response_content = response_content; System.Net.IPAddress[] addlist = Dns.GetHostEntry(Dns.GetHostName()).AddressList; if (addlist.Length > 0) { ocr.response_ipfrom = addlist[0].ToString(); } _orderCancelMsgMgr = new OrderCancelMsgMgr(mySqlConnectionString); i = _orderCancelMsgMgr.Reply(ocr); bool issend = false; if (i == 2) { MailHelper mail = new MailHelper(); string mail1 = _ptersrc.Getmail("TestMail"); if (mail1 == "*****@*****.**") {//測試使用上正式機后可變更為gigademail則是讀取會員mail mail1 = question_email; } issend = mail.SendMailAction(mail1, "取消訂單通知信", response_content); } json = "{success:true,msg:\"" + " 發送郵件成功!" + "\"}"; } else { json = "{success:false,msg:\"" + "请填写回覆内容!" + "\"}"; } } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = ex.InnerException.Message; json = ex.InnerException.Source; json = "{success:false,msg:\"" + " 發送郵件失敗!" + "\"}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }