/// <summary> /// 初始化编辑信息 /// </summary> void InitEditInfo() { EditInfo = new EyouSoft.BLL.PlanStructure.BJiDiaoAnPaiBianGeng().GetInfo(AnPaiId, BianGengLeiXing, JiaJianLeiXing); EditXgInfo = new EyouSoft.BLL.PlanStructure.BJiDiaoAnPaiBianGeng().GetXgInfo(AnPaiId); if (EditXgInfo == null) { return; } if (EditInfo != null) { if (EditXgInfo.AnPaiLeiXing == EyouSoft.Model.EnumType.PlanStructure.PlanProject.国内游轮 || EditXgInfo.AnPaiLeiXing == EyouSoft.Model.EnumType.PlanStructure.PlanProject.涉外游轮) { txtRenShu.Value = EditInfo.DRenShu.ToString("F2"); } else { txtRenShu.Value = EditInfo.RenShu.ToString(); } txtJinE.Value = EditInfo.JinE.ToString("F2"); txtBeiZhu.Value = EditInfo.BeiZhu; } txtFeiYongMingXi.Value = EditXgInfo.FeiYongMingXi; ltrAnPaiLeiXing.Text = EditXgInfo.AnPaiLeiXing.ToString(); txtAnPaiLeiXing.Value = ((int)EditXgInfo.AnPaiLeiXing).ToString(); if (EditXgInfo.AnPaiLeiXing == EyouSoft.Model.EnumType.PlanStructure.PlanProject.导游) { ltrGysTitle.Text = "导游姓名"; ltrGysName.Text = EditXgInfo.GysName + " 电话:" + EditXgInfo.GysLxrTelephone; } else { ltrGysName.Text = EditXgInfo.GysName + " 联系人:" + EditXgInfo.GysLxrName + " 电话:" + EditXgInfo.GysLxrTelephone; } InitDaoYouBaoZhangCaoZuo(); InitXiaoShouBaoZhangCaoZuo(); InitJiDiaoBaoZhangCaoZuo(); if (BianGengLeiXing != "jidiao") { txtFeiYongMingXi.Attributes.Add("readonly", "readonly"); txtFeiYongMingXi.Attributes.Add("style", "background:#dadada;"); } }
/// <summary> /// 获取计调安排变更相关信息业务实体 /// </summary> /// <param name="anPaiId">安排编号</param> /// <returns></returns> public EyouSoft.Model.PlanStructure.MJiDiaoAnPaiBianGengXgInfo GetXgInfo(string anPaiId) { EyouSoft.Model.PlanStructure.MJiDiaoAnPaiBianGengXgInfo info = null; #region sql StringBuilder sql = new StringBuilder(); sql.Append("SELECT "); sql.Append(" B.CostDetail AS FeiYongMingXi "); sql.Append(" ,C.SellerId AS TourXiaoShouYuanId "); sql.Append(" ,C.TourStatus "); sql.Append(" ,(SELECT PlanerId FROM tbl_TourPlaner AS A1 WHERE A1.TourId=C.TourId FOR XML RAW,ROOT('root')) AS TourJiDiaoXml "); sql.Append(" ,(SELECT GuideUserId FROM tbl_Plan AS A1 WHERE A1.TourId=C.TourId AND A1.Type=12 AND A1.IsDelete='0' FOR XML RAW,ROOT('root')) AS TourDaoYouXml "); sql.Append(" ,C.TourId "); sql.Append(" ,B.PaymentType AS ZhiFuFangShi "); sql.Append(" ,B.SourceName AS GysName "); sql.Append(" ,B.Type AS AnPaiLeiXing "); sql.Append(" ,B.ContactName AS GysLxrName "); sql.Append(" ,B.ContactPhone AS GysLxrTelephone "); sql.Append(" FROM [tbl_Plan] AS B INNER JOIN [tbl_Tour] AS C ON B.[TourId]=C.[TourId] "); sql.Append(" WHERE B.PlanId=@AnPaiId "); #endregion DbCommand cmd = _db.GetSqlStringCommand(sql.ToString()); _db.AddInParameter(cmd, "AnPaiId", DbType.AnsiStringFixedLength, anPaiId); using (IDataReader rdr = DbHelper.ExecuteReader(cmd, _db)) { if (rdr.Read()) { info = new EyouSoft.Model.PlanStructure.MJiDiaoAnPaiBianGengXgInfo(); info.AnPaiId = anPaiId; info.FeiYongMingXi = rdr["FeiYongMingXi"].ToString(); info.TourDaoYous = new List <string>(); info.TourId = rdr.GetString(rdr.GetOrdinal("TourId")); info.TourJiDiaos = new List <string>(); info.TourStatus = (EyouSoft.Model.EnumType.TourStructure.TourStatus)rdr.GetByte(rdr.GetOrdinal("TourStatus")); info.TourXiaShouYuanId = rdr["TourXiaoShouYuanId"].ToString(); info.ZhiFuFangShi = (EyouSoft.Model.EnumType.PlanStructure.Payment)rdr.GetByte(rdr.GetOrdinal("ZhiFuFangShi")); info.GysName = rdr["GysName"].ToString(); info.AnPaiLeiXing = (EyouSoft.Model.EnumType.PlanStructure.PlanProject)rdr.GetByte(rdr.GetOrdinal("AnPaiLeiXing")); info.GysLxrName = rdr["GysLxrName"].ToString(); info.GysLxrTelephone = rdr["GysLxrTelephone"].ToString(); string xml1 = rdr["TourJiDiaoXml"].ToString(); string xml2 = rdr["TourDaoYouXml"].ToString(); if (!string.IsNullOrEmpty(xml1)) { var xroot = XElement.Parse(xml1); var xrows = Utils.GetXElements(xroot, "row"); foreach (var xrow in xrows) { info.TourJiDiaos.Add(Utils.GetXAttributeValue(xrow, "PlanerId")); } } if (!string.IsNullOrEmpty(xml2)) { var xroot = XElement.Parse(xml2); var xrows = Utils.GetXElements(xroot, "row"); foreach (var xrow in xrows) { info.TourDaoYous.Add(Utils.GetXAttributeValue(xrow, "GuideUserId")); } } } } return(info); }