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