/// <summary> /// 新增礼品卡订单,返回1成功,其它失败 /// </summary> /// <param name="info">实体</param> /// <returns></returns> public int LiPinKaDingDan_C(EyouSoft.Model.YlStructure.MLiPinKaDingDanInfo info) { DbCommand cmd = _db.GetStoredProcCommand("proc_YL_LiPinKaDingDan_C"); _db.AddInParameter(cmd, "@LiPinKaId", DbType.AnsiStringFixedLength, info.LiPinKaId); _db.AddInParameter(cmd, "@CompanyId", DbType.AnsiStringFixedLength, info.CompanyId); _db.AddInParameter(cmd, "@DingDanId", DbType.AnsiStringFixedLength, info.DingDanId); _db.AddInParameter(cmd, "@JiaoYiHao", DbType.String, info.JiaoYiHao); _db.AddInParameter(cmd, "@ShuLiang", DbType.Int32, info.ShuLiang); _db.AddInParameter(cmd, "@JinE", DbType.Decimal, info.JinE); _db.AddInParameter(cmd, "@JinE1", DbType.Decimal, info.JinE1); _db.AddInParameter(cmd, "@DingDanStatus", DbType.Byte, info.DingDanStatus); _db.AddInParameter(cmd, "@FuKuanStatus", DbType.Byte, info.FuKuanStatus); _db.AddInParameter(cmd, "@XiaDanBeiZhu", DbType.String, info.XiaDanBeiZhu); _db.AddInParameter(cmd, "@YuDingRenName", DbType.String, info.YuDingRenName); _db.AddInParameter(cmd, "@YuDingRenDianHua", DbType.String, info.YuDingRenDianHua); _db.AddInParameter(cmd, "@YuDingRenShouJi", DbType.String, info.YuDingRenShouJi); _db.AddInParameter(cmd, "@YuDingRenYouXiang", DbType.String, info.YuDingRenYouXiang); _db.AddInParameter(cmd, "@IsXuYaoFaPiao", DbType.AnsiStringFixedLength, info.IsXuYaoFaPiao?"1":"0"); _db.AddInParameter(cmd, "@FaPiaoTaiTou", DbType.String, info.FaPiaoTaiTou); _db.AddInParameter(cmd, "@FaPiaoLeiXing", DbType.String, info.FaPiaoLeiXing); _db.AddInParameter(cmd, "@FaPiaoMingXi", DbType.String, info.FaPiaoMingXi); _db.AddInParameter(cmd, "@FaPiaoPeiSongFangShi", DbType.Byte, info.FaPiaoPeiSongFangShi); _db.AddInParameter(cmd, "@FaPiaoDiZhiId", DbType.AnsiStringFixedLength, info.FaPiaoDiZhiId); _db.AddInParameter(cmd, "@FaPiaoKuaiDiJinE", DbType.Decimal, info.FaPiaoKuaiDiJinE); _db.AddInParameter(cmd, "@XiaDanRenId", DbType.AnsiStringFixedLength, info.XiaDanRenId); _db.AddInParameter(cmd, "@IssueTime", DbType.DateTime, info.IssueTime); _db.AddInParameter(cmd, "@ZengYu", DbType.String, info.ZengYu); _db.AddInParameter(cmd, "@SlrDiZhiId", DbType.AnsiStringFixedLength, info.SlrDiZhiId); _db.AddInParameter(cmd, "@LiPinKaKuaiDiJinE", DbType.Decimal, info.LiPinKaKuaiDiJinE); _db.AddOutParameter(cmd, "@RetCode", DbType.Int32, 4); int sqlExceptionCode = 0; try { DbHelper.RunProcedure(cmd, _db); } catch (System.Data.SqlClient.SqlException e) { sqlExceptionCode = 0 - e.Number; } if (sqlExceptionCode < 0) { return(sqlExceptionCode); } else { return(Convert.ToInt32(_db.GetParameterValue(cmd, "RetCode"))); } }
/// <summary> /// 新增礼品卡订单,返回1成功,其它失败 /// </summary> /// <param name="info">实体</param> /// <returns></returns> public int InsertLiPinKaDingDan(EyouSoft.Model.YlStructure.MLiPinKaDingDanInfo info) { if (info == null || string.IsNullOrEmpty(info.CompanyId) || string.IsNullOrEmpty(info.LiPinKaId) || string.IsNullOrEmpty(info.XiaDanRenId)) { return(0); } int dalRetCode = dal.LiPinKaDingDan_C(info); return(dalRetCode); }
/// <summary> /// 获取礼品卡订单信息 /// </summary> /// <param name="dingDanId">订单编号</param> /// <returns></returns> public EyouSoft.Model.YlStructure.MLiPinKaDingDanInfo GetLiPinKaDingDanInfo(string dingDanId) { EyouSoft.Model.YlStructure.MLiPinKaDingDanInfo info = null; DbCommand cmd = _db.GetSqlStringCommand(SQL_SELECT_GetLiPinKaDingDanInfo); _db.AddInParameter(cmd, "DingDanId", DbType.AnsiStringFixedLength, dingDanId); using (var rdr = DbHelper.ExecuteReader(cmd, _db)) { if (rdr.Read()) { info = new EyouSoft.Model.YlStructure.MLiPinKaDingDanInfo(); info.CompanyId = rdr["CompanyId"].ToString(); info.DingDanId = rdr["DingDanId"].ToString(); info.DingDanStatus = (EyouSoft.Model.EnumType.YlStructure.LiPinKaDingDanStatus)rdr.GetByte(rdr.GetOrdinal("DingDanStatus")); info.FaPiaoDiZhiId = rdr["FaPiaoDiZhiId"].ToString(); info.FaPiaoKuaiDiJinE = rdr.GetDecimal(rdr.GetOrdinal("FaPiaoKuaiDiJinE")); info.FaPiaoLeiXing = rdr["FaPiaoLeiXing"].ToString(); info.FaPiaoMingXi = rdr["FaPiaoMingXi"].ToString(); info.FaPiaoPeiSongFangShi = (EyouSoft.Model.EnumType.YlStructure.FaPiaoPeiSongFangShi)rdr.GetByte(rdr.GetOrdinal("FaPiaoPeiSongFangShi")); info.FaPiaoTaiTou = rdr["FaPiaoTaiTou"].ToString(); info.FuKuanStatus = (EyouSoft.Model.EnumType.YlStructure.FuKuanStatus)rdr.GetByte(rdr.GetOrdinal("FuKuanStatus")); info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")); info.IsXuYaoFaPiao = rdr["IsXuYaoFaPiao"].ToString() == "1"; info.JiaoYiHao = rdr["JiaoYiHao"].ToString(); info.JinE = rdr.GetDecimal(rdr.GetOrdinal("JinE")); info.JinE1 = rdr.GetDecimal(rdr.GetOrdinal("JinE1")); info.LiPinKaId = rdr["LiPinKaId"].ToString(); info.LiPinKaKuaiDiJinE = rdr.GetDecimal(rdr.GetOrdinal("LiPinKaKuaiDiJinE")); info.ShuLiang = rdr.GetInt32(rdr.GetOrdinal("ShuLiang")); info.SlrDiZhiId = rdr["SlrDiZhiId"].ToString(); info.XiaDanBeiZhu = rdr["XiaDanBeiZhu"].ToString(); info.XiaDanRenId = rdr["XiaDanRenId"].ToString(); info.YuDingRenDianHua = rdr["YuDingRenDianHua"].ToString(); info.YuDingRenName = rdr["YuDingRenName"].ToString(); info.YuDingRenShouJi = rdr["YuDingRenShouJi"].ToString(); info.YuDingRenYouXiang = rdr["YuDingRenYouXiang"].ToString(); info.ZengYu = rdr["ZengYu"].ToString(); info.LiPinKaLeiXing = (EyouSoft.Model.EnumType.YlStructure.LiPinKaLeiXing)rdr.GetByte(rdr.GetOrdinal("LiPinKaLeiXing")); info.LiPinKaMingCheng = rdr["LiPinKaMingCheng"].ToString(); info.HuiYuanXingMing = rdr["HuiYuanXingMing"].ToString(); } } return(info); }
/// <summary> /// 获取礼品卡订单集合 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="pageSize">页记录数</param> /// <param name="pageIndex">页序号</param> /// <param name="recordCount">总记录数</param> /// <param name="chaXun">查询</param> /// <returns></returns> public IList <EyouSoft.Model.YlStructure.MLiPinKaDingDanInfo> GetLiPinKaDingDans(string companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.YlStructure.MLiPinKaDingDanChaXunInfo chaXun) { IList <EyouSoft.Model.YlStructure.MLiPinKaDingDanInfo> items = new List <EyouSoft.Model.YlStructure.MLiPinKaDingDanInfo>(); string tableName = "view_YL_LiPinKaDingDan"; string fields = "*"; string orderByString = "IssueTime DESC"; string sumString = string.Empty; StringBuilder sql = new StringBuilder(); sql.AppendFormat(" CompanyId='{0}' ", companyId); if (chaXun != null) { if (!string.IsNullOrEmpty(chaXun.HuiYuanId)) { sql.AppendFormat(" AND XiaDanRenId='{0}' ", chaXun.HuiYuanId); } if (!string.IsNullOrEmpty(chaXun.JiaoYiHao)) { sql.AppendFormat(" AND JiaoYiHao LIKE '%{0}%' ", chaXun.JiaoYiHao); } if (!string.IsNullOrEmpty(chaXun.LiPinKaMingCheng)) { sql.AppendFormat(" AND LiPinKaMingCheng LIKE '%{0}%' ", chaXun.LiPinKaMingCheng); } if (chaXun.LiPinKaLeiXing.HasValue) { sql.AppendFormat(" AND LiPinKaLeiXing={0} ", (int)chaXun.LiPinKaLeiXing.Value); } if (chaXun.XiaDanShiJian1.HasValue) { sql.AppendFormat(" AND IssueTime>='{0}' ", chaXun.XiaDanShiJian1.Value); } if (chaXun.XiaDanShiJian2.HasValue) { sql.AppendFormat(" AND IssueTime<='{0}' ", chaXun.XiaDanShiJian2.Value.AddDays(1).AddMinutes(-1)); } } using (IDataReader rdr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields.ToString(), sql.ToString(), orderByString, sumString)) { while (rdr.Read()) { var info = new EyouSoft.Model.YlStructure.MLiPinKaDingDanInfo(); info.CompanyId = rdr["CompanyId"].ToString(); info.DingDanId = rdr["DingDanId"].ToString(); info.DingDanStatus = (EyouSoft.Model.EnumType.YlStructure.LiPinKaDingDanStatus)rdr.GetByte(rdr.GetOrdinal("DingDanStatus")); info.FaPiaoDiZhiId = rdr["FaPiaoDiZhiId"].ToString(); info.FaPiaoKuaiDiJinE = rdr.GetDecimal(rdr.GetOrdinal("FaPiaoKuaiDiJinE")); info.FaPiaoLeiXing = rdr["FaPiaoLeiXing"].ToString(); info.FaPiaoMingXi = rdr["FaPiaoMingXi"].ToString(); info.FaPiaoPeiSongFangShi = (EyouSoft.Model.EnumType.YlStructure.FaPiaoPeiSongFangShi)rdr.GetByte(rdr.GetOrdinal("FaPiaoPeiSongFangShi")); info.FaPiaoTaiTou = rdr["FaPiaoTaiTou"].ToString(); info.FuKuanStatus = (EyouSoft.Model.EnumType.YlStructure.FuKuanStatus)rdr.GetByte(rdr.GetOrdinal("FuKuanStatus")); info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")); info.IsXuYaoFaPiao = rdr["IsXuYaoFaPiao"].ToString() == "1"; info.JiaoYiHao = rdr["JiaoYiHao"].ToString(); info.JinE = rdr.GetDecimal(rdr.GetOrdinal("JinE")); info.JinE1 = rdr.GetDecimal(rdr.GetOrdinal("JinE1")); info.LiPinKaId = rdr["LiPinKaId"].ToString(); info.LiPinKaKuaiDiJinE = rdr.GetDecimal(rdr.GetOrdinal("LiPinKaKuaiDiJinE")); info.ShuLiang = rdr.GetInt32(rdr.GetOrdinal("ShuLiang")); info.SlrDiZhiId = rdr["SlrDiZhiId"].ToString(); info.XiaDanBeiZhu = rdr["XiaDanBeiZhu"].ToString(); info.XiaDanRenId = rdr["XiaDanRenId"].ToString(); info.YuDingRenDianHua = rdr["YuDingRenDianHua"].ToString(); info.YuDingRenName = rdr["YuDingRenName"].ToString(); info.YuDingRenShouJi = rdr["YuDingRenShouJi"].ToString(); info.YuDingRenYouXiang = rdr["YuDingRenYouXiang"].ToString(); info.ZengYu = rdr["ZengYu"].ToString(); info.LiPinKaLeiXing = (EyouSoft.Model.EnumType.YlStructure.LiPinKaLeiXing)rdr.GetByte(rdr.GetOrdinal("LiPinKaLeiXing")); info.LiPinKaMingCheng = rdr["LiPinKaMingCheng"].ToString(); info.HuiYuanXingMing = rdr["HuiYuanXingMing"].ToString(); items.Add(info); } } return(items); }