public static IssueInfoEntity BindIssueList(IssueInfoEntity issueInfoEntity) { IssueInfoDBEntity dbParm = (issueInfoEntity.IssueInfoDBEntity.Count > 0) ? issueInfoEntity.IssueInfoDBEntity[0] : new IssueInfoDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("GetBindIssueList"); cmd.SetParameterValue("@StartDTime", dbParm.StartDTime); cmd.SetParameterValue("@EndDTime", dbParm.EndDTime); cmd.SetParameterValue("@Title", String.IsNullOrEmpty(dbParm.Title) ? dbParm.Title : "%" + dbParm.Title + "%"); cmd.SetParameterValue("@IssueStatus", dbParm.Status); cmd.SetParameterValue("@IssueType", String.IsNullOrEmpty(dbParm.IssueType) ? dbParm.IssueType : "%" + dbParm.IssueType + "%"); cmd.SetParameterValue("@Assignto", dbParm.Assignto); cmd.SetParameterValue("@RelatedType", dbParm.RelatedType); cmd.SetParameterValue("@RelatedID", dbParm.RelatedID); cmd.SetParameterValue("@TimeSpans", dbParm.TimeSpans); cmd.SetParameterValue("@PageCurrent", issueInfoEntity.PageCurrent - 1); cmd.SetParameterValue("@PageSize", issueInfoEntity.PageSize); DataSet dsResult = cmd.ExecuteDataSet(); if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { for (int i = 0; i < dsResult.Tables[0].Rows.Count; i++ ) { dsResult.Tables[0].Rows[i]["IssueTypeNM"] = SetIssueTypeNM(dsResult.Tables[0].Rows[i]["IssueType"].ToString().Trim()); } } issueInfoEntity.QueryResult = dsResult; issueInfoEntity.TotalCount = (int)cmd.GetParameterValue("@TotalCount"); return issueInfoEntity; }
public static bool CheckIssueAsTo(IssueInfoEntity issueInfoEntity) { IssueInfoDBEntity dbParm = (issueInfoEntity.IssueInfoDBEntity.Count > 0) ? issueInfoEntity.IssueInfoDBEntity[0] : new IssueInfoDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("CheckIssueAsTo"); cmd.SetParameterValue("@UserID", dbParm.Assignto); DataSet dsResult = cmd.ExecuteDataSet(); if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { return true; } else { return false; } }
public static bool CheckIssueLinkGo(IssueInfoEntity issueInfoEntity) { IssueInfoDBEntity dbParm = (issueInfoEntity.IssueInfoDBEntity.Count > 0) ? issueInfoEntity.IssueInfoDBEntity[0] : new IssueInfoDBEntity(); string strRelatedType = dbParm.RelatedType; string strSql = string.Empty; switch (strRelatedType) { case "0": strSql = "t_lm_b_common_order"; break; case "1": return true; //strSql = "t_lm_b_common_hotel"; //break; case "2": strSql = "t_lm_b_common_invoice"; break; case "3": strSql = "t_lm_b_common_user"; break; case "4": strSql = "t_lm_b_common_cash"; break; case "5": strSql = "t_lm_b_common_advice"; break; default: strSql = ""; break; } OracleParameter[] parm ={ new OracleParameter("TID",OracleType.VarChar) }; parm[0].Value = dbParm.RelatedID; DataSet dsResult = DbManager.Query("IssueInfo", strSql, true, parm); if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0 && !String.IsNullOrEmpty(dsResult.Tables[0].Rows[0][0].ToString().Trim())) { return true; } else { return false; } }
public static bool CheckIssueLinkGo(IssueInfoEntity issueInfoEntity) { issueInfoEntity.LogMessages.MsgType = MessageType.INFO; issueInfoEntity.LogMessages.Content = _nameSpaceClass + "CheckIssueLinkGo"; LoggerHelper.LogWriter(issueInfoEntity.LogMessages); try { return IssueInfoDA.CheckIssueLinkGo(issueInfoEntity); } catch (Exception ex) { issueInfoEntity.LogMessages.MsgType = MessageType.ERROR; issueInfoEntity.LogMessages.Content = _nameSpaceClass + "CheckIssueLinkGo Error: " + ex.Message; LoggerHelper.LogWriter(issueInfoEntity.LogMessages); throw ex; } }
public static IssueInfoEntity ExportOverTimeOrderList(IssueInfoEntity issueInfoEntity) { issueInfoEntity.LogMessages.MsgType = MessageType.INFO; issueInfoEntity.LogMessages.Content = _nameSpaceClass + "ExportOverTimeOrderList"; LoggerHelper.LogWriter(issueInfoEntity.LogMessages); try { return IssueInfoDA.ExportOverTimeOrderList(issueInfoEntity); } catch (Exception ex) { issueInfoEntity.LogMessages.MsgType = MessageType.ERROR; issueInfoEntity.LogMessages.Content = _nameSpaceClass + "ExportOverTimeOrderList Error: " + ex.Message; LoggerHelper.LogWriter(issueInfoEntity.LogMessages); throw ex; } }
protected void btnExport_Click(object sender, EventArgs e) { _issueinfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _issueinfoEntity.LogMessages.Userid = UserSession.Current.UserAccount; _issueinfoEntity.LogMessages.Username = UserSession.Current.UserDspName; _issueinfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _issueinfoEntity.IssueInfoDBEntity = new List<IssueInfoDBEntity>(); IssueInfoDBEntity issueinfoEntity = new IssueInfoDBEntity(); issueinfoEntity.HotelID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["HotelID"].ToString())) ? null : ViewState["HotelID"].ToString(); issueinfoEntity.PriceCode = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["PriceCode"].ToString())) ? null : ViewState["PriceCode"].ToString(); issueinfoEntity.StartDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["StartDTime"].ToString())) ? null : ViewState["StartDTime"].ToString(); issueinfoEntity.EndDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["EndDTime"].ToString())) ? null : ViewState["EndDTime"].ToString(); _issueinfoEntity.IssueInfoDBEntity.Add(issueinfoEntity); _issueinfoEntity.SortField = gridViewCSReviewList.Attributes["SortExpression"].ToString(); _issueinfoEntity.SortType = gridViewCSReviewList.Attributes["SortDirection"].ToString(); _issueinfoEntity = IssueInfoBP.ExportOverTimeOrderList(_issueinfoEntity); DataSet dsResult = _issueinfoEntity.QueryResult; if (dsResult.Tables.Count == 0 && dsResult.Tables[0].Rows.Count == 0) { messageContent.InnerHtml = GetLocalResourceObject("WarningMessage").ToString(); return; } dsResult.Tables[0].Columns["fog_order_num"].ColumnName = "订单号"; dsResult.Tables[0].Columns["login_mobile"].ColumnName = "登陆手机号"; dsResult.Tables[0].Columns["contact_name"].ColumnName = "联系人"; dsResult.Tables[0].Columns["hotel_id"].ColumnName = "酒店ID"; dsResult.Tables[0].Columns["hotel_name"].ColumnName = "酒店名称"; dsResult.Tables[0].Columns["linktel"].ColumnName = "酒店联系电话"; dsResult.Tables[0].Columns["price_code"].ColumnName = "价格代码"; dsResult.Tables[0].Columns["book_status_other_nm"].ColumnName = "订单状态"; dsResult.Tables[0].Columns["in_date"].ColumnName = "入住时间"; dsResult.Tables[0].Columns["create_time"].ColumnName = "创建时间"; dsResult.Tables[0].Columns["update_time"].ColumnName = "确认时间"; dsResult.Tables[0].Columns["timeD_diff"].ColumnName = "时差"; dsResult.Tables[0].Columns["book_status_other"].ColumnName = "价格代码CODE"; dsResult.Tables[0].Columns["cancel_reason"].ColumnName = "取消原因"; CommonFunction.ExportExcelForLM(dsResult); }
public static string SetRelatedVal(string strKey, string strType) { IssueInfoEntity issueinfoEntity = new IssueInfoEntity(); issueinfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); issueinfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); issueinfoEntity.LogMessages.Userid = UserSession.Current.UserAccount; issueinfoEntity.LogMessages.Username = UserSession.Current.UserDspName; issueinfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP; issueinfoEntity.IssueInfoDBEntity = new List<IssueInfoDBEntity>(); IssueInfoDBEntity issueinfoDBEntity = new IssueInfoDBEntity(); issueinfoDBEntity.RevlKey = strKey; issueinfoDBEntity.RevlType = strType; issueinfoEntity.IssueInfoDBEntity.Add(issueinfoDBEntity); DataSet dsResult = IssueInfoBP.GetRevlTypeVal(issueinfoEntity).QueryResult; if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0 && !String.IsNullOrEmpty(dsResult.Tables[0].Rows[0]["HOTELID"].ToString())) { return " 酒店:[" + dsResult.Tables[0].Rows[0]["HOTELID"].ToString() + "]" + dsResult.Tables[0].Rows[0]["HOTELNM"].ToString(); } else { return ""; } }
public static IssueInfoEntity GetCommonUserList(IssueInfoEntity issueInfoEntity) { DataCommand cmd = DataCommandManager.GetDataCommand("GetCommonUserList"); issueInfoEntity.QueryResult = cmd.ExecuteDataSet(); return issueInfoEntity; }
public static IssueInfoEntity UpdateIssue(IssueInfoEntity issueInfoEntity) { issueInfoEntity.LogMessages.MsgType = MessageType.INFO; issueInfoEntity.LogMessages.Content = _nameSpaceClass + "UpdateIssue"; LoggerHelper.LogWriter(issueInfoEntity.LogMessages); try { return IssueInfoDA.UpdateIssueAndHistory(issueInfoEntity); } catch (Exception ex) { issueInfoEntity.LogMessages.MsgType = MessageType.ERROR; issueInfoEntity.LogMessages.Content = _nameSpaceClass + "UpdateIssue Error: " + ex.Message; throw ex; } }
public static DataSet GetOrderUserTel(IssueInfoEntity issueInfoEntity) { IssueInfoDBEntity dbParm = (issueInfoEntity.IssueInfoDBEntity.Count > 0) ? issueInfoEntity.IssueInfoDBEntity[0] : new IssueInfoDBEntity(); OracleParameter[] parm ={ new OracleParameter("TID",OracleType.VarChar) }; parm[0].Value = dbParm.RelatedID; DataSet dsResult = DbManager.Query("IssueInfo", "t_lm_b_order_user_tel", true, parm); return dsResult; }
public static IssueInfoEntity IssueSave(IssueInfoEntity issueInfoEntity) { issueInfoEntity.LogMessages.MsgType = MessageType.INFO; issueInfoEntity.LogMessages.Content = _nameSpaceClass + "IssueSave"; LoggerHelper.LogWriter(issueInfoEntity.LogMessages); try { if ("0".Equals(issueInfoEntity.IssueInfoDBEntity[0].ActionType)) { issueInfoEntity = IssueInfoDA.InsertIssueAndHistory(issueInfoEntity); } else { issueInfoEntity = IssueInfoDA.UpdateIssueAndHistory(issueInfoEntity); } if (issueInfoEntity.Result != 1) { return issueInfoEntity; } IssueInfoDBEntity dbParm = (issueInfoEntity.IssueInfoDBEntity.Count > 0) ? issueInfoEntity.IssueInfoDBEntity[0] : new IssueInfoDBEntity(); if ("1".Equals(dbParm.ChkMsgAssgin)) { DataSet dsResult = IssueInfoDA.GetMailToList(issueInfoEntity).QueryResult; if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0 && !String.IsNullOrEmpty(dsResult.Tables[0].Rows[0]["User_Tel"].ToString().Trim())) { issueInfoEntity.IssueInfoDBEntity[0].MsgAssginRs = IssueInfoSA.SendMsgToIssue(dsResult.Tables[0].Rows[0]["User_Tel"].ToString().Trim(), "1", dbParm.MsgAssginText); if (issueInfoEntity.IssueInfoDBEntity[0].MsgAssginRs.Length > 0) { issueInfoEntity.Result = 9; } else { issueInfoEntity.IssueInfoDBEntity[0].MsgAssginRs = "Issue指派人短信发送成功!"; } } else { issueInfoEntity.Result = 9; issueInfoEntity.IssueInfoDBEntity[0].MsgAssginRs = "Issue指派人电话号码不存在,发送短信失败!"; } } if ("1".Equals(dbParm.ChkMsgUser) && "0".Equals(dbParm.RelatedType)) { DataSet dsResult = IssueInfoDA.GetOrderUserTel(issueInfoEntity); if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0 && !String.IsNullOrEmpty(dsResult.Tables[0].Rows[0]["LOGIN_MOBILE"].ToString().Trim())) { issueInfoEntity.IssueInfoDBEntity[0].MsgUserRs = IssueInfoSA.SendMsgToIssue(dsResult.Tables[0].Rows[0]["LOGIN_MOBILE"].ToString().Trim(), "0", dbParm.MsgUserText); if (issueInfoEntity.IssueInfoDBEntity[0].MsgUserRs.Length > 0) { issueInfoEntity.Result = 9; } else { issueInfoEntity.IssueInfoDBEntity[0].MsgUserRs = "订单用户短信发送成功!"; } } else { issueInfoEntity.Result = 9; issueInfoEntity.IssueInfoDBEntity[0].MsgUserRs = "订单用户电话号码不存在,发送短信失败!"; } } IssueInfoDA.InsertIssueHistory(issueInfoEntity); return issueInfoEntity; } catch (Exception ex) { issueInfoEntity.LogMessages.MsgType = MessageType.ERROR; issueInfoEntity.LogMessages.Content = _nameSpaceClass + "IssueSave Error: " + ex.Message; LoggerHelper.LogWriter(issueInfoEntity.LogMessages); throw ex; } }
public static IssueInfoEntity SendMail(IssueInfoEntity issueInfoEntity) { issueInfoEntity.LogMessages.MsgType = MessageType.INFO; issueInfoEntity.LogMessages.Content = _nameSpaceClass + "SendMail"; LoggerHelper.LogWriter(issueInfoEntity.LogMessages); try { IssueInfoDBEntity dbParm = (issueInfoEntity.IssueInfoDBEntity.Count > 0) ? issueInfoEntity.IssueInfoDBEntity[0] : new IssueInfoDBEntity(); string strMailTo = GetMailToList(issueInfoEntity); DataSet dsResult = GetUpdateIssueDetail(issueInfoEntity).QueryResult; StringBuilder sbString = new StringBuilder(); sbString.Append("<div style='font-size:16;font-family:Microsoft YaHei;font-weight:bold;'>"); sbString.Append("Dear " + dsResult.Tables[0].Rows[0]["AssigntoNm"].ToString() + ", <br/><br/>"); sbString.Append("您已经被指派了一个新的Issue,Issue概要:<br/><br/>"); sbString.Append("<table style='font-size:14;font-family:Microsoft YaHei;' border='1'><tr style='background-color:#f6f6f6;font-weight:bold;'><td style='width:100px' align='center'>IssueID</td><td style='width:150px' align='center'>Title</td><td style='width:80px' align='center'>优先级</td><td style='width:100px' align='center'>类别</td><td style='width:80px' align='center'>状态</td><td style='width:100px' align='center'>关联Item</td><td style='width:150px' align='center'>关联ID</td><td style='width:80px' align='center'>创建人</td><td style='width:150px' align='center'>创建时间</td><td style='width:120px' align='center'>Assign指派</td></tr>"); sbString.Append("<tr><td align='center'>" + dsResult.Tables[0].Rows[0]["IssueID"].ToString() + "</td><td align='center'>" + SetIssueLink(dsResult.Tables[0].Rows[0]["IssueID"].ToString(), dsResult.Tables[0].Rows[0]["Title"].ToString()) + "</td><td align='center'>" + dsResult.Tables[0].Rows[0]["Priority"].ToString() + "</td><td align='center'>" + SetIssueTypeNM(dsResult.Tables[0].Rows[0]["Type"].ToString()) + "</td><td align='center'>" + dsResult.Tables[0].Rows[0]["DISStatus"].ToString() + "</td><td align='center'>" + dsResult.Tables[0].Rows[0]["RelatedTypeNM"].ToString() + "</td><td align='center'>" + dsResult.Tables[0].Rows[0]["RelatedID"].ToString() + "</td><td align='center'>" + dsResult.Tables[0].Rows[0]["CreateUser"].ToString() + "</td><td align='center'>" + dsResult.Tables[0].Rows[0]["Create_Time"].ToString() + "</td><td align='center'>" + dsResult.Tables[0].Rows[0]["AssigntoNm"].ToString() + "</td></tr></table><br/><br/>"); sbString.Append("BR<br/>"); sbString.Append("Hotelvp CMS<br/>"); sbString.Append("</div>"); SendMailProcess(strMailTo, dsResult.Tables[0].Rows[0]["IssueID"].ToString(), sbString.ToString()); return issueInfoEntity; } catch (Exception ex) { issueInfoEntity.LogMessages.MsgType = MessageType.ERROR; issueInfoEntity.LogMessages.Content = _nameSpaceClass + "SendMail Error: " + ex.Message; LoggerHelper.LogWriter(issueInfoEntity.LogMessages); throw ex; } }
public static string GetMailToList(IssueInfoEntity issueInfoEntity) { issueInfoEntity.LogMessages.MsgType = MessageType.INFO; issueInfoEntity.LogMessages.Content = _nameSpaceClass + "GetMailToList"; LoggerHelper.LogWriter(issueInfoEntity.LogMessages); try { DataSet dsResult = IssueInfoDA.GetMailToList(issueInfoEntity).QueryResult; if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0 && !String.IsNullOrEmpty(dsResult.Tables[0].Rows[0]["User_Email"].ToString().Trim())) { return dsResult.Tables[0].Rows[0]["User_Email"].ToString().Trim(); } else { return ConfigurationManager.AppSettings["issueMailTo"].ToString(); } } catch (Exception ex) { issueInfoEntity.LogMessages.MsgType = MessageType.ERROR; issueInfoEntity.LogMessages.Content = _nameSpaceClass + "GetMailToList Error: " + ex.Message; LoggerHelper.LogWriter(issueInfoEntity.LogMessages); throw ex; } }
public static IssueInfoEntity GetUpdateIssueDetail(IssueInfoEntity issueInfoEntity) { issueInfoEntity.LogMessages.MsgType = MessageType.INFO; issueInfoEntity.LogMessages.Content = _nameSpaceClass + "GetUpdateIssueDetail"; LoggerHelper.LogWriter(issueInfoEntity.LogMessages); try { return IssueInfoDA.GetUpdateIssueDetail(issueInfoEntity); } catch (Exception ex) { issueInfoEntity.LogMessages.MsgType = MessageType.ERROR; issueInfoEntity.LogMessages.Content = _nameSpaceClass + "GetUpdateIssueDetail Error: " + ex.Message; LoggerHelper.LogWriter(issueInfoEntity.LogMessages); throw ex; } }
public static IssueInfoEntity GetMailToList(IssueInfoEntity issueInfoEntity) { IssueInfoDBEntity dbParm = (issueInfoEntity.IssueInfoDBEntity.Count > 0) ? issueInfoEntity.IssueInfoDBEntity[0] : new IssueInfoDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("GetMailToList"); cmd.SetParameterValue("@UserID", dbParm.Assignto); issueInfoEntity.QueryResult = cmd.ExecuteDataSet(); return issueInfoEntity; }
public static IssueInfoEntity GetRevlTypeVal(IssueInfoEntity issueInfoEntity) { OracleParameter[] parm ={ new OracleParameter("REKEY",OracleType.VarChar) }; IssueInfoDBEntity dbParm = (issueInfoEntity.IssueInfoDBEntity.Count > 0) ? issueInfoEntity.IssueInfoDBEntity[0] : new IssueInfoDBEntity(); parm[0].Value = dbParm.RevlKey; string strSql = "t_lm_b_hotelinfo_prop_reval_order"; if ("1".Equals(dbParm.RevlType)) { strSql = "t_lm_b_hotelinfo_prop_reval_hotel"; } issueInfoEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("IssueInfo", strSql, false, parm); return issueInfoEntity; }
private void BindOrderIssue(string orderID) { CommonEntity _commonEntity = new CommonEntity(); IssueInfoEntity _issueinfoEntity = new IssueInfoEntity(); _issueinfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _issueinfoEntity.LogMessages.Userid = UserSession.Current.UserAccount; _issueinfoEntity.LogMessages.Username = UserSession.Current.UserDspName; _issueinfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _issueinfoEntity.IssueInfoDBEntity = new List<IssueInfoDBEntity>(); IssueInfoDBEntity issueinfoDBEntity = new IssueInfoDBEntity(); issueinfoDBEntity.IssueID = ""; issueinfoDBEntity.ActionType = "0"; DataSet dsOrderInfo = GetOrderInfoData(orderID); if (dsOrderInfo.Tables.Count == 0 || dsOrderInfo.Tables[0].Rows.Count == 0) { return; } txtTitle.Text = "[" + dsOrderInfo.Tables[0].Rows[0]["HOTELNM"].ToString() + "]订单审核问题"; ddpPriority.SelectedValue = "2"; string strIssue = (String.IsNullOrEmpty(dsOrderInfo.Tables[0].Rows[0]["SALESMG"].ToString())) ? ConfigurationManager.AppSettings["DefaultIssue"].ToString() : "["+ dsOrderInfo.Tables[0].Rows[0]["SALESMG"].ToString() +"]"+ dsOrderInfo.Tables[0].Rows[0]["SALESNM"].ToString(); ddpStatusList.SelectedValue = "0"; chkIssueType.SelectedValue = "8"; //ScriptManager.RegisterStartupScript(this.UpdatePanel8, this.GetType(), "setScript", "SetUserControl('" + strIssue + "','0')", true); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "SetUserControl('" + strIssue + "','0')", true); //UpdatePanel8.Update(); }
protected void btnSave_Click(object sender, EventArgs e) { messageContent.InnerHtml = ""; string strIssueType = ""; foreach (ListItem li in chkIssueType.Items) { if (li.Selected == true) { strIssueType = strIssueType + li.Value + ","; } } strIssueType = strIssueType.Trim(','); if (String.IsNullOrEmpty(txtTitle.Text.Trim())) { messageContent.InnerHtml = GetLocalResourceObject("Error1").ToString(); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true); return; } if ("1".Equals(hidIsIndemnify.Value.Trim())) { if (String.IsNullOrEmpty(txtIndemnifyPrice.Text.Trim()) && String.IsNullOrEmpty(hidPageCode.Value.Trim())) { messageContent.InnerHtml = GetLocalResourceObject("Error2").ToString(); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true); return; } if (!String.IsNullOrEmpty(txtIndemnifyPrice.Text.Trim()) && !ChkNumber(txtIndemnifyPrice.Text.Trim())) { messageContent.InnerHtml = GetLocalResourceObject("Error10").ToString(); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true); return; } } if (String.IsNullOrEmpty(txtRelatedID.Text.Trim())) { messageContent.InnerHtml = GetLocalResourceObject("Error3").ToString(); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true); return; } if (String.IsNullOrEmpty(strIssueType.Trim())) { messageContent.InnerHtml = GetLocalResourceObject("Error5").ToString(); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true); return; } if (String.IsNullOrEmpty(hidUserID.Value.Trim()) || hidUserID.Value.IndexOf('[') < 0 || hidUserID.Value.IndexOf(']') < 0) { messageContent.InnerHtml = GetLocalResourceObject("Error7").ToString(); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true); return; } if ("1".Equals(hidChkAssginTo.Value.Trim()) && String.IsNullOrEmpty(txtAsginText.Text.ToString().Trim())) { messageContent.InnerHtml = GetLocalResourceObject("Error111").ToString(); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true); return; } if ("1".Equals(hidChkAssginTo.Value.Trim()) && !String.IsNullOrEmpty(txtAsginText.Text.ToString().Trim()) && (txtAsginText.Text.ToString().Trim().Length > 190)) { messageContent.InnerHtml = GetLocalResourceObject("Error11").ToString(); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true); return; } if ("1".Equals(hidChkMsgUser.Value.Trim()) && String.IsNullOrEmpty(txtMsgUser.Text.ToString().Trim())) { messageContent.InnerHtml = GetLocalResourceObject("Error121").ToString(); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true); return; } if ("1".Equals(hidChkMsgUser.Value.Trim()) && !String.IsNullOrEmpty(txtMsgUser.Text.ToString().Trim()) && (txtMsgUser.Text.ToString().Trim().Length > 190)) { messageContent.InnerHtml = GetLocalResourceObject("Error12").ToString(); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true); return; } _issueinfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _issueinfoEntity.LogMessages.Userid = UserSession.Current.UserAccount; _issueinfoEntity.LogMessages.Username = UserSession.Current.UserDspName; _issueinfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _issueinfoEntity.IssueInfoDBEntity = new List<IssueInfoDBEntity>(); IssueInfoDBEntity issueinfoDBEntity = new IssueInfoDBEntity(); issueinfoDBEntity.IssueID = hidIssueID.Value.Trim(); issueinfoDBEntity.ActionType = hidActionType.Value.Trim(); issueinfoDBEntity.Title = txtTitle.Text.Trim(); issueinfoDBEntity.Priority = ddpPriority.SelectedValue.Trim(); issueinfoDBEntity.IssueType = strIssueType; issueinfoDBEntity.AssignNm = hidUserID.Value.Trim(); issueinfoDBEntity.Assignto = hidUserID.Value.Substring((hidUserID.Value.IndexOf('[') + 1), (hidUserID.Value.IndexOf(']') - 1));// ddpAstoList.SelectedValue.Trim(); issueinfoDBEntity.Status = ddpStatusList.SelectedValue.Trim(); issueinfoDBEntity.IsIndemnify = hidIsIndemnify.Value.Trim(); issueinfoDBEntity.IndemnifyPrice = ("0".Equals(hidIsIndemnify.Value.Trim()))? "" : txtIndemnifyPrice.Text.Trim(); issueinfoDBEntity.RelatedType = ddpRelated.SelectedValue.Trim(); issueinfoDBEntity.RelatedID = txtRelatedID.Text.Trim(); issueinfoDBEntity.TicketCode = ("0".Equals(hidIsIndemnify.Value.Trim())) ? "" : hidPageCode.Value.Trim(); //issueinfoDBEntity.Remark = "0".Equals(hidActionType.Value) ? UserSession.Current.UserDspName + " " + DateTime.Now.ToLongDateString() + " " + txtRemark.Text.Trim() + "<br/>" : lbIssueHis.Text + UserSession.Current.UserDspName + " " + DateTime.Now.ToLongDateString() + " " + txtRemark.Text.Trim() + "<br/>"; issueinfoDBEntity.Remark = !String.IsNullOrEmpty(txtRemark.Text.Trim()) ? lbIssueHis.Text + UserSession.Current.UserDspName + " " + DateTime.Now.ToString() + " " + txtRemark.Text.Trim() + "<br/>" : lbIssueHis.Text; issueinfoDBEntity.HisRemark = txtRemark.Text.Trim(); issueinfoDBEntity.UpdateUser = UserSession.Current.UserDspName; string dtNow = DateTime.Now.ToString(); issueinfoDBEntity.TimeDiffTal = SetTimeLag(lbIssueCtDt.Text, dtNow); issueinfoDBEntity.TimeSpans = SetTimeSpanLag(lbIssueCtDt.Text, dtNow); issueinfoDBEntity.UpdateTime = dtNow; issueinfoDBEntity.ChkMsgAssgin = hidChkAssginTo.Value; issueinfoDBEntity.MsgAssginText = ("1".Equals(hidChkAssginTo.Value)) ? txtAsginText.Text.Trim() : ""; issueinfoDBEntity.ChkMsgUser = ("0".Equals(ddpRelated.SelectedValue.Trim())) ? hidChkMsgUser.Value : ""; issueinfoDBEntity.MsgUserText = ("1".Equals(hidChkMsgUser.Value) && "0".Equals(ddpRelated.SelectedValue.Trim())) ? txtMsgUser.Text.Trim() : ""; _issueinfoEntity.IssueInfoDBEntity.Add(issueinfoDBEntity); _issueinfoEntity = IssueInfoBP.IssueSave(_issueinfoEntity); int iResult = _issueinfoEntity.Result; string strIssueID = _issueinfoEntity.IssueInfoDBEntity[0].IssueID; _commonEntity.LogMessages = _issueinfoEntity.LogMessages; _commonEntity.CommonDBEntity = new List<CommonDBEntity>(); CommonDBEntity commonDBEntity = new CommonDBEntity(); commonDBEntity.Event_Type = "Issue单管理-保存"; commonDBEntity.Event_ID = strIssueID; string conTent = GetLocalResourceObject("EventInsertMessage").ToString(); conTent = string.Format(conTent, strIssueID, issueinfoDBEntity.Title, issueinfoDBEntity.Priority, issueinfoDBEntity.IssueType, issueinfoDBEntity.Assignto, issueinfoDBEntity.Status, issueinfoDBEntity.IsIndemnify, issueinfoDBEntity.IndemnifyPrice, issueinfoDBEntity.TicketCode, issueinfoDBEntity.RelatedType, issueinfoDBEntity.RelatedID, issueinfoDBEntity.Remark, _issueinfoEntity.LogMessages.Username); commonDBEntity.Event_Content = conTent; if (iResult == 1) { commonDBEntity.Event_Result = ("1".Equals(hidChkAssginTo.Value) || ("1".Equals(hidChkMsgUser.Value) && "0".Equals(ddpRelated.SelectedValue.Trim()))) ? GetLocalResourceObject("InsertSuccess").ToString() : GetLocalResourceObject("Success818").ToString(); messageContent.InnerHtml = ("1".Equals(hidChkAssginTo.Value) || ("1".Equals(hidChkMsgUser.Value) && "0".Equals(ddpRelated.SelectedValue.Trim()))) ? GetLocalResourceObject("InsertSuccess").ToString() : GetLocalResourceObject("Success818").ToString(); if ("0".Equals(hidActionType.Value.Trim()) || ("1".Equals(hidActionType.Value.Trim()) && !hidAssginTo.Value.Trim().Equals(issueinfoDBEntity.Assignto))) { IssueInfoBP.SendMail(_issueinfoEntity); } BindgridViewCSReviewList(); hidAssginTo.Value = issueinfoDBEntity.Assignto; lbTimeDiffTal.Text = SetTimeLag(lbIssueCtDt.Text, dtNow); UpdatePanel9.Update(); } else if (iResult == 2) { commonDBEntity.Event_Result = GetLocalResourceObject("Error6").ToString(); messageContent.InnerHtml = GetLocalResourceObject("Error6").ToString(); } else if (iResult == 3) { commonDBEntity.Event_Result = GetLocalResourceObject("Error8").ToString(); messageContent.InnerHtml = GetLocalResourceObject("Error8").ToString(); } else if (iResult == 9) { commonDBEntity.Event_Result = GetLocalResourceObject("Success818").ToString() + _issueinfoEntity.IssueInfoDBEntity[0].MsgAssginRs + _issueinfoEntity.IssueInfoDBEntity[0].MsgUserRs; messageContent.InnerHtml = GetLocalResourceObject("Success818").ToString() + _issueinfoEntity.IssueInfoDBEntity[0].MsgAssginRs + _issueinfoEntity.IssueInfoDBEntity[0].MsgUserRs; if ("0".Equals(hidActionType.Value.Trim()) || ("1".Equals(hidActionType.Value.Trim()) && !hidAssginTo.Value.Trim().Equals(issueinfoDBEntity.Assignto))) { IssueInfoBP.SendMail(_issueinfoEntity); } BindgridViewCSReviewList(); hidAssginTo.Value = issueinfoDBEntity.Assignto; lbTimeDiffTal.Text = SetTimeLag(lbIssueCtDt.Text, dtNow); UpdatePanel9.Update(); } //else if (iResult == 4) //{ // commonDBEntity.Event_Result = GetLocalResourceObject("Error81").ToString(); // messageContent.InnerHtml = GetLocalResourceObject("Error81").ToString(); //} //else if (iResult == 5) //{ // commonDBEntity.Event_Result = GetLocalResourceObject("Error811").ToString(); // messageContent.InnerHtml = GetLocalResourceObject("Error811").ToString(); //} //else if (iResult == 6 || iResult == 7) //{ // commonDBEntity.Event_Result = GetLocalResourceObject("InsertSuccess").ToString() +_issueinfoEntity.IssueInfoDBEntity[0].MsgUserRs; // messageContent.InnerHtml = GetLocalResourceObject("InsertSuccess").ToString() + _issueinfoEntity.IssueInfoDBEntity[0].MsgUserRs; //} //else if (iResult == 8) //{ // commonDBEntity.Event_Result = GetLocalResourceObject("Error812").ToString(); // messageContent.InnerHtml = GetLocalResourceObject("Error812").ToString(); //} else { commonDBEntity.Event_Result = GetLocalResourceObject("Error4").ToString() + _issueinfoEntity.ErrorMSG; messageContent.InnerHtml = GetLocalResourceObject("Error4").ToString() + _issueinfoEntity.ErrorMSG; } _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); if (iResult == 1 || iResult == 9) { if ("1".Equals(hidCloseFlag.Value)) { ScriptManager.RegisterStartupScript(this.UpdatePanel2, this.GetType(), "setScript", "BtnUpdateComplete()", true); } else { ScriptManager.RegisterStartupScript(this.UpdatePanel2, this.GetType(), "setScript", "ClearClickEvent()", true); } } else { this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true); } //UpdatePanel6.Update(); }
public static IssueInfoEntity UpdateIssueAndHistory(IssueInfoEntity issueInfoEntity) { if (!CheckIssueLinkGo(issueInfoEntity)) { issueInfoEntity.Result = 2; return issueInfoEntity; } if (!CheckIssueAsTo(issueInfoEntity)) { issueInfoEntity.Result = 3; return issueInfoEntity; } IssueInfoDBEntity dbParm = (issueInfoEntity.IssueInfoDBEntity.Count > 0) ? issueInfoEntity.IssueInfoDBEntity[0] : new IssueInfoDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("UpdateIssueManager"); cmd.SetParameterValue("@IssueID", dbParm.IssueID); cmd.SetParameterValue("@Title", dbParm.Title); cmd.SetParameterValue("@Priority", dbParm.Priority); cmd.SetParameterValue("@IssueType", dbParm.IssueType); cmd.SetParameterValue("@Assignto", dbParm.Assignto); cmd.SetParameterValue("@IssueStatus", dbParm.Status); cmd.SetParameterValue("@IsIndemnify", dbParm.IsIndemnify); cmd.SetParameterValue("@IndemnifyPrice", dbParm.IndemnifyPrice); cmd.SetParameterValue("@TicketCode", (String.IsNullOrEmpty(dbParm.TicketCode.Trim())) ? "" : dbParm.TicketCode.Substring(0, dbParm.TicketCode.IndexOf('-')).Trim()); cmd.SetParameterValue("@TicketAmount", (String.IsNullOrEmpty(dbParm.TicketCode.Trim())) ? "" : dbParm.TicketCode.Substring(dbParm.TicketCode.IndexOf('-') + 1).Trim()); cmd.SetParameterValue("@RelatedType", dbParm.RelatedType); cmd.SetParameterValue("@RelatedID", dbParm.RelatedID); cmd.SetParameterValue("@Remark", dbParm.Remark); cmd.SetParameterValue("@UpdateUser", issueInfoEntity.LogMessages.Userid); cmd.SetParameterValue("@UpdateTime", dbParm.UpdateTime); cmd.SetParameterValue("@TimeDiffTal", dbParm.TimeDiffTal); cmd.SetParameterValue("@TimeSpans", dbParm.TimeSpans); cmd.ExecuteNonQuery(); //InsertIssueHistory(issueInfoEntity); issueInfoEntity.Result = 1; return issueInfoEntity; }
public static IssueInfoEntity ReviewOverTimeOrderList(IssueInfoEntity issueInfoEntity) { IssueInfoDBEntity dbParm = (issueInfoEntity.IssueInfoDBEntity.Count > 0) ? issueInfoEntity.IssueInfoDBEntity[0] : new IssueInfoDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("ReviewOverTimeOrderList"); cmd.SetParameterValue("@HotelID", dbParm.HotelID); cmd.SetParameterValue("@PriceCode", dbParm.PriceCode); cmd.SetParameterValue("@StartDTime", dbParm.StartDTime); cmd.SetParameterValue("@EndDTime", dbParm.EndDTime); cmd.SetParameterValue("@PageCurrent", issueInfoEntity.PageCurrent - 1); cmd.SetParameterValue("@PageSize", issueInfoEntity.PageSize); DataSet dsResult = cmd.ExecuteDataSet(); for (int i = 0; i < dsResult.Tables[0].Rows.Count;i++ ) { dsResult.Tables[0].Rows[i]["cancel_reason"] = GetCancleReason(dsResult.Tables[0].Rows[i]["cancel_reason"].ToString()); } issueInfoEntity.QueryResult = dsResult; issueInfoEntity.TotalCount = (int)cmd.GetParameterValue("@TotalCount"); return issueInfoEntity; }
public static int InsertIssueHistory(IssueInfoEntity issueInfoEntity) { IssueInfoDBEntity dbParm = (issueInfoEntity.IssueInfoDBEntity.Count > 0) ? issueInfoEntity.IssueInfoDBEntity[0] : new IssueInfoDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("InsertIssueHistory"); cmd.SetParameterValue("@IssueID", dbParm.IssueID); cmd.SetParameterValue("@Title", dbParm.Title); cmd.SetParameterValue("@Priority", dbParm.Priority); cmd.SetParameterValue("@IssueType", dbParm.IssueType); cmd.SetParameterValue("@Assignto", dbParm.Assignto); cmd.SetParameterValue("@IssueStatus", dbParm.Status); cmd.SetParameterValue("@IsIndemnify", dbParm.IsIndemnify); cmd.SetParameterValue("@IndemnifyPrice", dbParm.IndemnifyPrice); cmd.SetParameterValue("@TicketCode", (String.IsNullOrEmpty(dbParm.TicketCode.Trim())) ? "" : dbParm.TicketCode.Substring(0, dbParm.TicketCode.IndexOf('-')).Trim()); cmd.SetParameterValue("@TicketAmount", (String.IsNullOrEmpty(dbParm.TicketCode.Trim())) ? "" : dbParm.TicketCode.Substring(dbParm.TicketCode.IndexOf('-') + 1).Trim()); cmd.SetParameterValue("@RelatedType", dbParm.RelatedType); cmd.SetParameterValue("@RelatedID", dbParm.RelatedID); cmd.SetParameterValue("@Remark", dbParm.HisRemark); cmd.SetParameterValue("@CreateUser", issueInfoEntity.LogMessages.Userid); cmd.SetParameterValue("@CreateTime", dbParm.UpdateTime); cmd.SetParameterValue("@ChkMsgAssgin", dbParm.ChkMsgAssgin); cmd.SetParameterValue("@MsgAssginText", dbParm.MsgAssginText); cmd.SetParameterValue("@MsgAssginRs", dbParm.MsgAssginRs); cmd.SetParameterValue("@ChkMsgUser", dbParm.ChkMsgUser); cmd.SetParameterValue("@MsgUserText", dbParm.MsgUserText); cmd.SetParameterValue("@MsgUserRs", dbParm.MsgUserRs); return cmd.ExecuteNonQuery(); }
public static IssueInfoEntity GetUpdateIssueDetail(IssueInfoEntity issueInfoEntity) { IssueInfoDBEntity dbParm = (issueInfoEntity.IssueInfoDBEntity.Count > 0) ? issueInfoEntity.IssueInfoDBEntity[0] : new IssueInfoDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("GetUpdateIssueDetail"); cmd.SetParameterValue("@IssueID", dbParm.IssueID); issueInfoEntity.QueryResult = cmd.ExecuteDataSet(); return issueInfoEntity; }
public static IssueInfoEntity GetIssueHistoryList(IssueInfoEntity issueInfoEntity) { IssueInfoDBEntity dbParm = (issueInfoEntity.IssueInfoDBEntity.Count > 0) ? issueInfoEntity.IssueInfoDBEntity[0] : new IssueInfoDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("GetIssueHistoryList"); cmd.SetParameterValue("@IssueID", dbParm.IssueID); DataSet dsResult = cmd.ExecuteDataSet(); if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { for (int i = 0; i < dsResult.Tables[0].Rows.Count; i++) { dsResult.Tables[0].Rows[i]["IssueTypeNM"] = SetIssueTypeNM(dsResult.Tables[0].Rows[i]["IssueType"].ToString().Trim()); dsResult.Tables[0].Rows[i]["TicketPage"] = String.IsNullOrEmpty(dsResult.Tables[0].Rows[i]["TicketCode"].ToString().Trim()) ? "" : dsResult.Tables[0].Rows[i]["TicketCode"].ToString().Trim() + "-" + dsResult.Tables[0].Rows[i]["TicketAmount"].ToString().Trim(); if (i < dsResult.Tables[0].Rows.Count - 1) { dsResult.Tables[0].Rows[i]["ActionTime"] = SetTimeLag(dsResult.Tables[0].Rows[i + 1]["CreateTime"].ToString().Trim(), dsResult.Tables[0].Rows[i]["CreateTime"].ToString().Trim()); } } } issueInfoEntity.QueryResult = dsResult; return issueInfoEntity; }
private void BindReviewHotelPlanListGrid() { _issueinfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _issueinfoEntity.LogMessages.Userid = UserSession.Current.UserAccount; _issueinfoEntity.LogMessages.Username = UserSession.Current.UserDspName; _issueinfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _issueinfoEntity.IssueInfoDBEntity = new List<IssueInfoDBEntity>(); IssueInfoDBEntity issueinfoEntity = new IssueInfoDBEntity(); issueinfoEntity.HotelID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["HotelID"].ToString())) ? null : ViewState["HotelID"].ToString(); issueinfoEntity.PriceCode = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["PriceCode"].ToString())) ? null : ViewState["PriceCode"].ToString(); issueinfoEntity.StartDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["StartDTime"].ToString())) ? null : ViewState["StartDTime"].ToString(); issueinfoEntity.EndDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["EndDTime"].ToString())) ? null : ViewState["EndDTime"].ToString(); _issueinfoEntity.IssueInfoDBEntity.Add(issueinfoEntity); _issueinfoEntity.PageCurrent = AspNetPager1.CurrentPageIndex; _issueinfoEntity.PageSize = gridViewCSReviewList.PageSize; _issueinfoEntity.SortField = gridViewCSReviewList.Attributes["SortExpression"].ToString(); _issueinfoEntity.SortType = gridViewCSReviewList.Attributes["SortDirection"].ToString(); _issueinfoEntity = IssueInfoBP.ReviewOverTimeOrderList(_issueinfoEntity); DataSet dsResult = _issueinfoEntity.QueryResult; gridViewCSReviewList.DataSource = dsResult.Tables[0].DefaultView; gridViewCSReviewList.DataKeyNames = new string[] { "fog_order_num" };//主键 gridViewCSReviewList.DataBind(); AspNetPager1.PageSize = gridViewCSReviewList.PageSize; AspNetPager1.RecordCount = _issueinfoEntity.TotalCount; this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true); }
public static IssueInfoEntity GetIssueSettingHistory(IssueInfoEntity issueInfoEntity) { IssueInfoDBEntity dbParm = (issueInfoEntity.IssueInfoDBEntity.Count > 0) ? issueInfoEntity.IssueInfoDBEntity[0] : new IssueInfoDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("GetIssueSettingHistory"); //cmd.SetParameterValue("@HotelID", dbParm.HotelID); issueInfoEntity.QueryResult = cmd.ExecuteDataSet(); return issueInfoEntity; }
private void BindReviewIssueListGrid() { _issueinfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _issueinfoEntity.LogMessages.Userid = UserSession.Current.UserAccount; _issueinfoEntity.LogMessages.Username = UserSession.Current.UserDspName; _issueinfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _issueinfoEntity.IssueInfoDBEntity = new List<IssueInfoDBEntity>(); IssueInfoDBEntity appcontentDBEntity = new IssueInfoDBEntity(); appcontentDBEntity.StartDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["StartDTime"].ToString())) ? null : ViewState["StartDTime"].ToString(); appcontentDBEntity.EndDTime = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["EndDTime"].ToString())) ? null : ViewState["EndDTime"].ToString(); appcontentDBEntity.Title = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Title"].ToString())) ? null : ViewState["Title"].ToString(); appcontentDBEntity.Status = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Status"].ToString())) ? null : ViewState["Status"].ToString(); appcontentDBEntity.IssueType = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["IssueType"].ToString())) ? null : ViewState["IssueType"].ToString(); appcontentDBEntity.Assignto = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["Assignto"].ToString())) ? null : ViewState["Assignto"].ToString(); appcontentDBEntity.RelatedType = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["RelatedType"].ToString())) ? null : ViewState["RelatedType"].ToString(); appcontentDBEntity.RelatedID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["RelatedID"].ToString())) ? null : ViewState["RelatedID"].ToString(); appcontentDBEntity.TimeSpans = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["TimeSpans"].ToString())) ? null : ViewState["TimeSpans"].ToString(); _issueinfoEntity.IssueInfoDBEntity.Add(appcontentDBEntity); _issueinfoEntity.PageCurrent = AspNetPager1.CurrentPageIndex; _issueinfoEntity.PageSize = gridViewCSReviewList.PageSize; _issueinfoEntity.SortField = gridViewCSReviewList.Attributes["SortExpression"].ToString(); _issueinfoEntity.SortType = gridViewCSReviewList.Attributes["SortDirection"].ToString(); _issueinfoEntity = IssueInfoBP.BindIssueList(_issueinfoEntity); DataSet dsResult = _issueinfoEntity.QueryResult; gridViewCSReviewList.DataSource = dsResult.Tables[0].DefaultView; gridViewCSReviewList.DataKeyNames = new string[] { "IssueID" };//主键 gridViewCSReviewList.DataBind(); AspNetPager1.PageSize = gridViewCSReviewList.PageSize; AspNetPager1.RecordCount = _issueinfoEntity.TotalCount; this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true); }
private void CreateIssue(string orderID) { CommonEntity _commonEntity = new CommonEntity(); IssueInfoEntity _issueinfoEntity = new IssueInfoEntity(); _issueinfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _issueinfoEntity.LogMessages.Userid = UserSession.Current.UserAccount; _issueinfoEntity.LogMessages.Username = UserSession.Current.UserDspName; _issueinfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _issueinfoEntity.IssueInfoDBEntity = new List<IssueInfoDBEntity>(); IssueInfoDBEntity issueinfoDBEntity = new IssueInfoDBEntity(); issueinfoDBEntity.IssueID = ""; issueinfoDBEntity.ActionType = "0"; DataSet dsOrderInfo = GetOrderInfoData(orderID); if (dsOrderInfo.Tables.Count == 0 || dsOrderInfo.Tables[0].Rows.Count == 0) { dvErrorInfo.InnerHtml = GetLocalResourceObject("IssueError81").ToString(); return; } issueinfoDBEntity.Title = "[" + dsOrderInfo.Tables[0].Rows[0]["HOTELNM"].ToString() + "]订单审核问题"; issueinfoDBEntity.Priority = "0"; issueinfoDBEntity.IssueType = "8"; issueinfoDBEntity.AssignNm = (String.IsNullOrEmpty(dsOrderInfo.Tables[0].Rows[0]["SALESNM"].ToString())) ? ConfigurationManager.AppSettings["DefaultissueNm"].ToString() : dsOrderInfo.Tables[0].Rows[0]["SALESNM"].ToString(); issueinfoDBEntity.Assignto = (String.IsNullOrEmpty(dsOrderInfo.Tables[0].Rows[0]["SALESMG"].ToString())) ? ConfigurationManager.AppSettings["DefaultissueTo"].ToString() : dsOrderInfo.Tables[0].Rows[0]["SALESMG"].ToString(); issueinfoDBEntity.Status = "0"; issueinfoDBEntity.IsIndemnify = "0"; issueinfoDBEntity.IndemnifyPrice = ""; issueinfoDBEntity.RelatedType = "0"; issueinfoDBEntity.RelatedID = orderID; issueinfoDBEntity.TicketCode = ""; issueinfoDBEntity.Remark = ""; issueinfoDBEntity.HisRemark = ""; issueinfoDBEntity.UpdateUser = UserSession.Current.UserDspName; string dtNow = DateTime.Now.ToString(); issueinfoDBEntity.TimeDiffTal = ""; issueinfoDBEntity.TimeSpans = ""; issueinfoDBEntity.UpdateTime = dtNow; issueinfoDBEntity.ChkMsgAssgin = "0"; issueinfoDBEntity.MsgAssginText = ""; issueinfoDBEntity.ChkMsgUser = "******"; issueinfoDBEntity.MsgUserText = ""; _issueinfoEntity.IssueInfoDBEntity.Add(issueinfoDBEntity); _issueinfoEntity = IssueInfoBP.IssueSave(_issueinfoEntity); int iResult = _issueinfoEntity.Result; string strIssueID = _issueinfoEntity.IssueInfoDBEntity[0].IssueID; _commonEntity.LogMessages = _issueinfoEntity.LogMessages; _commonEntity.CommonDBEntity = new List<CommonDBEntity>(); CommonDBEntity commonDBEntity = new CommonDBEntity(); commonDBEntity.Event_Type = "Issue问题单-保存"; commonDBEntity.Event_ID = strIssueID; string conTent = GetLocalResourceObject("EventIssueInsertMessage").ToString(); conTent = string.Format(conTent, strIssueID, issueinfoDBEntity.Title, issueinfoDBEntity.Priority, issueinfoDBEntity.IssueType, issueinfoDBEntity.Assignto, issueinfoDBEntity.Status, issueinfoDBEntity.IsIndemnify, issueinfoDBEntity.IndemnifyPrice, issueinfoDBEntity.TicketCode, issueinfoDBEntity.RelatedType, issueinfoDBEntity.RelatedID, issueinfoDBEntity.Remark, _issueinfoEntity.LogMessages.Username); commonDBEntity.Event_Content = conTent; if (iResult == 1) { commonDBEntity.Event_Result = GetLocalResourceObject("InsertIssueSuccess").ToString(); dvErrorInfo.InnerHtml = GetLocalResourceObject("InsertIssueSuccess").ToString(); IssueInfoBP.SendMail(_issueinfoEntity); } else if (iResult == 2) { commonDBEntity.Event_Result = GetLocalResourceObject("IssueError6").ToString(); dvErrorInfo.InnerHtml = GetLocalResourceObject("IssueError6").ToString(); } else if (iResult == 3) { commonDBEntity.Event_Result = GetLocalResourceObject("IssueError8").ToString(); dvErrorInfo.InnerHtml = GetLocalResourceObject("IssueError8").ToString(); } else { commonDBEntity.Event_Result = GetLocalResourceObject("IssueError4").ToString() + _issueinfoEntity.ErrorMSG; dvErrorInfo.InnerHtml = GetLocalResourceObject("IssueError4").ToString() + _issueinfoEntity.ErrorMSG; } _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); }