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