/// <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);
}
}
