public int SelSaveID(Users u) { u.Replace4MySQL(); strSql = string.Format(@"insert into users (user_id,user_email,user_name,user_password,user_mobile,user_phone,user_zip,user_address,user_status,user_reg_date,user_updatedate, user_birthday_year,user_birthday_month,user_birthday_day,user_mobile_bak) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}')", u.user_id, u.user_email, u.user_name, u.user_password, u.user_mobile, u.user_phone, u.user_zip, u.user_address, u.user_status, u.user_reg_date, u.user_updatedate, u.user_birthday_year, u.user_birthday_month, u.user_birthday_day,u.user_mobile); return _accessMySql.execCommand(strSql); }
public List<Users> Query(Users query) { try { StringBuilder sql = new StringBuilder("select user_id,user_email,user_name,user_password,user_mobile,user_phone,user_zip,user_address,user_status,"); sql.Append("user_reg_date,user_updatedate,user_birthday_year,user_birthday_month,user_birthday_day,send_sms_ad from users where 1=1"); if (query.user_id != 0) { sql.AppendFormat(" and user_id={0}", query.user_id); } return _accessMySql.getDataTableForObj<Users>(sql.ToString()); } catch (Exception ex) { throw new Exception("UsersDao.Query(Users query)-->" + ex.Message, ex); } }
public int SelSaveID(Users u) { try { UInt64 user_id = UInt64.Parse(_serialImplMgr.GetSerialById(SERIAL_ID_USER).Serial_Value.ToString()) + 1; _serialImplMgr.Update(new Serial() { Serial_id = SERIAL_ID_USER, Serial_Value = user_id }); u.user_id = user_id; return _usersDao.SelSaveID(u); } catch (Exception ex) { throw new Exception("UsersMgr-->SelSaveID-->" + ex.Message, ex); } }
public List<Users> Query(Users query) { return _usersDao.Query(query); }
public List<Users> GetUser(Users u) { try { return _usersDao.GetUser(u); } catch (Exception ex) { throw new Exception("UsersMgr-->GetUser-->" + ex.Message, ex); } }
public bool SelfThingsMethod( DataTable _dtSms ,OrderDeliver query, string Descriptions) { Description = Descriptions; StringBuilder sb = new StringBuilder(); MySqlCommand mySqlCmd = new MySqlCommand(); MySqlConnection mySqlConn = new MySqlConnection(connStr); 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; sb.AppendFormat(@"select order_id from order_slave where slave_id='{0}';", query.slave_id); mySqlCmd.CommandText = sb.ToString(); string Order_Id = mySqlCmd.ExecuteScalar().ToString();//--訂單編號,後面會用來修改付款單狀態和查詢訂單流水號詳情 sb.Clear(); SerialDao serial = new SerialDao(connStr); sb.AppendFormat(serial.Update(41)); // 出貨單流水號參考自vendor.gigade100.com/order/orerd_deliver.php第226行 sb.Append(@"insert into order_deliver(deliver_id,slave_id,deliver_status,deliver_store,deliver_code,deliver_time,deliver_note"); sb.Append(",deliver_createdate,deliver_updatedate,deliver_ipfrom)value((select serial_value from serial where serial_id=41),"); sb.AppendFormat(" '{0}','{1}','{2}','{3}','{4}',",query.slave_id,1,query.deliver_store,query.deliver_code,query.deliver_time); sb.AppendFormat(" '{0}','{1}',", query.deliver_note, CommonFunction.GetPHPTime(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"))); sb.AppendFormat(" '{0}','{1}');", CommonFunction.GetPHPTime(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")), query.deliver_ipfrom); mySqlCmd.CommandText = sb.ToString(); mySqlCmd.ExecuteNonQuery(); sb.Clear(); int[] Product_Mode = { 1 }; //參考自vendor.gigade100.com/order/orerd_deliver.php第246行 sb.Append(update_detail_for_product_mode(query.slave_id.ToString(), Product_Mode,query.deliver_time)); mySqlCmd.CommandText = sb.ToString(); mySqlCmd.ExecuteNonQuery(); sb.Clear(); //參考自vendor.gigade100.com/order/orerd_deliver.php第252行 string Modify_Master_Order_Status = check_vendor_deliver_order_master_status(Order_Id); if (Modify_Master_Order_Status == "false")//參考自(vendor.gigade100.com/order/order_deliver.php第253行方法) { mySqlCmd.Transaction.Rollback(); } // 修改付款單狀態參考自(vendor.gigade100.com/order/order_deliver.php第259行方法) sb.Append(modify_order_master_status(Order_Id, Modify_Master_Order_Status)); mySqlCmd.CommandText = sb.ToString(); mySqlCmd.ExecuteNonQuery(); sb.Clear(); // 新增付款單狀態參考自(vendor.gigade100.com/order/order_deliver.php第263行方法) sb.Append(order_master_status_record(Order_Id, Modify_Master_Order_Status,Descriptions)); mySqlCmd.CommandText = sb.ToString(); mySqlCmd.ExecuteNonQuery(); sb.Clear(); // 異動商品明細狀態為已出貨態 參考自(vendor.gigade100.com/order/order_deliver.php第266行方法) //簡訊通知 //參考自(vendor.gigade100.com/order/order_deliver.php第269行方法) List<OrderDetailQuery> OrderDetailList=new List<OrderDetailQuery>(); sb.AppendFormat(@"select item_id,product_name from order_detail where slave_id='{0}';", query.slave_id); OrderDetailList = _dbAccess.getDataTableForObj<OrderDetailQuery>(sb.ToString()); sb.Clear(); //參考自(vendor.gigade100.com/order/order_deliver.php第281行方法) sb.AppendFormat(@"select delivery_mobile from order_master where order_id='{0}';", Order_Id); OrderMaster ordermaster = new OrderMaster(); ordermaster=_dbAccess.getSinggleObj<OrderMaster>(sb.ToString()); sb.Clear(); foreach (var item in OrderDetailList) {//參考自(vendor.gigade100.com/order/order_deliver.php第276行方法) DataRow[] rows = _dtSms.Select("sms_id='" + item.Item_Id + "'"); foreach (DataRow row in rows)//篩選出的最多只有一條數據, { if (!string.IsNullOrEmpty(row["sms_id"].ToString())) { string content = "您好,您所訂購的商品 " + item.Product_Name + " 已於今天送出,到貨前會由宅配人員與您確認到貨時段, 謝謝您.吉甲地"; sb.AppendFormat(@"insert into sms(type,order_id,mobile,subject,content,estimated_send_time)value(4,'{0}',", Order_Id); sb.AppendFormat(" '{0}','','{1}','{2}');", ordermaster.Delivery_Mobile, content, "00-00-00 00:00:00"); mySqlCmd.CommandText = sb.ToString(); mySqlCmd.ExecuteNonQuery(); sb.Clear(); break; } } } //---------------------------------------------這個PHP傳入的是Slave_id那個是錯誤的,但是我先傳入Order_id以便實現現在的功能 #region 參考自(vendor.gigade100.com/order/order_deliver.php第364行方法) sb.AppendFormat(@"select user_id,order_name from order_master where order_id='{0}';", Order_Id); ordermaster = _dbAccess.getSinggleObj<OrderMaster>(sb.ToString()); sb.Clear(); sb.AppendFormat(@"select user_email from users where user_id='{0}';", ordermaster.user_id); Users user = new Users(); user = _dbAccess.getSinggleObj<Users>(sb.ToString()); sb.Clear(); // $aParamenter['s_username'] = $sOrder_Username;-----------------ordermaster.Order_Name; //$aParamenter['s_deliver_time'] = $sDeliver_Time;-----------------query.deliver_time //$aParamenter['s_deliver_store'] = $aLang['Deliver_Store'][$nDeliver_Store];----------------地圖,需要查詢 //$aParamenter['s_deliver_code'] = $sDeliver_Code;-------------------query.deliver_code //$sFrom_Name = $amego_config->get_single_config('system_mail_from_name'); //$sFrom_Email = $amego_config->get_single_config('system_mail_from_email'); //$sMailer_Root = MAIL_TEMPLATE_ROOT; Config conf = new Config(); sb.AppendFormat(@"select *from config where config_name='system_mail_from_name';"); conf = _dbAccess.getSinggleObj<Config>(sb.ToString()); sb.Clear(); string From_Name = conf.config_value;//--------------------有了 sb.AppendFormat(@"select *from config where config_name='system_mail_from_email';"); conf = _dbAccess.getSinggleObj<Config>(sb.ToString()); sb.Clear(); string From_Email = conf.config_value;//--------------------有了 //出貨單通知信_新增 int Mailer_Number = 406; //----------------------------------下面的不知道怎麼賦值啊!! string Mailer_Root = "";////define('MAIL_TEMPLATE_ROOT', GIGADE_WWW_DIR . '/mailer/'); // 郵件版型位置,在各實體目錄中的相對位置 #endregion mySqlCmd.Transaction.Rollback(); return true; } catch (Exception ex) { mySqlCmd.Transaction.Rollback(); throw new Exception("OrderDao.SelfThingsMethod -->" + ex.Message + sb.ToString(), ex); } finally { if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Open) { mySqlConn.Close(); } } }
public HttpResponseBase GetUserInfo() { string json = "{success:false}"; try { int type = 0; int related_id = 0; string urlType = string.Empty; int totalCount = 0; int info_id = 0; string info_type = string.Empty; if (!string.IsNullOrEmpty(Request.Params["relatedID"])) { related_id = Convert.ToInt32(Request.Params["relatedID"].ToString());//表主鍵欄位 } if (!string.IsNullOrEmpty(Request.Params["type"])) { type = Convert.ToInt32(Request.Params["type"].ToString());//secret_type,表某一模塊 } if (!string.IsNullOrEmpty(Request.Params["urlType"]))//url地址 { urlType = Request.Params["urlType"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["info_id"])) { info_id = Convert.ToInt32(Request.Params["info_id"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["info_type"])) { info_type = Request.Params["info_type"].ToString(); } switch (info_type)//1.會員查詢頁面2.訂單內容3.簡訊查詢4.聯絡客服列表 { case "users": UsersMgr _usermgr = new UsersMgr(mySqlConnectionString); Users u = new Users(); Users uModel = _usermgr.GetUser(new Users { user_id = Convert.ToUInt32(info_id) }).FirstOrDefault(); if (uModel != null) { if (!string.IsNullOrEmpty(uModel.user_mobile)) { if (!CommonFunction.isMobile(uModel.user_mobile)) { if (uModel.user_mobile.ToString().Length == 48) { uModel.user_mobile = EncryptComputer.EncryptDecryptTextByApi(uModel.user_mobile, false); if (!CommonFunction.isMobile(uModel.user_mobile)) { //異常記錄 Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("表名:{0},編號:{1},行動電話:{2},Message:{3}", "users", uModel.user_id, uModel.user_mobile, "行動電話解密后不滿足正則表達式"); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } } else { //異常記錄 Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("表名:{0},編號:{1},行動電話:{2},Message:{3}", "users", uModel.user_id, uModel.user_mobile, "行動電話錯誤"); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } } } } json = "{success:true,\"user_id\":\"" + uModel.user_id + "\",\"user_name\":\"" + uModel.user_name + "\",\"user_email\":\"" + uModel.user_email + "\",\"user_mobile\":\"" + uModel.user_mobile + "\",\"user_adress\":\"" + uModel.user_address + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; case "trial_share": TrialRecordMgr _recordMgr = new TrialRecordMgr(mySqlConnectionString); TrialShare tModel = _recordMgr.GetTrialShare(new TrialShare { share_id = related_id, user_id = info_id }); json = "{success:true,\"user_id\":\"" + tModel.user_id + "\",\"user_name\":\"" + tModel.user_name + "\"}"; break; case "manager_user": ManageUserMgr _muMgr = new ManageUserMgr(mySqlConnectionString); ManageUser muModel = _muMgr.GetManageUser(new ManageUser { user_id = Convert.ToUInt32(info_id) }).FirstOrDefault(); json = "{success:true,\"user_id\":\"" + muModel.user_id + "\",\"user_name\":\"" + muModel.user_username + "\",\"user_email\":\"" + muModel.user_email + "\"}"; break; case "vip_user": VipUserMgr vipusersMgr = new VipUserMgr(mySqlConnectionString); VipUser model = vipusersMgr.GetSingleByID(related_id); json = "{success:true,\"v_id\":\"" + model.v_id + "\",\"user_id\":\"" + model.user_id + "\",\"user_email\":\"" + model.user_email + "\"}"; break; case "edm_group_email": EdmGroupEmailMgr edmgroupmailMgr = new EdmGroupEmailMgr(mySqlConnectionString); EdmGroupEmailQuery egemodel = edmgroupmailMgr.GetModel(new EdmGroupEmail { email_id = Convert.ToUInt32(related_id), group_id = Convert.ToUInt32(info_id) }).FirstOrDefault(); json = "{success:true,\"user_id\":\"" + egemodel.email_id + "\",\"user_name\":\"" + egemodel.email_name + "\",\"user_email\":\"" + egemodel.email_address + "\"}"; break; case "edm_test": EdmTestMgr edmtestMgr = new EdmTestMgr(mySqlConnectionString); EdmTestQuery etmodel = edmtestMgr.GetModel(new EdmTestQuery { email_id = Convert.ToUInt32(related_id) }).FirstOrDefault(); json = "{success:true,\"user_id\":\"" + etmodel.email_id + "\",\"user_name\":\"" + etmodel.test_username + "\",\"user_email\":\"" + etmodel.email_address + "\"}"; break; case "order_master": OrderMasterMgr omMgr = new OrderMasterMgr(mySqlConnectionString); zMgr = new ZipMgr(mySqlConnectionString); DataTable dt = omMgr.GetOrderidAndName(related_id); json = "{success:true,\"order_id\":\"" + dt.Rows[0][0] + "\",\"order_name\":\"" + dt.Rows[0][1] + "\",\"order_phone\":\"" + dt.Rows[0][2] + "\",\"order_mobile\":\"" + dt.Rows[0][3] + "\",\"order_address\":\"" + zMgr.Getaddress(int.Parse(dt.Rows[0][9].ToString())) + dt.Rows[0][4] + "\",\"delivery_name\":\"" + dt.Rows[0][5] + "\",\"delivery_phone\":\"" + dt.Rows[0][6] + "\",\"delivery_mobile\":\"" + dt.Rows[0][7] + "\",\"delivery_address\":\"" + zMgr.Getaddress(int.Parse(dt.Rows[0][10].ToString())) + dt.Rows[0][8] + "\"}"; break; case "order_master1": OrderMasterMgr omMgr1 = new OrderMasterMgr(mySqlConnectionString); DataTable dt1 = omMgr1.GetOrderidAndName(related_id); json = "{success:true,\"order_id\":\"" + dt1.Rows[0][0] + "\",\"order_name\":\"" + dt1.Rows[0][1] + "\"}"; break; case "order_payment_hitrust": TabShowMgr OphMgr = new TabShowMgr(mySqlConnectionString); DataTable store = new DataTable(); store = OphMgr.GetOderHitrustDT(related_id); json = "{success:true,\"id\":\"" + store.Rows[0]["id"] + "\",\"pan\":\"" + store.Rows[0]["pan"] + "\",\"bankname\":\"" + store.Rows[0]["bankname"] + "\"}"; break; case "order_payment_nccc": TabShowMgr OpnMgr = new TabShowMgr(mySqlConnectionString); DataTable Opn = new DataTable(); store = OpnMgr.GetNCCC(related_id); json = "{success:true,\"nccc_id\":\"" + Opn.Rows[0]["nccc_id"] + "\",\"nccc_pan\":\"" + Opn.Rows[0]["pan"] + "\",\"nccc_bankname\":\"" + Opn.Rows[0]["bankname"] + "\"}"; break; //case "send_mail": // SendMailMgr sendmailMgr = new SendMailMgr(mySqlConnectionString); // SendMail sendModel = sendmailMgr.GetModel(new SendMail { id = related_id }); // json = "{success:true,\"sender_address\":\"" + sendModel.sender_address + "\",\"sender_name\":\"" + sendModel.sender_name + "\",\"send_type\":\"" + sendModel.send_type // + "\",\"recipient\":\"" + sendModel.recipient + "\",\"recipient_name\":\"" + sendModel.recipient_name // + "\"}"; // break; } switch (type)//1.會員查詢頁面2.訂單內容3.簡訊查詢4.聯絡客服列表 { case 1: if (urlType == "/Member/RecommendMember")//推薦會員中推薦者的信息 { UserRecommendMgr _userrecommendMgr = new UserRecommendMgr(mySqlConnectionString); DataTable _urdtno = _userrecommendMgr.getUserInfo(related_id); if (_urdtno.Rows.Count > 0) { json = "{success:true,\"user_id\":\"" + "" + "\",\"user_name\":\"" + "" + "\",\"user_email\":\"" + "" + "\",\"user_adress\":\"" + "" + "\",\"ur_name\":\"" + _urdtno.Rows[0]["name"] + "\",\"ur_mail\":\"" + _urdtno.Rows[0]["mail"] + "\",\"no_ur_name\":\"" + _urdtno.Rows[0]["user_name"] + "\"}"; } } else if (urlType == "/Member/UserLoginLog")//會員登入記錄 { UserLoginLogMgr _userloginlog = new UserLoginLogMgr(mySqlConnectionString); DataTable _dtull = _userloginlog.GetUserInfo(related_id); if (_dtull.Rows.Count > 0) { json = "{success:true,\"user_id\":\"" + _dtull.Rows[0]["user_id"] + "\",\"user_name\":\"" + _dtull.Rows[0]["user_name"] + "\",\"user_email\":\"" + _dtull.Rows[0]["user_email"] + "\",\"user_adress\":\"" + _dtull.Rows[0]["user_address"] + "\"}"; } } else { UsersListMgr _userMgr = new UsersListMgr(mySqlConnectionString); BLL.gigade.Model.Custom.Users _user = _userMgr.getModel(related_id); if (_user != null) { json = "{success:true,\"user_id\":\"" + _user.user_id + "\",\"user_name\":\"" + _user.user_name + "\",\"user_email\":\"" + _user.user_email + "\",\"user_adress\":\"" + _user.user_address + "\"}"; } } break; case 2: OrderQuestionMgr _IOrderQuesMgr = new OrderQuestionMgr(mySqlConnectionString); DataTable _dtques = _IOrderQuesMgr.GetUserInfo(related_id); if (_dtques.Rows.Count > 0) { json = "{success:true,\"user_id\":\"" + _dtques.Rows[0]["user_id"] + "\",\"user_name\":\"" + _dtques.Rows[0]["user_name"] + "\",\"user_email\":\"" + _dtques.Rows[0]["user_email"] + "\",\"user_adress\":\"" + "" + "\",\"order_id\":\"" + _dtques.Rows[0]["order_id"] + "\"}"; } break; case 3: SmsMgr _ISmsMgr = new SmsMgr(mySqlConnectionString); SmsQuery SmsStore = _ISmsMgr.GetSmsList(new SmsQuery { id = related_id }, out totalCount).FirstOrDefault(); if (SmsStore != null) { json = "{success:true,\"user_id\":\"" + "" + "\",\"user_name\":\"" + "" + "\",\"user_email\":\"" + "" + "\",\"user_mobile\":\"" + SmsStore.mobile + "\",\"user_adress\":\"" + "" + "\"}"; } break; case 4: ContactUsQuestionMgr _ctactMgr = new ContactUsQuestionMgr(mySqlConnectionString); DataTable _dt = _ctactMgr.GetUserInfo(related_id); if (_dt.Rows.Count > 0) { json = "{success:true,\"user_id\":\"" + _dt.Rows[0]["user_id"] + "\",\"user_name\":\"" + _dt.Rows[0]["user_name"] + "\",\"user_email\":\"" + _dt.Rows[0]["user_email"] + "\",\"user_adress\":\"" + "" + "\"}"; } break; case 7://供應商詳情 VendorQuery _dtven = null; if (urlType == "/Vendor/VendorBrandList") { VendorBrandSetMgr _IvendorBrandSet = new VendorBrandSetMgr(mySqlConnectionString); VendorBrandSetQuery query = _IvendorBrandSet.GetModelById(related_id); VendorMgr _vendorMgr = new VendorMgr(mySqlConnectionString); _dtven = _vendorMgr.Query(new VendorQuery { vendor_id = query.vendor_id, IsPage = false }, ref totalCount).FirstOrDefault(); if (_dtven != null) { json = "{success:true,\"user_id\":\"" + "" + "\",\"user_name\":\"" + _dtven.vendor_name_full + "\",\"user_email\":\"" + "" + "\",\"user_phone\":\"" + "" + "\",\"user_adress\":\"" + "" + "\",\"simple_name\":\"" + _dtven.vendor_name_simple + "\"}"; } } else if (urlType == "/Vendor/VendorLoginList") { VendorLoginListMgr _Ivendorloginlist = new VendorLoginListMgr(mySqlConnectionString); VendorLoginQuery query = _Ivendorloginlist.Query(new VendorLoginQuery { login_id = Convert.ToUInt32(related_id), IsPage = false }, out totalCount).FirstOrDefault(); VendorMgr _vendorMgr = new VendorMgr(mySqlConnectionString); _dtven = _vendorMgr.Query(new VendorQuery { vendor_id = query.vendor_id, IsPage = false }, ref totalCount).FirstOrDefault(); if (_dtven != null) { json = "{success:true,\"user_id\":\"" + _dtven.vendor_code + "\",\"user_name\":\"" + _dtven.vendor_name_full + "\",\"user_email\":\"" + "" + "\",\"user_phone\":\"" + "" + "\",\"user_adress\":\"" + "" + "\",\"simple_name\":\"" + _dtven.vendor_name_simple + "\"}"; } } else { VendorMgr _vendorMgr = new VendorMgr(mySqlConnectionString); _dtven = _vendorMgr.Query(new VendorQuery { vendor_id = Convert.ToUInt32(related_id), IsPage = false }, ref totalCount).FirstOrDefault(); if (_dtven != null) { json = "{success:true,\"user_id\":\"" + _dtven.vendor_code + "\",\"user_name\":\"" + _dtven.vendor_name_full + "\",\"user_email\":\"" + _dtven.vendor_email + "\",\"user_phone\":\"" + "" + "\",\"user_adress\":\"" + _dtven.vendor_company_address + "\",\"simple_name\":\"" + _dtven.vendor_name_simple + "\"}"; } } break; case 9: MailUserMgr _IMailUserMgr = new MailUserMgr(mySqlConnectionString); DataTable _dtmu = _IMailUserMgr.GetUserInfo(related_id); if (_dtmu.Rows.Count > 0) { json = "{success:true,\"user_id\":\"" + _dtmu.Rows[0]["user_id"] + "\",\"user_name\":\"" + _dtmu.Rows[0]["user_name"] + "\",\"user_email\":\"" + _dtmu.Rows[0]["user_email"] + "\",\"user_adress\":\"" + _dtmu.Rows[0]["user_address"] + "\"}"; } break; case 10: PaperAnswerMgr _paperAnswerMgr = new PaperAnswerMgr(mySqlConnectionString); PaperAnswer store = _paperAnswerMgr.GetPaperAnswerList(new PaperAnswer { answerID = related_id, IsPage = false }, out totalCount).FirstOrDefault(); if (store != null) { json = "{success:true,\"user_id\":\"" + store.userid + "\",\"user_name\":\"" + "" + "\",\"user_email\":\"" + store.userMail + "\",\"user_phone\":\"" + "" + "\",\"user_adress\":\"" + "" + "\"}"; } break; case 14://會員等級歷程 UserLevelLogMgr _userLevelLog = new UserLevelLogMgr(mySqlConnectionString); // UserLevelLogQuery store UserLevelLogQuery levelStore = _userLevelLog.GetUserLevelLogList(new UserLevelLogQuery { user_id = Convert.ToUInt32(related_id), IsPage = false, isSecret = false }, out totalCount).FirstOrDefault(); if (levelStore != null) { json = "{success:true,\"user_id\":\"" + levelStore.user_id + "\",\"user_name\":\"" + levelStore.user_name + "\",\"user_email\":\"" + levelStore.user_email + "\"}"; } break; case 18://企業會員管理 _vipUserGroup = new VipUserGroupMgr(mySqlConnectionString); VipUserGroupQuery vipStore = _vipUserGroup.GetVipUserGList(new VipUserGroupQuery { group_id = Convert.ToUInt32(related_id), IsPage = false, isSecret = false }, out totalCount).FirstOrDefault(); if (vipStore != null) { json = "{success:true,\"group_committe_chairman\":\"" + vipStore.group_committe_chairman + "\",\"group_committe_phone\":\"" + vipStore.group_committe_phone + "\",\"group_committe_mail\":\"" + vipStore.group_committe_mail + "\"}"; } break; case 19://商品點擊查詢 _IBrowseDataMgr = new BrowseDataMgr(mySqlConnectionString); DataTable _dtBrowse = _IBrowseDataMgr.GetBrowseDataList(new BrowseDataQuery { id = related_id, IsPage = false, isSecret = false }, out totalCount); string user_name = (_dtBrowse.Rows[0]["user_name"].ToString()); string user_id = (_dtBrowse.Rows[0]["user_id"].ToString()); json = "{success:true,\"user_name\":\"" + user_name + "\",\"user_id\":\"" + user_id + "\"}"; break; case 22://聯合信用卡銀行卡號 _tabshow = new TabShowMgr(mySqlConnectionString); // OrderPaymentNcccQuery OPNQuery = new OrderPaymentNcccQuery(); OrderPaymentNcccQuery OPNQuery = _tabshow.GetNCCC(new OrderPaymentNcccQuery { nccc_id = (uint)related_id, IsPage = false, isSecret = false }, out totalCount).FirstOrDefault(); json = "{success:true,\"nccc_id\":\"" + OPNQuery.nccc_id + "\",\"nccc_pan\":\"" + OPNQuery.pan + "\",\"nccc_bankname\":\"" + OPNQuery.bankname + "\"}"; break; case 23://退貨 _orderReturnStatus = new OrderReturnStatusMgr(mySqlConnectionString); OrderMaster om = _orderReturnStatus.GetOrderInfo(Convert.ToUInt32(related_id)); json = "{success:true,\"orc_name\":\"" + om.Delivery_Name + "\",\"orc_mobile\":\"" + om.Delivery_Mobile + "\",\"orc_address\":\"" + om.Delivery_Address + "\"}"; break; } } 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 = "{success:false}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase GetUserName() { Users user = new Users(); if (!string.IsNullOrEmpty(Request.Params["user_id"])) { user.user_id = ulong.Parse(Request.Params["user_id"]); } _usersMgr = new UsersMgr(mySqlConnectionString); string jsonStr =string.Empty; try { List<Users> userList = new List<Users>(); userList = _usersMgr.GetUser(user); if (userList.Count > 0) { jsonStr = "{success:true,msg:\"" + userList[0].user_name + "\"}"; } else { jsonStr = "{success:true,msg:\"" +100+ "\"}"; } } 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); jsonStr = "{success:false}"; } this.Response.Clear(); this.Response.Write(jsonStr); this.Response.End(); return this.Response; }
public HttpResponseBase GetUserName() { List<Users> store = new List<Users>(); string json = "{success:true,msg:'0'}"; try { Users query = new Users(); _uMgr = new UsersMgr(mySqlConnectionString); if (!string.IsNullOrEmpty(Request.Params["id"])) { query.user_id = Convert.ToUInt32(Request.Params["id"]); } if (query.user_id > 0) { store = _uMgr.GetUser(query); foreach (var item in store) { json = "{success:true,msg:'" + item.user_name + "'}";//返回json數據 } } else { json = "{success:true,msg:'0'}";//返回json數據 } } 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 = "{success:false}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public List<Users> GetUser(Users u) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat("SELECT user_id,user_name,user_email,user_phone,user_mobile,user_address from users WHERE user_id='{0}';", u.user_id); return _accessMySql.getDataTableForObj<Users>(sql.ToString()); } catch (Exception ex) { throw new Exception("UsersDao.List<Users> GetUser(Users query)-->" + ex.Message, ex); } }