/// <summary> /// 获取jsapi_ticket /// </summary> /// <returns></returns> public static string GetJsapiTicket() { string accessToken = GetAccessToken(); string key = "jsapi_ticket"; if (CacheExtend.HasCache(key)) { return(CacheExtend.GetCache <JsapiTicket>(key).ticket); } lock (_lock) { if (CacheExtend.HasCache(key)) { return(CacheExtend.GetCache <JsapiTicket>(key).ticket); } JsapiTicket ticket = null; try { LogHelper.WriteLog("GetJsapiTicket-accessToken:" + accessToken); HttpWebRequest req = (HttpWebRequest)HttpWebRequest.Create(string.Format("https://api.weixin.qq.com/cgi-bin/ticket/getticket?access_token={0}&type=jsapi", accessToken)); req.Method = "GET"; using (WebResponse wr = req.GetResponse()) { HttpWebResponse myResponse = (HttpWebResponse)req.GetResponse(); StreamReader reader = new StreamReader(myResponse.GetResponseStream(), Encoding.UTF8); string content = reader.ReadToEnd(); LogHelper.WriteLog("content:" + content); if (!string.IsNullOrEmpty(content)) { ticket = JsonHelper.JsonToObject <JsapiTicket>(content); if (ticket != null) { LogHelper.WriteLog("ticket:" + ticket.ticket); //LogHelper.WriteLog("jsapi_ticket插入缓存,jsapi_ticket有效期为:" + (ticket.expires_in - 1800).ToString()); CacheExtend.CacheInsert(key, ticket, DateTime.Now.AddSeconds(ticket.expires_in - 1800)); } else { LogHelper.WriteLog(ErrorManage.GetErrorInfo(ticket.errcode ?? -1)); } } else { LogHelper.WriteLog("jsapi_ticket 返回的值为NULL"); } } } catch (Exception ex) { LogHelper.WriteLog(string.Format("{0}\n{1}\n{2}\n", ex.Message, ex.Source, ex.StackTrace)); } return(ticket == null ? "" : ticket.ticket); } }
protected void btnBack_Click(object sender, EventArgs e) { try { Response.Redirect("./FrmUserInputBrige.aspx"); } catch (Exception ex) { ErrorManage.Show(ex.ToString()); } }
//儲存表單 protected void btnSave_Click(object sender, EventArgs e) { try { List <TB_Report> lRe = GetMainReport(); string OrIDFromMainRe = lRe.FirstOrDefault().OrderReID; using (var en = new WeekReportEntities()) { TB_OrderReport Order = en.TB_OrderReport.Where(p => p.OrderReID == OrIDFromMainRe).FirstOrDefault(); if (Order == null) { en.TB_OrderReport.Add(new TB_OrderReport { OrderReID = OrIDFromMainRe, OrderedCount = int.Parse(txtOrderCount.Text), SaleCount = int.Parse(txtSaleCount.Text), OnControl = int.Parse(txtOnControl.Text), Expectations = int.Parse(txtExpectation.Text), OrderDetail = txtOrderDetail.Text, WeekCar = txtWeekCar.Text, UnorderDetail = txtUnOrderDetail.Text, Others = txtOthers.Text, SelfNumber = int.Parse(txtSelfnumber.Text) }); en.SaveChanges(); } else { Order.OrderedCount = int.Parse(txtOrderCount.Text); Order.SaleCount = int.Parse(txtSaleCount.Text); Order.OnControl = int.Parse(txtOnControl.Text); Order.Expectations = int.Parse(txtExpectation.Text); Order.OrderDetail = txtOrderDetail.Text; Order.WeekCar = txtWeekCar.Text; Order.UnorderDetail = txtUnOrderDetail.Text; Order.Others = txtOthers.Text; Order.SelfNumber = int.Parse(txtSelfnumber.Text); en.SaveChanges(); } this.LoadReportData(); } } catch (Exception ex) { ErrorManage.Show(ex.ToString()); } }
protected void btnSave_Click(object sender, EventArgs e) { try { using (var en = new WeekReportEntities()) { TB_Report ReMain = Tool.GetNowReport((TB_User)Session[GlobalInfo.Session_User]).FirstOrDefault(); TB_CarAssRe CarAssRe = en.TB_CarAssRe.Where(p => p.CarAssReID == ReMain.CarAssReID).FirstOrDefault(); if (CarAssRe != null) { CarAssRe.RefinementNum = Convert.ToInt32(txtRefinementNum.Text); CarAssRe.VAudioNum = Convert.ToInt32(txtVAudioNum.Text); CarAssRe.RefineDetail = txtRefineDetail.Text; CarAssRe.AssProNum = Convert.ToInt32(txtAssProNum.Text); CarAssRe.PDSProNum = Convert.ToInt32(txtPDSProNum.Text); CarAssRe.OthersProDetail = txtOtherProDetail.Text; CarAssRe.SelfNumber = Convert.ToInt32(txtSelfNum.Text); en.SaveChanges(); } else { en.TB_CarAssRe.Add(new TB_CarAssRe { CarAssReID = ReMain.CarAssReID, RefinementNum = Convert.ToInt32(txtRefinementNum.Text), VAudioNum = Convert.ToInt32(txtVAudioNum.Text), RefineDetail = txtRefineDetail.Text, AssProNum = Convert.ToInt32(txtAssProNum.Text), PDSProNum = Convert.ToInt32(txtPDSProNum.Text), OthersProDetail = txtOtherProDetail.Text, SelfNumber = Convert.ToInt32(txtSelfNum.Text) }); en.SaveChanges(); } LoadReportData(); } } catch (Exception ex) { ErrorManage.Show(ex.ToString()); } }
protected void btnSave_Click(object sender, EventArgs e) { try { using (var en = new WeekReportEntities()) { TB_Report ReMain = Tool.GetNowReport((TB_User)Session[GlobalInfo.Session_User]).FirstOrDefault(); TB_HumanRe HumanRe = en.TB_HumanRe.Where(p => p.HumanResourceReID == ReMain.HumanManageReID).FirstOrDefault(); if (HumanRe == null) { en.TB_HumanRe.Add(new TB_HumanRe { HumanResourceReID = ReMain.HumanManageReID, PeopleNeed = Convert.ToInt32(txtHumanLess.Text), Interview = Convert.ToInt32(txtInterview.Text), NewEmpDetail = txtObservation.Text, SpecialEmp = txtWeekPeople.Text, WeekGoodEmp = txtGoodSales.Text, SelfNumber = Convert.ToInt32(txtSelfNumber.Text) }); en.SaveChanges(); } else { HumanRe.PeopleNeed = Convert.ToInt32(txtHumanLess.Text); HumanRe.Interview = Convert.ToInt32(txtInterview.Text); HumanRe.NewEmpDetail = txtObservation.Text; HumanRe.SpecialEmp = txtWeekPeople.Text; HumanRe.WeekGoodEmp = txtGoodSales.Text; HumanRe.SelfNumber = Convert.ToInt32(txtSelfNumber.Text); en.SaveChanges(); } } } catch (Exception ex) { ErrorManage.Show(ex.ToString()); } }
/// <summary> /// 获取AccessToken /// </summary> /// <returns></returns> public static string GetAccessToken() { string key = "AccessToken"; AccessToken token = null; try { HttpWebRequest req = (HttpWebRequest)HttpWebRequest.Create(string.Format("https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid={0}&secret={1}", appid, secret)); req.Method = "GET"; using (WebResponse wr = req.GetResponse()) { HttpWebResponse myResponse = (HttpWebResponse)req.GetResponse(); StreamReader reader = new StreamReader(myResponse.GetResponseStream(), Encoding.UTF8); string content = reader.ReadToEnd(); if (!string.IsNullOrEmpty(content)) { token = JsonHelper.JsonToObject <AccessToken>(content); if (token != null) { //LogHelper.WriteLog("Token插入缓存,Token有效期为:" + (token.expires_in - 1800).ToString()); CacheExtend.CacheInsert(key, token, DateTime.Now.AddSeconds(token.expires_in - 1800)); } else { LogHelper.WriteLog(ErrorManage.GetErrorInfo(token.errcode ?? -1)); } } else { LogHelper.WriteLog("Token 返回的值为NULL"); } } } catch (Exception ex) { LogHelper.WriteLog(string.Format("{0}\n{1}\n{2}\n", ex.Message, ex.Source, ex.StackTrace)); } return(token == null ? "" : token.access_token); }
private static string GetMsg(string remsg, ResultCryptography ccg) { if (ccg.HasCrypto()) { string sEncryptMsg = ""; WXBizMsgCrypt wxcpt = new WXBizMsgCrypt(ccg.sToken, ccg.sEncodingAESKey, ccg.sAppID); int ret = 0; ret = wxcpt.EncryptMsg(remsg, ccg.timestamp, ccg.nonce, ref sEncryptMsg); if (ret != 0) { LogHelper.WriteLog("ERR: Encrypt fail:" + ErrorManage.GetErrorInfo(ret)); return(""); } return(sEncryptMsg); } return(remsg); }
//建立一個新的周報表 protected void BtnStartClick(object sender, EventArgs e) { try { TB_User user = ((TB_User)Session[GlobalInfo.Session_User]); using (var en = new WeekReportEntities()) { //新增報表 en.TB_Report.Add(new TB_Report { TimeStart = GetTime0((DateTime)Session[GlobalInfo.Session_StartTime]), TimeEnd = GetTime1((DateTime)Session[GlobalInfo.Session_EndTime]), Bureau = user.Bureau, Class = user.Class, Writer = user.name, //給編號 所別+課別+起始日 OrderReID = user.Bureau + user.Class + "Or" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Replace("-", "").Replace(":", ""), InsurenceReID = user.Bureau + user.Class + "In" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Replace("-", "").Replace(":", ""), OldCarSaleReID = user.Bureau + user.Class + "Ol" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Replace("-", "").Replace(":", ""), CarAssReID = user.Bureau + user.Class + "Ca" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Replace("-", "").Replace(":", ""), HumanManageReID = user.Bureau + user.Class + "Hu" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Replace("-", "").Replace(":", "") }); en.SaveChanges(); } if (CheckExist()) { btnStart.Enabled = false; btnCa.Enabled = true; btnHu.Enabled = true; btnIn.Enabled = true; btnOl.Enabled = true; btnOr.Enabled = true; } } catch (Exception ex) { ErrorManage.Show(ex.ToString()); } }
/// <summary> /// update user information, also use for insert a new user /// </summary> /// <param name="newUser"></param> internal void Update(UserClass newUser) { SqlCommand cmd; UserClass user = new UserClass(); using (SqlConnection connection = OpenDataBase()) { cmd = new SqlCommand("select * from UserTable where Email='" + newUser.Email + "'", connection); SqlDataReader dataReader = cmd.ExecuteReader(); try { dataReader.Read(); user = ReadSingleRow(dataReader); } catch (Exception ex) { ErrorManage error = new ErrorManage(); // error.ShowError(ex); throw; } } user.Password = newUser.Password; string insertQuery = ""; if (user.UserID == 0) { insertQuery = "insert into UserTable(UserName, Email, Password, Role) values('" + newUser.UserName + "', '" + newUser.Email + "', '" + newUser.Password + "', '" + newUser.Role + "')"; } else { string cartStatus = newUser.Role ?? "user"; insertQuery = "UPDATE UserTable SET UserName='******', Email='" + user.Email + "', Password='******', Role='" + user.Role + "' WHERE UserID=" + user.UserID; } using (SqlConnection connection = OpenDataBase()) { cmd = new SqlCommand(insertQuery, connection); cmd.ExecuteReader(); } }
//抓出報表主檔 public List <TB_Report> GetMainReport() { using (var en = new WeekReportEntities()) { TB_User user = ((TB_User)Session[GlobalInfo.Session_User]); //end必須從新設定 List <TB_Report> data = (from q in en.TB_Report where q.Bureau == user.Bureau && q.Class == user.Class && q.TimeStart <= DateTime.Now && q.TimeEnd >= DateTime.Now select q).ToList(); //偵錯 if (data.Count() > 1) { ErrorManage.Show("比數大於二有問題"); } return(data); } }
protected void btnSave_Click(object sender, EventArgs e) { try { var lR = GetMainReport().FirstOrDefault(); using (var en = new WeekReportEntities()) { TB_InsurenceRe InReport = en.TB_InsurenceRe.Where(p => p.InsurenceID == lR.InsurenceReID).FirstOrDefault(); if (InReport != null) { InReport.AnyCaseToNow = int.Parse(txtAnyCaseToNow.Text); InReport.CarBdCaseToNow = int.Parse(txtCarBdCaseToNow.Text); InReport.MoneyToNow = int.Parse(txtMoneyToNow.Text); InReport.AnyCaseSec = int.Parse(txtAnyCaseSec.Text); InReport.WeekTotalBd = int.Parse(txtWeekTotalBd.Text); InReport.MonTotalExR = int.Parse(txtMonTotalExR.Text); InReport.MonAnyExR = int.Parse(txtMonAnyExR.Text); InReport.MonBdExR = int.Parse(txtMonBdExR.Text); InReport.TotalWeekImport = int.Parse(txtImportC.Text); InReport.RefinProject = txtRefineProject.Text; InReport.SelfNumber = int.Parse(txtSelfNumber.Text); en.SaveChanges(); } else { en.TB_InsurenceRe.Add(new TB_InsurenceRe { InsurenceID = lR.InsurenceReID, AnyCaseToNow = int.Parse(txtAnyCaseToNow.Text), CarBdCaseToNow = int.Parse(txtCarBdCaseToNow.Text), MoneyToNow = int.Parse(txtMoneyToNow.Text), AnyCaseSec = int.Parse(txtAnyCaseSec.Text), WeekTotalBd = int.Parse(txtWeekTotalBd.Text), MonTotalExR = int.Parse(txtMonTotalExR.Text), MonAnyExR = int.Parse(txtMonAnyExR.Text), MonBdExR = int.Parse(txtMonBdExR.Text), TotalWeekImport = int.Parse(txtImportC.Text), RefinProject = txtRefineProject.Text, SelfNumber = int.Parse(txtSelfNumber.Text) }); en.SaveChanges(); } this.LoadReportData(); } } catch (Exception ex) { ErrorManage.Show(ex.ToString()); } }
/// <summary> /// 微信回调入口 /// </summary> /// <param name="Request"></param> /// <param name="Response"></param> public static void ReceviceMain(HttpRequestBase Request, HttpResponseBase Response) { try { if (Request.HttpMethod.ToLower() != "post") { Response.End(); } else { Stream s = System.Web.HttpContext.Current.Request.InputStream; byte[] b = new byte[s.Length]; s.Read(b, 0, (int)s.Length); var postStr = Encoding.UTF8.GetString(b); string sMsg = ""; //LogHelper.WriteLog("post结果:" + postStr); var checkgrp = new ResultCryptography() { encrypttype = "raw", timestamp = "", nonce = "", sToken = token, sEncodingAESKey = encodingAESKey, sAppID = appid }; if (Request.QueryString["encrypt_type"] != null && Request.QueryString["encrypt_type"].ToLower() == "aes") { //解密 string sReqMsgSig = Request.QueryString["msg_signature"].ToString(); string sReqTimeStamp = Request.QueryString["timestamp"].ToString(); string sReqNonce = Request.QueryString["nonce"].ToString(); checkgrp.encrypttype = "aes"; checkgrp.timestamp = sReqTimeStamp; checkgrp.nonce = sReqNonce; WXBizMsgCrypt wxcpt = new WXBizMsgCrypt(token, encodingAESKey, appid); int ret = 0; ret = wxcpt.DecryptMsg(sReqMsgSig, sReqTimeStamp, sReqNonce, postStr, ref sMsg); if (ret != 0) { LogHelper.WriteLog("ERR: Decrypt fail:" + ErrorManage.GetErrorInfo(ret)); return; } } else { sMsg = postStr; } var msgModel = XmlHelpler.GetMsg(sMsg); ReceiveMsg.SwitchCase(Response, msgModel, checkgrp); } } catch (Exception ex) { LogHelper.WriteLog("ReceviceMain-" + ex.Message + "," + ex.Source + "," + ex.StackTrace); } }