Пример #1
0
        /// <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 + "&nbsp;&nbsp; 电话:" + EditXgInfo.GysLxrTelephone;
            }
            else
            {
                ltrGysName.Text = EditXgInfo.GysName + "&nbsp;&nbsp;联系人:" + EditXgInfo.GysLxrName + "&nbsp;&nbsp; 电话:" + EditXgInfo.GysLxrTelephone;
            }

            InitDaoYouBaoZhangCaoZuo();
            InitXiaoShouBaoZhangCaoZuo();
            InitJiDiaoBaoZhangCaoZuo();

            if (BianGengLeiXing != "jidiao")
            {
                txtFeiYongMingXi.Attributes.Add("readonly", "readonly");
                txtFeiYongMingXi.Attributes.Add("style", "background:#dadada;");
            }
        }
Пример #2
0
        /// <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);
        }