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