/// <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> /// <param name="bianGengLeiXing">变更类型</param> /// <param name="jiaJianLeiXing">加减类型</param> /// <returns></returns> public EyouSoft.Model.PlanStructure.MJiDiaoAnPaiBianGengInfo GetInfo(string anPaiId, EyouSoft.Model.EnumType.PlanStructure.PlanChangeChangeClass bianGengLeiXing, string jiaJianLeiXing) { EyouSoft.Model.PlanStructure.MJiDiaoAnPaiBianGengInfo info = null; #region sql StringBuilder sql = new StringBuilder(); sql.Append("SELECT A.* "); sql.Append(" FROM [tbl_PlanCostChange] AS A "); sql.Append(" WHERE A.PlanId=@AnPaiId AND A.ChangeType=@BianBengLeiXing "); if (jiaJianLeiXing == "jia") { sql.Append(" AND A.Type='1' "); } else { sql.Append(" AND A.Type='0' "); } #endregion DbCommand cmd = _db.GetSqlStringCommand(sql.ToString()); _db.AddInParameter(cmd, "AnPaiId", DbType.AnsiStringFixedLength, anPaiId); _db.AddInParameter(cmd, "BianBengLeiXing", DbType.Byte, bianGengLeiXing); using (IDataReader rdr = DbHelper.ExecuteReader(cmd, _db)) { if (rdr.Read()) { info = new EyouSoft.Model.PlanStructure.MJiDiaoAnPaiBianGengInfo(); info.AnPaiId = anPaiId; info.BeiZhu = rdr["Remark"].ToString(); info.BianGengLeiXing = bianGengLeiXing; info.JiaJianLeiXing = jiaJianLeiXing; info.JinE = rdr.GetDecimal(rdr.GetOrdinal("ChangeCost")); info.RenShu = rdr.GetInt32(rdr.GetOrdinal("PeopleNumber")); info.DRenShu = rdr.GetDecimal(rdr.GetOrdinal("DNum")); } } return(info); }