public static bool CheckUpdate(PushEntity PushEntity)
{
PushDBEntity dbParm = (PushEntity.PushDBEntity.Count > 0) ? PushEntity.PushDBEntity[0] : new PushDBEntity();
DataCommand cmd = DataCommandManager.GetDataCommand("CheckUpdatePushPlanManager");
cmd.SetParameterValue("@TaskID", dbParm.ID);
DataSet dsResult = cmd.ExecuteDataSet();
if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0)
{
return true;
}
else
{
return false;
}
}
public static PushEntity ExportPushActionHistoryList(PushEntity PushEntity)
{
PushDBEntity dbParm = (PushEntity.PushDBEntity.Count > 0) ? PushEntity.PushDBEntity[0] : new PushDBEntity();
DataCommand cmd = DataCommandManager.GetDataCommand("ExportPushActionHistoryList");
cmd.SetParameterValue("@TaskID", dbParm.ID);
if (String.IsNullOrEmpty(dbParm.TelPhone))
{
cmd.SetParameterValue("@TelPhone", DBNull.Value);
}
else
{
cmd.SetParameterValue("@TelPhone", dbParm.TelPhone);
}
PushEntity.QueryResult = cmd.ExecuteDataSet();
return PushEntity;
}
public static PushEntity Insert(PushEntity PushEntity)
{
PushEntity.LogMessages.MsgType = MessageType.INFO;
PushEntity.LogMessages.Content = _nameSpaceClass + "Insert";
LoggerHelper.LogWriter(PushEntity.LogMessages);
try
{
return PushDA.Insert(PushEntity);
}
catch (Exception ex)
{
PushEntity.LogMessages.MsgType = MessageType.ERROR;
PushEntity.LogMessages.Content = _nameSpaceClass + "Insert Error: " + ex.Message;
LoggerHelper.LogWriter(PushEntity.LogMessages);
throw ex;
}
}
public static PushEntity ExportPushInfoActionHistoryList(PushEntity PushEntity)
{
PushEntity.LogMessages.MsgType = MessageType.INFO;
PushEntity.LogMessages.Content = _nameSpaceClass + "ExportPushInfoActionHistoryList";
LoggerHelper.LogWriter(PushEntity.LogMessages);
try
{
return PushDA.ExportPushInfoActionHistoryList(PushEntity);
}
catch (Exception ex)
{
PushEntity.LogMessages.MsgType = MessageType.ERROR;
PushEntity.LogMessages.Content = _nameSpaceClass + "ExportPushInfoActionHistoryList Error: " + ex.Message;
LoggerHelper.LogWriter(PushEntity.LogMessages);
throw ex;
}
}
public static bool CheckInsert(PushEntity PushEntity)
{
OracleParameter[] parm ={
new OracleParameter("TITLE",OracleType.VarChar)
};
PushDBEntity dbParm = (PushEntity.PushDBEntity.Count > 0) ? PushEntity.PushDBEntity[0] : new PushDBEntity();
parm[0].Value = dbParm.Title;
DataSet dsResult = HotelVp.Common.DBUtility.DbManager.Query("Push", "t_lm_promotion_check_insert", false, parm);
if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0)
{
return false;
}
else
{
return true;
}
}
public static PushEntity SendPush(PushEntity pushEntity)
{
string DataString = "";
PushDBEntity dbParm = (pushEntity.PushDBEntity.Count > 0) ? pushEntity.PushDBEntity[0] : new PushDBEntity();
DataSet dsUserInfo = PushDA.GetUserInfo(dbParm.TelPhone);
if (dsUserInfo.Tables.Count == 0 || dsUserInfo.Tables[0].Rows.Count == 0)
{
pushEntity.Result = 0;
pushEntity.ErrorMSG = "发送失败！";
return pushEntity;
}
string strRegChanel = dsUserInfo.Tables[0].Rows[0]["CLIENT_CODE"].ToString().Trim();//(!String.IsNullOrEmpty(dsUserInfo.Tables[0].Rows[0]["regchanel_code"].ToString().Trim()) && ConfigurationManager.AppSettings["MyQueueReg"].ToString().Contains(dsUserInfo.Tables[0].Rows[0]["regchanel_code"].ToString())) ? "HOTELVPPRO" : "HOTELVP";
DataString = "{\"pushDynamicList\":[{\"userId\":\"" + dsUserInfo.Tables[0].Rows[0]["id"].ToString() + "\",\"objLinkId\":\"" + dbParm.ID + "\",\"deviceToken\":\"" + dsUserInfo.Tables[0].Rows[0]["devicetoken"].ToString() + "\",\"useCode\":\"" + dsUserInfo.Tables[0].Rows[0]["platform_code"].ToString() + "\",\"useCodeVersion\":\"" + dsUserInfo.Tables[0].Rows[0]["version"].ToString() + "\",\"clientCode\":\"" + strRegChanel + "\"}],\"title\":\"" + dbParm.Title + "\",\"content\":\"" + dbParm.Content + "\",\"objType\":" + dbParm.Type + ",\"objUrl\":\"\",\"pic\":\"\",\"isPopup\":\"\",\"taskId\":\"" + dbParm.ID + "\",\"endTime\":\"\"}";
QueueHelper.SendMessage(DataString);
pushEntity.Result = 1;
pushEntity.ErrorMSG = "发送成功！";
return pushEntity;
}
public static PushEntity UpdateSendPushStatus(PushEntity PushEntity)
{
if (PushEntity.PushDBEntity.Count == 0)
{
PushEntity.Result = 0;
return PushEntity;
}
if (PushEntity.LogMessages == null)
{
PushEntity.Result = 0;
return PushEntity;
}
if (!CheckUpdate(PushEntity))
{
PushEntity.Result = 2;
return PushEntity;
}
PushDBEntity dbParm = (PushEntity.PushDBEntity.Count > 0) ? PushEntity.PushDBEntity[0] : new PushDBEntity();
DataCommand cmd = DataCommandManager.GetDataCommand("UpdateSendPushStatus");
cmd.SetParameterValue("@TaskID", dbParm.ID);
cmd.SetParameterValue("@Status", dbParm.Status);
cmd.SetParameterValue("@UpdateUser", PushEntity.LogMessages.Username);
cmd.ExecuteNonQuery();
PushEntity.Result = 1;
return PushEntity;
}
public static PushEntity Update(PushEntity PushEntity)
{
if (PushEntity.PushDBEntity.Count == 0)
{
PushEntity.Result = 0;
return PushEntity;
}
if (PushEntity.LogMessages == null)
{
PushEntity.Result = 0;
return PushEntity;
}
if (!CheckUpdate(PushEntity))
{
PushEntity.Result = 2;
return PushEntity;
}
PushDBEntity dbParm = (PushEntity.PushDBEntity.Count > 0) ? PushEntity.PushDBEntity[0] : new PushDBEntity();
DataCommand cmd = DataCommandManager.GetDataCommand("UpdatePushPlanManager");
cmd.SetParameterValue("@TaskID", dbParm.ID);
cmd.SetParameterValue("@PushTYpe", dbParm.Type);
cmd.SetParameterValue("@PushTitle", dbParm.Title);
cmd.SetParameterValue("@PushContent", dbParm.Content);
cmd.SetParameterValue("@PushProtoType", dbParm.PushProtoType);
if ("0".Equals(dbParm.Type))
{
cmd.SetParameterValue("@PushUsers", "");
}
else if ("1".Equals(dbParm.Type))
{
cmd.SetParameterValue("@PushUsers", dbParm.UserGroupList);
}
else if ("2".Equals(dbParm.Type))
{
cmd.SetParameterValue("@PushUsers", dbParm.FilePath);
}
cmd.SetParameterValue("@All_Count", dbParm.AllCount);
cmd.SetParameterValue("@UpdateUser", PushEntity.LogMessages.Username);
cmd.ExecuteNonQuery();
PushEntity.Result = 1;
return PushEntity;
}
//点击确定按钮
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();
}
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>"); //执行定时执行
}
public static PushEntity PushInsert(PushEntity PushEntity)
{
if (PushEntity.PushDBEntity.Count == 0)
{
PushEntity.Result = 0;
return PushEntity;
}
//if (!CheckInsert(PushEntity))
//{
// PushEntity.Result = 2;
// return PushEntity;
//}
PushDBEntity dbParm = (PushEntity.PushDBEntity.Count > 0) ? PushEntity.PushDBEntity[0] : new PushDBEntity();
DataCommand cmd = DataCommandManager.GetDataCommand("InsertPushInfoPlanManager");
cmd.SetParameterValue("@PushTYpe", dbParm.Type);
cmd.SetParameterValue("@PushAcTYpe", dbParm.PushType);
cmd.SetParameterValue("@PushTitle", dbParm.Title);
cmd.SetParameterValue("@PushContent", dbParm.Content);
cmd.SetParameterValue("@PushProtoType", dbParm.PushProtoType);
cmd.SetParameterValue("@WapUrl", dbParm.WapUrl);
if ("0".Equals(dbParm.Type))
{
cmd.SetParameterValue("@PushUsers", "");
}
else if ("1".Equals(dbParm.Type))
{
cmd.SetParameterValue("@PushUsers", dbParm.UserGroupList);
}
else if ("2".Equals(dbParm.Type))
{
cmd.SetParameterValue("@PushUsers", dbParm.FilePath);
}
cmd.SetParameterValue("@Status", "0");
cmd.SetParameterValue("@All_Count", dbParm.AllCount);
cmd.SetParameterValue("@CreateUser", PushEntity.LogMessages.Username);
cmd.SetParameterValue("@TicketPackage", dbParm.TicketPackage);
cmd.SetParameterValue("@TicketAmount", dbParm.TicketAmount);
cmd.ExecuteNonQuery();
PushEntity.PushDBEntity[0].ID = cmd.GetParameterValue("@TaskID").ToString();
PushEntity.Result = 1;
return PushEntity;
}
public static PushEntity PushInfoHistorySelect(PushEntity PushEntity)
{
DataCommand cmd = DataCommandManager.GetDataCommand("PushInfoHistorySelect");
PushEntity.QueryResult = cmd.ExecuteDataSet();
return PushEntity;
}
public static PushEntity PushInfoHistoryListSelect(PushEntity PushEntity)
{
PushDBEntity dbParm = (PushEntity.PushDBEntity.Count > 0) ? PushEntity.PushDBEntity[0] : new PushDBEntity();
DataCommand cmd = DataCommandManager.GetDataCommand("PushInfoHistoryListSelect");
if (String.IsNullOrEmpty(dbParm.Title))
{
cmd.SetParameterValue("@Title", DBNull.Value);
}
else
{
cmd.SetParameterValue("@Title", "%" + dbParm.Title + "%");
}
if (String.IsNullOrEmpty(dbParm.Content))
{
cmd.SetParameterValue("@Content", DBNull.Value);
}
else
{
cmd.SetParameterValue("@Content", "%" + dbParm.Content + "%");
}
if (String.IsNullOrEmpty(dbParm.StartDTime))
{
cmd.SetParameterValue("@StartDT", DBNull.Value);
}
else
{
cmd.SetParameterValue("@StartDT", dbParm.StartDTime);
}
if (String.IsNullOrEmpty(dbParm.EndDTime))
{
cmd.SetParameterValue("@EndDT", DBNull.Value);
}
else
{
cmd.SetParameterValue("@EndDT", dbParm.EndDTime);
}
PushEntity.QueryResult = cmd.ExecuteDataSet();
return PushEntity;
}
public static PushEntity GetUserGroupList(PushEntity PushEntity)
{
PushEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("Push", "t_lm_usergroup_list", false);
return PushEntity;
}
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>"); //执行定时执行
}
public static PushEntity SelectInfoActionDateTime(PushEntity PushEntity)
{
PushEntity.LogMessages.MsgType = MessageType.INFO;
PushEntity.LogMessages.Content = _nameSpaceClass + "SelectInfoActionDateTime";
LoggerHelper.LogWriter(PushEntity.LogMessages);
try
{
return PushDA.SelectInfoActionDateTime(PushEntity);
}
catch (Exception ex)
{
PushEntity.LogMessages.MsgType = MessageType.ERROR;
PushEntity.LogMessages.Content = _nameSpaceClass + "SelectInfoActionDateTime Error: " + ex.Message;
LoggerHelper.LogWriter(PushEntity.LogMessages);
throw ex;
}
}
public static PushEntity SelectPushInfoActionHistoryList(PushEntity PushEntity)
{
PushDBEntity dbParm = (PushEntity.PushDBEntity.Count > 0) ? PushEntity.PushDBEntity[0] : new PushDBEntity();
DataCommand cmd = DataCommandManager.GetDataCommand("SelectPushInfoActionHistoryList");
cmd.SetParameterValue("@TaskID", dbParm.ID);
if (String.IsNullOrEmpty(dbParm.TelPhone))
{
cmd.SetParameterValue("@UserID", DBNull.Value);
}
else
{
cmd.SetParameterValue("@UserID", dbParm.TelPhone);
}
cmd.SetParameterValue("@PageCurrent", PushEntity.PageCurrent - 1);
cmd.SetParameterValue("@PageSize", PushEntity.PageSize);
DataSet dsResult = cmd.ExecuteDataSet();
PushEntity.TotalCount = (int)cmd.GetParameterValue("@TotalCount");
PushEntity.QueryResult = dsResult;
return PushEntity;
}
public static PushEntity SendPushMsg(PushEntity PushEntity)
{
PushEntity.LogMessages.MsgType = MessageType.INFO;
PushEntity.LogMessages.Content = _nameSpaceClass + "SendPushMsg";
LoggerHelper.LogWriter(PushEntity.LogMessages);
try
{
PushEntity.Result = 1;
PushEntity.PushDBEntity[0].Status = "1";
PushDBEntity dbParm = (PushEntity.PushDBEntity.Count > 0) ? PushEntity.PushDBEntity[0] : new PushDBEntity();
PushEntity = PushDA.UpdateSendPushStatus(PushEntity);
if (2 == PushEntity.Result)
{
return PushEntity;
}
System.Diagnostics.Process process = new System.Diagnostics.Process();
try
{
process.StartInfo.FileName = ConfigurationManager.AppSettings["PushMsgJob"].ToString();//文件名必须加后缀。
process.StartInfo.Arguments = dbParm.ID;
process.Start();
}
catch (Exception exU)
{
PushEntity.Result = 3;
PushEntity.PushDBEntity[0].Status = "0";
PushEntity = PushDA.UpdateSendPushStatus(PushEntity);
}
finally
{
if (!process.HasExited)
{
process.Close();
process.Dispose();
}
}
return PushEntity;
}
catch (Exception ex)
{
PushEntity.LogMessages.MsgType = MessageType.ERROR;
PushEntity.LogMessages.Content = _nameSpaceClass + "SendPushMsg Error: " + ex.Message;
LoggerHelper.LogWriter(PushEntity.LogMessages);
throw ex;
}
}
public static PushEntity SelectPushInfoAllUsersCount(PushEntity PushEntity)
{
PushEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("Push", "t_lm_push_info_all_user_count", false);
return PushEntity;
}
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();
}
public static PushEntity SelectPushSuccCount(PushEntity PushEntity)
{
PushDBEntity dbParm = (PushEntity.PushDBEntity.Count > 0) ? PushEntity.PushDBEntity[0] : new PushDBEntity();
DataCommand cmd = DataCommandManager.GetDataCommand("SelectPushSuccCount");
cmd.SetParameterValue("@TaskID", dbParm.ID);
PushEntity.QueryResult = cmd.ExecuteDataSet();
return PushEntity;
}
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();
}
}
public static PushEntity SelectPushUserGroupCount(PushEntity PushEntity)
{
OracleParameter[] parm ={
new OracleParameter("UserGroups",OracleType.VarChar)
};
PushDBEntity dbParm = (PushEntity.PushDBEntity.Count > 0) ? PushEntity.PushDBEntity[0] : new PushDBEntity();
string strUserGroupList = string.Empty;
string[] userGroupList = dbParm.UserGroupList.Split(',');
foreach (string strTemp in userGroupList)
{
if(String.IsNullOrEmpty(strTemp.Trim()))
{
continue;
}
strUserGroupList = strUserGroupList + strTemp.Trim().Substring(1, strTemp.IndexOf(']') - 1) + ",";
}
parm[0].Value = strUserGroupList;
PushEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("Push", "t_lm_push_user_group_count", false, parm);
return PushEntity;
}