protected void btnExport_Click(object sender, EventArgs e) { messageContent.InnerHtml = ""; _pushEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _pushEntity.LogMessages.Userid = UserSession.Current.UserAccount; _pushEntity.LogMessages.Username = UserSession.Current.UserDspName; _pushEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _pushEntity.PushDBEntity = new List<PushDBEntity>(); PushDBEntity pushEntity = new PushDBEntity(); pushEntity.ID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["TaskID"].ToString())) ? null : ViewState["TaskID"].ToString(); pushEntity.TelPhone = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["TelPhone"].ToString())) ? null : ViewState["TelPhone"].ToString(); _pushEntity.PushDBEntity.Add(pushEntity); DataSet dsResult = PushBP.ExportPushActionHistoryList(_pushEntity).QueryResult; CommonFunction.ExportExcelForLM(dsResult); }
protected void btnRefush_Click(object sender, EventArgs e) { _pushEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _pushEntity.LogMessages.Userid = UserSession.Current.UserAccount; _pushEntity.LogMessages.Username = UserSession.Current.UserDspName; _pushEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _pushEntity.PushDBEntity = new List<PushDBEntity>(); PushDBEntity pushEntity = new PushDBEntity(); pushEntity.ID = hidTaskID.Value.Trim(); _pushEntity.PushDBEntity.Add(pushEntity); DataSet dsResult = PushBP.SelectPushInfoSuccCount(_pushEntity).QueryResult; decimal decPushSucNum = 0; if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0 && !String.IsNullOrEmpty(dsResult.Tables[0].Rows[0]["Suc_Count"].ToString())) { decPushSucNum = decimal.Parse(dsResult.Tables[0].Rows[0]["Suc_Count"].ToString().Trim()); } decimal decPushAllNum = String.IsNullOrEmpty(lbPushAllNum.Text) ? 0 : decimal.Parse(lbPushAllNum.Text); string strStatus = dsResult.Tables[0].Rows[0]["Status"].ToString(); //if (decPushSucNum < decPushAllNum) if (!"3".Equals(strStatus)) { hidMsg.Value = "Push发送中..." + decPushSucNum.ToString() + "/" + lbPushAllNum.Text; //lblRemainSecond.Text = "5"; hidRemainSecond.Value = (ConfigurationManager.AppSettings["PushRemainSecond"] != null) ? ConfigurationManager.AppSettings["PushRemainSecond"].ToString() : "20"; //this.Page.RegisterStartupScript("remaintimebtn0", "<script>setInterval('RemainTimeBtn()',1000);</script>"); //执行定时执行 } else { //hidMsg.Value = "数据加载中,请稍等..."; //hidRemainSecond.Value = "0"; //this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true); //UpdatePanel2.Update(); //BindReviewLmListGrid(); Response.Redirect(Request.Url.ToString()); } }
private string GetPushAllCount() { PushEntity pushEntityMaster = new PushEntity(); pushEntityMaster.LogMessages = new HotelVp.Common.Logger.LogMessage(); _commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); pushEntityMaster.LogMessages.Userid = UserSession.Current.UserAccount; pushEntityMaster.LogMessages.Username = UserSession.Current.UserDspName; pushEntityMaster.LogMessages.IpAddress = UserSession.Current.UserIP; pushEntityMaster.PushDBEntity = new List<PushDBEntity>(); PushDBEntity pushEntity = new PushDBEntity(); pushEntity.Type = hidPushType.Value.Trim(); pushEntity.UserGroupList = hidUserGroupList.Value.Trim(); pushEntityMaster.PushDBEntity.Add(pushEntity); if ("0".Equals(hidPushType.Value)) { pushEntityMaster = PushBP.SelectPushInfoAllUsersCount(pushEntityMaster); if (pushEntityMaster.QueryResult.Tables.Count > 0 && pushEntityMaster.QueryResult.Tables[0].Rows.Count > 0) { return pushEntityMaster.QueryResult.Tables[0].Rows[0][0].ToString(); } else { return "0"; } } else if ("1".Equals(hidPushType.Value)) { pushEntityMaster = PushBP.SelectPushInfoUserGroupCount(pushEntityMaster); if (pushEntityMaster.QueryResult.Tables.Count > 0 && pushEntityMaster.QueryResult.Tables[0].Rows.Count > 0) { return pushEntityMaster.QueryResult.Tables[0].Rows[0][0].ToString(); } else { return "0"; } } else { return _iAllCount.ToString(); } }
protected void btnSend_Click(object sender, EventArgs e) { //getFileData(); //BindReviewLmListGrid(); //this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnLoadStyle();", true); //System.Diagnostics.Process process = new System.Diagnostics.Process(); //try //{ // process.StartInfo.FileName = @"D:\TFS\HotelVPBackend\CMS\01SRC\JobConsole\HotelVp.JobConsole.DailyOrderSum_Top\HotelVp.JobConsole.DailyOrderSumTop\bin\Debug\HotelVp.JobConsole.DailyOrderSumTop.exe";//文件名必须加后缀。 // process.StartInfo.Arguments = "1"; // process.Start(); //} //catch (Exception exU) //{ // //exU.Message //} //finally //{ // if (!process.HasExited) // { // process.Close(); // process.Dispose(); // } //} //lblRemainSecond.Text = "5"; _pushEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _pushEntity.LogMessages.Userid = UserSession.Current.UserAccount; _pushEntity.LogMessages.Username = UserSession.Current.UserDspName; _pushEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _pushEntity.PushDBEntity = new List<PushDBEntity>(); PushDBEntity pushEntity = new PushDBEntity(); pushEntity.ID = hidTaskID.Value.Trim(); pushEntity.Status = "1"; _pushEntity.PushDBEntity.Add(pushEntity); _pushEntity = PushBP.SendPushInfoMsg(_pushEntity); int iResult = _pushEntity.Result; _commonEntity.LogMessages = _pushEntity.LogMessages; _commonEntity.CommonDBEntity = new List<CommonDBEntity>(); CommonDBEntity commonDBEntity = new CommonDBEntity(); commonDBEntity.Event_Type = "发送Push信息-发送"; commonDBEntity.Event_ID = txtPushTitle.Text.Trim(); string conTent = GetLocalResourceObject("EventSendMessage").ToString(); string strParams = string.Empty; if ("1".Equals(hidPushType.Value)) { strParams = hidUserGroupList.Value.Trim(); } else if ("2".Equals(hidPushType.Value)) { strParams = _strPushProtoType.Trim(); } conTent = string.Format(conTent, hidTaskID.Value, txtPushTitle.Text.Trim(), txtPushContent.Text.Trim(), hidPushType.Value.Trim(), strParams, hidPushActype.Value.Trim()); commonDBEntity.Event_Content = conTent; if (iResult == 1) { //hidTaskID.Value = _pushEntity.PushDBEntity[0].ID; commonDBEntity.Event_Result = GetLocalResourceObject("SendSuccess").ToString(); //messageContent.InnerHtml = GetLocalResourceObject("SendSuccess").ToString(); _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); //BindReviewLmListGrid(); //this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "DvHidChangeEvent();", true); } else if (iResult == 2) { commonDBEntity.Event_Result = GetLocalResourceObject("Error9").ToString(); messageContent.InnerHtml = GetLocalResourceObject("Error9").ToString(); _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "DvHidChangeEvent();", true); return; } else { commonDBEntity.Event_Result = GetLocalResourceObject("Error10").ToString(); messageContent.InnerHtml = GetLocalResourceObject("Error10").ToString(); _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "DvHidChangeEvent();", true); return; } hidMsg.Value = String.Format(GetLocalResourceObject("PushMsg").ToString(), lbPushAllNum.Text); //"Push发送中...0/100"; hidRemainSecond.Value = (ConfigurationManager.AppSettings["PushRemainSecond"] != null) ? ConfigurationManager.AppSettings["PushRemainSecond"].ToString() : "20"; this.Page.RegisterStartupScript("remaintimebtn0", "<script>DvHidChangeEvent();setInterval('RemainTimeBtn()',1000);</script>"); //执行定时执行 }
protected void btnSave_Click(object sender, EventArgs e) { messageContent.InnerHtml = ""; if (String.IsNullOrEmpty(txtPushTitle.Text.Trim())) { messageContent.InnerHtml = GetLocalResourceObject("Error1").ToString(); //"Push任务标题不能为空,请确认!"; this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "DvShChangeEvent();", true); return; } if (String.IsNullOrEmpty(txtPushContent.Text.Trim())) { messageContent.InnerHtml = GetLocalResourceObject("Error2").ToString(); //"Push信息正文不能为空,请确认!"; this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "DvShChangeEvent();", true); return; } if (StringUtility.Text_Length(txtPushContent.Text.Trim()) > 135) { messageContent.InnerHtml = GetLocalResourceObject("Error6").ToString(); //"Push信息正文限制输入50个中文字符,请确认!"; this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "DvShChangeEvent();", true); return; } if ("1".Equals(hidPushActype.Value.Trim()) && (StringUtility.Text_Length(txtPushContent.Text.Trim()) + StringUtility.Text_Length(txtPushTitle.Text.Trim())) > 135) { messageContent.InnerHtml = GetLocalResourceObject("Error11").ToString(); //"Push信息正文限制输入50个中文字符,请确认!"; this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "DvShChangeEvent();", true); return; } else if ("2".Equals(hidPushActype.Value.Trim()) && (StringUtility.Text_Length(txtPushContent.Text.Trim()) + StringUtility.Text_Length(txtPushTitle.Text.Trim()) + StringUtility.Text_Length(txtWapUrl.Text.Trim())) > 135) { messageContent.InnerHtml = GetLocalResourceObject("Error11").ToString(); //"Push信息正文限制输入50个中文字符,请确认!"; this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "DvShChangeEvent();", true); return; } else if ("8".Equals(hidPushActype.Value.Trim()) && (StringUtility.Text_Length(txtPushContent.Text.Trim()) + StringUtility.Text_Length(txtPushTitle.Text.Trim()) + StringUtility.Text_Length(txtPackageCode.Text.Trim())) > 135) { messageContent.InnerHtml = GetLocalResourceObject("Error11").ToString(); //"Push信息正文限制输入50个中文字符,请确认!"; this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "DvShChangeEvent();", true); return; } if ("2".Equals(hidPushActype.Value.Trim()) && String.IsNullOrEmpty(txtWapUrl.Text.Trim())) { messageContent.InnerHtml = GetLocalResourceObject("Error12").ToString(); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "DvShChangeEvent();", true); return; } if ("1".Equals(hidPushType.Value.Trim()) && String.IsNullOrEmpty(hidUserGroupList.Value.Trim())) { messageContent.InnerHtml = GetLocalResourceObject("Error3").ToString(); //"指定用户组不能为空,请确认!"; this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "DvShChangeEvent();", true); return; } else if ("2".Equals(hidPushType.Value.Trim())) { string strResult = getFileData(); if (!String.IsNullOrEmpty(strResult)) { messageContent.InnerHtml = strResult; this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "DvShChangeEvent();", true); return; } } if ("8".Equals(hidPushActype.Value.Trim())) { if (String.IsNullOrEmpty(txtPackageCode.Text.Trim())) { messageContent.InnerHtml = GetLocalResourceObject("Error13").ToString(); ; this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "DvShChangeEvent();", true); return; } } lbPushTitle.Text = txtPushTitle.Text; txtRePushContent.Text = txtPushContent.Text; _pushEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _pushEntity.LogMessages.Userid = UserSession.Current.UserAccount; _pushEntity.LogMessages.Username = UserSession.Current.UserDspName; _pushEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _pushEntity.PushDBEntity = new List<PushDBEntity>(); PushDBEntity pushEntity = new PushDBEntity(); pushEntity.ID = hidTaskID.Value.Trim(); pushEntity.PushType = hidPushActype.Value.Trim(); pushEntity.WapUrl = ("2".Equals(hidPushActype.Value)) ? txtWapUrl.Text.Trim() : ""; pushEntity.Title = txtPushTitle.Text.Trim(); pushEntity.Content = txtPushContent.Text.Trim(); pushEntity.Type = hidPushType.Value.Trim(); pushEntity.UserGroupList = hidUserGroupList.Value.Trim(); _strPushProtoType = ("2".Equals(hidPushType.Value)) ? _strPushProtoType : hidUserGroupList.Value.Trim(); pushEntity.PushProtoType = _strPushProtoType; pushEntity.FilePath = _strFilePath.Trim(); pushEntity.AllCount = GetPushAllCount(); lbPushAllNum.Text = pushEntity.AllCount; pushEntity.TicketPackage = ("8".Equals(hidPushActype.Value)) ? txtPackageCode.Text.Trim() : ""; pushEntity.TicketAmount = ("8".Equals(hidPushActype.Value)) ? hidTicketAmount.Value.Trim() : ""; _pushEntity.PushDBEntity.Add(pushEntity); if (String.IsNullOrEmpty(hidTaskID.Value.Trim())) { _pushEntity = PushBP.PushInsert(_pushEntity); } else { _pushEntity = PushBP.PushUpdate(_pushEntity); } int iResult = _pushEntity.Result; _commonEntity.LogMessages = _pushEntity.LogMessages; _commonEntity.CommonDBEntity = new List<CommonDBEntity>(); CommonDBEntity commonDBEntity = new CommonDBEntity(); commonDBEntity.Event_Type = "发送Push信息-保存"; commonDBEntity.Event_ID = txtPushTitle.Text.Trim(); string conTent = GetLocalResourceObject("EventInsertMessage").ToString(); string strParams = string.Empty; if ("1".Equals(hidPushType.Value)) { strParams = hidUserGroupList.Value.Trim(); } else if ("2".Equals(hidPushType.Value)) { strParams = _strPushProtoType.Trim(); } conTent = string.Format(conTent, txtPushTitle.Text.Trim(), txtPushContent.Text.Trim(), hidPushType.Value.Trim(), strParams, hidPushActype.Value.Trim()); commonDBEntity.Event_Content = conTent; if (iResult == 1) { hidTaskID.Value = _pushEntity.PushDBEntity[0].ID; commonDBEntity.Event_Result = GetLocalResourceObject("InsertSuccess").ToString(); messageContent.InnerHtml = GetLocalResourceObject("InsertSuccess").ToString(); _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); BindReviewLmListGrid(); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "DoSaveEvent();", true); } else if (iResult == 2) { commonDBEntity.Event_Result = GetLocalResourceObject("Error8").ToString(); messageContent.InnerHtml = GetLocalResourceObject("Error8").ToString(); _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "DoSaveEvent();", true); } else { commonDBEntity.Event_Result = GetLocalResourceObject("Error7").ToString(); messageContent.InnerHtml = GetLocalResourceObject("Error7").ToString(); _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "DvShChangeEvent();", true); } //UpdatePanel1.Update(); //UpdatePanel4.Update(); }
private string GetPushActionDateTime() { //messageContent.InnerHtml = ""; _pushEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _pushEntity.LogMessages.Userid = UserSession.Current.UserAccount; _pushEntity.LogMessages.Username = UserSession.Current.UserDspName; _pushEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _pushEntity.PushDBEntity = new List<PushDBEntity>(); PushDBEntity pushEntity = new PushDBEntity(); pushEntity.ID = hidTaskID.Value.Trim(); _pushEntity.PushDBEntity.Add(pushEntity); DataSet dsResult = PushBP.SelectActionDateTime(_pushEntity).QueryResult; if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { return dsResult.Tables[0].Rows[0]["FACTIONDT"].ToString() + " -- " + dsResult.Tables[0].Rows[0]["LACTIONDT"].ToString(); } else { return ""; } }
private void BindReviewMainInfo() { //messageContent.InnerHtml = ""; _pushEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _pushEntity.LogMessages.Userid = UserSession.Current.UserAccount; _pushEntity.LogMessages.Username = UserSession.Current.UserDspName; _pushEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _pushEntity.PushDBEntity = new List<PushDBEntity>(); PushDBEntity pushEntity = new PushDBEntity(); pushEntity.ID = hidTaskID.Value.Trim(); _pushEntity.PushDBEntity.Add(pushEntity); DataSet dsResult = PushBP.SelectPushSuccCount(_pushEntity).QueryResult; if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { txtPushTitle.Text = dsResult.Tables[0].Rows[0]["Push_Title"].ToString(); txtPushContent.Text = dsResult.Tables[0].Rows[0]["Push_Content"].ToString(); hidPushType.Value = dsResult.Tables[0].Rows[0]["Type"].ToString(); string strType = dsResult.Tables[0].Rows[0]["Type"].ToString(); if ("0".Equals(strType)) { lbPushUsers.Text = "所有有效用户"; } else if ("1".Equals(strType)) { lbPushUsers.Text = "用户组: "; } else if ("2".Equals(strType)) { lbPushUsers.Text = "上传Excel列表: "; } string strStatus = string.Empty; switch (dsResult.Tables[0].Rows[0]["Status"].ToString()) { case "0": strStatus = "已保存,未发送"; btnSend.Visible = true; break; case "1": strStatus = "待发送"; btnSend.Visible = false; break; case "2": strStatus = "发送中"; btnSend.Visible = false; break; case "3": strStatus = "已完成"; btnSend.Visible = false; break; default: strStatus = ""; break; } lbPustStatus.Text = strStatus; lbPushUsers.Text = lbPushUsers.Text + dsResult.Tables[0].Rows[0]["Push_ProtoType"].ToString().Trim(',').Trim(); lbPushAction.Text = GetPushActionDateTime(); decimal decAllCount = (String.IsNullOrEmpty(dsResult.Tables[0].Rows[0]["All_Count"].ToString())) ? 0 : decimal.Parse(dsResult.Tables[0].Rows[0]["All_Count"].ToString()); decimal Suc_Count = (String.IsNullOrEmpty(dsResult.Tables[0].Rows[0]["Suc_Count"].ToString())) ? 0 : decimal.Parse(dsResult.Tables[0].Rows[0]["Suc_Count"].ToString()); decimal Err_Count = ("2".Equals(dsResult.Tables[0].Rows[0]["Status"].ToString()) || "3".Equals(dsResult.Tables[0].Rows[0]["Status"].ToString())) ? decAllCount - Suc_Count : 0; hidPushAllNum.Value = decAllCount.ToString(); lbPushCount.Text = "DeviceToken总数:" + dsResult.Tables[0].Rows[0]["All_Count"].ToString() + " 成功发送:" + dsResult.Tables[0].Rows[0]["Suc_Count"].ToString() + " 发送失败:" + Err_Count.ToString(); } else { messageContent.InnerHtml = GetLocalResourceObject("WarningMessage").ToString(); btnExport.Visible = false; btnSearch.Visible = false; btnSend.Visible = false; } }
//private int CountLmSystemLog() //{ // _pushEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); // _pushEntity.LogMessages.Userid = UserSession.Current.UserAccount; // _pushEntity.LogMessages.Username = UserSession.Current.UserDspName; // _pushEntity.LogMessages.IpAddress = UserSession.Current.UserIP; // _pushEntity.FogOrderID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderID"].ToString())) ? null : ViewState["OrderID"].ToString(); // _pushEntity.StartDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["StartDTime"].ToString())) ? null : ViewState["StartDTime"].ToString(); // _pushEntity.EndDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["EndDTime"].ToString())) ? null : ViewState["EndDTime"].ToString(); // _pushEntity.HotelID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["HotelID"].ToString())) ? null : ViewState["HotelID"].ToString(); // _pushEntity.CityID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["CityID"].ToString())) ? null : ViewState["CityID"].ToString(); // _pushEntity.PayCode = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["PayCode"].ToString())) ? null : ViewState["PayCode"].ToString(); // _pushEntity.BookStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["BookStatus"].ToString())) ? null : ViewState["BookStatus"].ToString(); // _pushEntity.PayStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["PayStatus"].ToString())) ? null : ViewState["PayStatus"].ToString(); // _pushEntity.Aprove = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Aprove"].ToString())) ? null : ViewState["Aprove"].ToString(); // _pushEntity.HotelComfirm = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["HotelComfirm"].ToString())) ? null : ViewState["HotelComfirm"].ToString(); // _pushEntity.Ticket = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Ticket"].ToString())) ? null : ViewState["Ticket"].ToString(); // _pushEntity.Mobile = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Mobile"].ToString())) ? null : ViewState["Mobile"].ToString(); // _pushEntity.InStart = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["InStart"].ToString())) ? null : ViewState["InStart"].ToString(); // _pushEntity.InEnd = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["InEnd"].ToString())) ? null : ViewState["InEnd"].ToString(); // _pushEntity.PlatForm = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["PlatForm"].ToString())) ? null : ViewState["PlatForm"].ToString(); // _pushEntity.Sales = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Sales"].ToString())) ? null : ViewState["Sales"].ToString(); // _pushEntity.OutTest = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutTest"].ToString())) ? null : ViewState["OutTest"].ToString(); // _pushEntity.TicketType = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["TicketType"].ToString())) ? null : ViewState["TicketType"].ToString(); // _pushEntity.TicketData = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["TicketData"].ToString())) ? null : ViewState["TicketData"].ToString(); // _pushEntity.TicketPayCode = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["TicketPcode"].ToString())) ? null : ViewState["TicketPcode"].ToString(); // _pushEntity.DashPopStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["DashPopStatus"].ToString())) ? null : ViewState["DashPopStatus"].ToString(); // _pushEntity.DashInStart = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["DashInStart"].ToString())) ? null : ViewState["DashInStart"].ToString(); // _pushEntity.DashInEnd = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["DashInEnd"].ToString())) ? null : ViewState["DashInEnd"].ToString(); // _pushEntity.DashStartDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["DashStartDTime"].ToString())) ? null : ViewState["DashStartDTime"].ToString(); // _pushEntity.DashEndDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["DashEndDTime"].ToString())) ? null : ViewState["DashEndDTime"].ToString(); // DataSet dsResult = PushBP.ReviewLmOrderLogSelectCount(_pushEntity).QueryResult; // if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0 && !String.IsNullOrEmpty(dsResult.Tables[0].Rows[0][0].ToString())) // { // return int.Parse(dsResult.Tables[0].Rows[0][0].ToString()); // } // return 0; //} private void BindReviewLmListGrid() { //messageContent.InnerHtml = ""; _pushEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _pushEntity.LogMessages.Userid = UserSession.Current.UserAccount; _pushEntity.LogMessages.Username = UserSession.Current.UserDspName; _pushEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _pushEntity.PushDBEntity = new List<PushDBEntity>(); PushDBEntity pushEntity = new PushDBEntity(); pushEntity.ID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["TaskID"].ToString())) ? null : ViewState["TaskID"].ToString(); pushEntity.TelPhone = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["TelPhone"].ToString())) ? null : ViewState["TelPhone"].ToString(); _pushEntity.PushDBEntity.Add(pushEntity); _pushEntity.PageCurrent = AspNetPager1.CurrentPageIndex; _pushEntity.PageSize = gridViewCSReviewList.PageSize; //_pushEntity.SortField = gridViewCSReviewList.Attributes["SortExpression"].ToString(); //_pushEntity.SortType = gridViewCSReviewList.Attributes["SortDirection"].ToString(); DataSet dsResult = PushBP.SelectPushActionHistoryList(_pushEntity).QueryResult; gridViewCSReviewList.DataSource = dsResult.Tables[0].DefaultView; gridViewCSReviewList.DataKeyNames = new string[] { "TelPhone" };//主键 gridViewCSReviewList.DataBind(); AspNetPager1.PageSize = gridViewCSReviewList.PageSize; AspNetPager1.RecordCount = _pushEntity.TotalCount; this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true); }
protected void btnSend_Click(object sender, EventArgs e) { _pushEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _pushEntity.LogMessages.Userid = UserSession.Current.UserAccount; _pushEntity.LogMessages.Username = UserSession.Current.UserDspName; _pushEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _pushEntity.PushDBEntity = new List<PushDBEntity>(); PushDBEntity pushEntity = new PushDBEntity(); pushEntity.ID = hidTaskID.Value.Trim(); pushEntity.Status = "1"; _pushEntity.PushDBEntity.Add(pushEntity); _pushEntity = PushBP.SendPushMsg(_pushEntity); int iResult = _pushEntity.Result; _commonEntity.LogMessages = _pushEntity.LogMessages; _commonEntity.CommonDBEntity = new List<CommonDBEntity>(); CommonDBEntity commonDBEntity = new CommonDBEntity(); commonDBEntity.Event_Type = "发送Push信息-发送"; commonDBEntity.Event_ID = txtPushTitle.Text.Trim(); string conTent = GetLocalResourceObject("EventSendMessage").ToString(); conTent = string.Format(conTent, hidTaskID.Value, txtPushTitle.Text.Trim(), txtPushContent.Text.Trim(), hidPushType.Value.Trim()); commonDBEntity.Event_Content = conTent; if (iResult == 1) { commonDBEntity.Event_Result = GetLocalResourceObject("SendSuccess").ToString(); //messageContent.InnerHtml = GetLocalResourceObject("SendSuccess").ToString(); _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); } else if (iResult == 2) { commonDBEntity.Event_Result = GetLocalResourceObject("Error9").ToString(); messageContent.InnerHtml = GetLocalResourceObject("Error9").ToString(); _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); return; } else { commonDBEntity.Event_Result = GetLocalResourceObject("Error10").ToString(); messageContent.InnerHtml = GetLocalResourceObject("Error10").ToString(); _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); return; } hidMsg.Value = String.Format(GetLocalResourceObject("PushMsg").ToString(), hidPushAllNum.Value); //"Push发送中...0/100"; hidRemainSecond.Value = (ConfigurationManager.AppSettings["PushRemainSecond"] != null) ? ConfigurationManager.AppSettings["PushRemainSecond"].ToString() : "20"; this.Page.RegisterStartupScript("remaintimebtn0", "<script>setInterval('RemainTimeBtn()',1000);</script>"); //执行定时执行 }
//点击确定按钮 protected void btnOk_Click(object sender, EventArgs e) { if (this.HidFlowBtn.Value == "1") { #region try { if (!chkCashStatus(ViewState["ID"].ToString())) { this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "alert('该提现申请状态已经更新,请刷新页面!');", true); return; } if (StringUtility.Text_Length(txtRemark.Text.Trim()) > 180) { this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "alert('处理备注最多60个中文字,请修改!');", true); return; } List<string> list = new List<string>(); //<asp:ListItem Value="0">已提交</asp:ListItem> //<asp:ListItem Value="1">已审核</asp:ListItem> //<asp:ListItem Value="2">已成功</asp:ListItem> //<asp:ListItem Value="3">已失败</asp:ListItem> //<asp:ListItem Value="4">已操作</asp:ListItem> //string process_status = this.ddlProcessStatus.SelectedValue; string process_status = this.hidProcessStatus.Value; //点击按钮当前处理的状态 string pickcashamount = this.lbl_pick_cash_amount_bank.Text;//提现金额 string remark = this.txtRemark.Text; string userRemark = this.txtUserRemark.Text; string User_ID = this.lbl_User_ID_bank.Text; string isPush = (chkPush.Checked) ? "1" : "0"; CommonFunction comFun = new CommonFunction(); int id = comFun.getMaxIDfromSeq("T_LM_CASH_HIS_SEQ");//t_lm_cash_tocash_appl_detl_seq string cashWayCode = this.hidCashWayCode_bank.Value; string strNow = string.Format("{0:yyyy-MM-dd HH:mm:ss}", System.DateTime.Now); //修改主表信息,保留最新一次的备注信息 //string sqlUpdate = "update T_LM_CASH_TOCASH_APPL set PROCESS_STATUS='" + process_status + "',PROCESS_REMARK='" + remark + "',PROCESS_TIME =to_timestamp('" + strNow + "','yyyy-mm-dd hh24:mi:ss.ff') ,PROCESS_USERID='" + UserSession.Current.UserAccount + "' where id =" + ViewState["ID"].ToString(); //list.Add(sqlUpdate); ////插入一条新信息到详情表中 //string sqlInsert = "insert into T_LM_CASH_TOCASH_APPL_DETAIL(ID,REF_APPLICATION_ID,USER_ID,HANDLE_STATUS,HANDLE_REMARK,PAY_MODE,HANDLE_TIME,HANDLER) values "; //sqlInsert += "(" + id + ",'" + ViewState["ID"].ToString() + "','" + User_ID + "'," + process_status + ",'" + remark + "','" + cashWayCode + "',to_timestamp('" + strNow + "','yyyy-mm-dd hh24:mi:ss.ff'),'" + UserSession.Current.UserAccount + "' )"; //list.Add(sqlInsert); string sqlUpdate = "update T_LM_CASH set STATUS='" + process_status + "',REMARK='" + userRemark + "',PROCESS_REMARK='" + remark + "',UPDATE_TIME =to_timestamp('" + strNow + "','yyyy-mm-dd hh24:mi:ss.ff') ,PROCESS_USERID='" + UserSession.Current.UserAccount + "',IS_PUSH='" + isPush + "' where (STATUS <> 2 AND STATUS <> 3) AND SN =" + ViewState["ID"].ToString(); list.Add(sqlUpdate); //插入一条新信息到详情表中 if ("4".Equals(process_status)) { string sqlInserthis = "insert into t_lm_cash_his (id, sn, user_id, status, remark, process_userid, create_time, type, is_push) values "; sqlInserthis += "(" + id + ",'" + ViewState["ID"].ToString() + "','" + User_ID + "'," + "1" + ",'" + remark + "','" + UserSession.Current.UserAccount + "',to_timestamp('" + strNow + "','yyyy-mm-dd hh24:mi:ss.ff')," + hidCashType.Value + ",'" + isPush + "')"; list.Add(sqlInserthis); id = comFun.getMaxIDfromSeq("T_LM_CASH_HIS_SEQ");//t_lm_cash_tocash_appl_detl_seq } string sqlInsert = "insert into t_lm_cash_his (id, sn, user_id, status, remark, process_userid, create_time, type, is_push) values "; sqlInsert += "(" + id + ",'" + ViewState["ID"].ToString() + "','" + User_ID + "'," + process_status + ",'" + remark + "','" + UserSession.Current.UserAccount + "',to_timestamp('" + strNow + "','yyyy-mm-dd hh24:mi:ss.ff')," + hidCashType.Value + ",'" + isPush + "')"; list.Add(sqlInsert); //点击“已审核” if (process_status == "3") { string sqlCashUser = "******" + pickcashamount + " where USER_ID='" + User_ID + "'"; list.Add(sqlCashUser); } DbHelperOra.ExecuteSqlTran(list); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "alert('保存成功!');", true); BindLToCash(); setLabelValue(ViewState["ID"].ToString()); if ("1".Equals(isPush)) { PushEntity pushEntity = new PushEntity(); pushEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); pushEntity.LogMessages.Userid = UserSession.Current.UserAccount; pushEntity.LogMessages.Username = UserSession.Current.UserDspName; pushEntity.LogMessages.IpAddress = UserSession.Current.UserIP; pushEntity.PushDBEntity = new List<PushDBEntity>(); PushDBEntity pushDBEntity = new PushDBEntity(); pushDBEntity.ID = ViewState["ID"].ToString(); pushDBEntity.Content = userRemark; pushDBEntity.Type = "6"; pushDBEntity.TelPhone = User_ID; pushEntity.PushDBEntity.Add(pushDBEntity); PushInfoSA.SendPush(pushEntity); } } catch { this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "alert('保存失败!');", true); } #endregion } else { try { if (GetCashBackStatus(ViewState["ID"].ToString()) == "0") { if (!string.IsNullOrEmpty(this.HidPort.Value)) { if (HidPort.Value == "3") { MobilePort_Click(null, null);//手机 } else { AlipayPort_Click(null, null);//支付宝 } } } else { if (GetCashBackStatus(ViewState["ID"].ToString()) == "2") { ScriptManager.RegisterStartupScript(Page, typeof(Page), "fail", "alert('已失败!');", true); } } } catch (Exception ex) { } } ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "alertClose", "BtnCompleteStyle();", true); BindLToCash(); }