예제 #1
0
        /// <summary>
        /// create dikou xml
        /// </summary>
        /// <param name="items"></param>
        /// <returns></returns>
        string CreateDiKouXml(EyouSoft.Model.YlStructure.MHangQiDingDanDiKouInfo info)
        {
            StringBuilder xml = new StringBuilder();

            xml.Append("<root>");

            if (info != null)
            {
                xml.AppendFormat("<info JiFen=\"{0}\" ", info.JiFen);
                xml.AppendFormat(" JiFenBiLi=\"{0}\" ", info.JiFenBiLi);
                xml.AppendFormat(" JinFenJinE=\"{0}\" ", info.JinFenJinE);
                xml.AppendFormat(" LiPinKaJinE=\"{0}\" ", info.LiPinKaJinE);
                xml.AppendFormat(">");
                xml.AppendFormat("</info>");
            }

            xml.Append("</root>");

            return(xml.ToString());
        }
예제 #2
0
        /// <summary>
        /// get dikou info
        /// </summary>
        /// <param name="dingDanId"></param>
        /// <returns></returns>
        EyouSoft.Model.YlStructure.MHangQiDingDanDiKouInfo GetDiKouInfo(string dingDanId)
        {
            EyouSoft.Model.YlStructure.MHangQiDingDanDiKouInfo info = null;
            DbCommand cmd = _db.GetSqlStringCommand(SQL_SELECT_GetDiKouInfo);

            _db.AddInParameter(cmd, "DingDanId", DbType.AnsiStringFixedLength, dingDanId);

            using (var rdr = DbHelper.ExecuteReader(cmd, _db))
            {
                if (rdr.Read())
                {
                    info             = new EyouSoft.Model.YlStructure.MHangQiDingDanDiKouInfo();
                    info.JiFen       = rdr.GetDecimal(rdr.GetOrdinal("JiFen"));
                    info.JiFenBiLi   = rdr.GetDecimal(rdr.GetOrdinal("JiFenBiLi"));
                    info.JinFenJinE  = rdr.GetDecimal(rdr.GetOrdinal("JinFenJinE"));
                    info.LiPinKaJinE = rdr.GetDecimal(rdr.GetOrdinal("LiPinKaJinE"));
                }
            }

            return(info);
        }