/// <summary> /// 积分商品修改,返回1成功,其它失败 /// </summary> /// <param name="info"></param> /// <returns></returns> public int UpdateJiFenShangPin(EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo info) { if (info == null || string.IsNullOrEmpty(info.CompanyId) || string.IsNullOrEmpty(info.OperatorId) || info.FangShis == null || info.FangShis.Count == 0 || string.IsNullOrEmpty(info.ShangPinId)) { return(0); } info.IssueTime = DateTime.Now; int dalRetCode = dal.JiFenShangPin_CU(info); return(dalRetCode); }
/// <summary> /// 积分商品新增、修改,返回1成功,其它失败 /// </summary> /// <param name="info"></param> /// <returns></returns> public int JiFenShangPin_CU(EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo info) { DbCommand cmd = _db.GetStoredProcCommand("proc_YL_JiFenShangPin_CU"); _db.AddInParameter(cmd, "@ShangPinId", DbType.AnsiStringFixedLength, info.ShangPinId); _db.AddInParameter(cmd, "@CompanyId", DbType.AnsiStringFixedLength, info.CompanyId); _db.AddInParameter(cmd, "@MingCheng", DbType.String, info.MingCheng); _db.AddInParameter(cmd, "@ShuoMing", DbType.String, info.ShuoMing); _db.AddInParameter(cmd, "@XuZhi", DbType.String, info.XuZhi); _db.AddInParameter(cmd, "@OperatorId", DbType.AnsiStringFixedLength, info.OperatorId); _db.AddInParameter(cmd, "@IssueTime", DbType.DateTime, info.IssueTime); _db.AddInParameter(cmd, "@FuJianXml", DbType.String, CreateFuJianXml(info.FuJians)); _db.AddInParameter(cmd, "@FangShiXml", DbType.String, CreateJiFenShangPinFangShiXml(info.FangShis)); _db.AddInParameter(cmd, "@PeiSongFangShi", DbType.String, info.PeiSongFangShi); _db.AddInParameter(cmd, "@Status", DbType.Byte, info.Status); _db.AddInParameter(cmd, "@ShuLiang", DbType.Int32, info.ShuLiang); _db.AddInParameter(cmd, "@FaPiaoKuaiDiJinE", DbType.Decimal, info.FaPiaoKuaiDiJinE); _db.AddInParameter(cmd, "@ShangPinJinE", DbType.Decimal, info.ShangPinJinE); _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> /// 获取积分商品信息 /// </summary> /// <param name="shangPinId">商品编号</param> /// <returns></returns> public EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo GetJiFenShangPinInfo(string shangPinId) { EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo info = null; DbCommand cmd = _db.GetSqlStringCommand(SQL_SELECT_GetJiFenShangPinInfo); _db.AddInParameter(cmd, "@ShangPinId", DbType.AnsiStringFixedLength, shangPinId); using (var rdr = DbHelper.ExecuteReader(cmd, _db)) { if (rdr.Read()) { info = new EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo(); info.CompanyId = rdr["CompanyId"].ToString(); info.FangShis = null; info.FuJians = null; info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")); info.MingCheng = rdr["MingCheng"].ToString(); info.OperatorId = rdr["OperatorId"].ToString(); info.ShangPinId = rdr["ShangPinId"].ToString(); info.ShuoMing = rdr["ShuoMing"].ToString(); info.XuZhi = rdr["XuZhi"].ToString(); info.PeiSongFangShi = rdr["PeiSongFangShi"].ToString(); info.Status = (EyouSoft.Model.EnumType.YlStructure.JiFenShangPinStatus)rdr.GetByte(rdr.GetOrdinal("Status")); info.ShuLiang = rdr.GetInt32(rdr.GetOrdinal("ShuLiang")); info.ChengJiaoShuLiang = rdr.GetInt32(rdr.GetOrdinal("ChengJiaoShuLiang")); info.FaPiaoKuaiDiJinE = rdr.GetDecimal(rdr.GetOrdinal("FaPiaoKuaiDiJinE")); info.ShangPinJinE = rdr.GetDecimal(rdr.GetOrdinal("ShangPinJinE")); } } if (info != null) { info.FangShis = GetJiFenShangPinFangShis(info.ShangPinId); info.FuJians = GetJiFenShangPinFuJians(info.ShangPinId); } return(info); }
/// <summary> /// baocun /// </summary> void BaoCun() { var info = new EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo(); info.CompanyId = CurrentUserCompanyID; info.FangShis = new List <EyouSoft.Model.YlStructure.MWzJiFenShangPinFangShiInfo>(); info.FuJians = null; info.IssueTime = DateTime.Now; info.MingCheng = Utils.GetFormValue(txtMingCheng.UniqueID); info.OperatorId = SiteUserInfo.UserId; info.PeiSongFangShi = Utils.GetFormValue(txtPeiSongFangShi.UniqueID); info.ShangPinId = ShangPinId; info.ShuoMing = Utils.GetYlEditorText(Request.Form[txtShuoMing.UniqueID]); info.Status = Utils.GetEnumValue <EyouSoft.Model.EnumType.YlStructure.JiFenShangPinStatus>(Utils.GetFormValue("txtStatus"), EyouSoft.Model.EnumType.YlStructure.JiFenShangPinStatus.架); info.XuZhi = Utils.GetYlEditorText(Request.Form[txtXuZhi.UniqueID]); info.ShuLiang = Utils.GetInt(Utils.GetFormValue(txtShuLiang.UniqueID)); info.FaPiaoKuaiDiJinE = Utils.GetDecimal(Utils.GetFormValue(txtFaPiaoKuaiDiJinE.UniqueID)); info.ShangPinJinE = Utils.GetDecimal(Utils.GetFormValue(txtShangPinJinE.UniqueID)); var items1 = upload1.Files; var items2 = upload1.YuanFiles; var items3 = new List <EyouSoft.Model.YlStructure.MFuJianInfo>(); if (items1 != null && items1.Count > 0) { foreach (var item in items1) { var item1 = new EyouSoft.Model.YlStructure.MFuJianInfo(); item1.Filepath = item.FilePath; items3.Add(item1); } } if (items2 != null && items2.Count > 0) { foreach (var item in items2) { var item1 = new EyouSoft.Model.YlStructure.MFuJianInfo(); item1.Filepath = item.FilePath; items3.Add(item1); } } info.FuJians = items3; var fangShi1 = new EyouSoft.Model.YlStructure.MWzJiFenShangPinFangShiInfo(); var fangShi2 = new EyouSoft.Model.YlStructure.MWzJiFenShangPinFangShiInfo(); var fangShi3 = new EyouSoft.Model.YlStructure.MWzJiFenShangPinFangShiInfo(); decimal jiFen1 = Utils.GetDecimal(Utils.GetFormValue(txtJiFen1.UniqueID)); //decimal jiFen2 = Utils.GetDecimal(Utils.GetFormValue(txtJiFen2.UniqueID)); decimal jiFen3 = Utils.GetDecimal(Utils.GetFormValue(txtJiFen3.UniqueID)); //decimal jinE2 = Utils.GetDecimal(Utils.GetFormValue(txtJinE2.UniqueID)); decimal jinE3 = Utils.GetDecimal(Utils.GetFormValue(txtJinE3.UniqueID)); if (jiFen1 > 0) { fangShi1.FangShi = EyouSoft.Model.EnumType.YlStructure.JiFenDuiHuanFangShi.积分; fangShi1.JiFen = jiFen1; info.FangShis.Add(fangShi1); } /*if (jiFen2 > 0 || jinE2 > 0) * { * fangShi2.FangShi = EyouSoft.Model.EnumType.YlStructure.JiFenDuiHuanFangShi.积分礼品卡; * fangShi2.JiFen = jiFen2; * fangShi2.JinE = jinE2; * * info.FangShis.Add(fangShi2); * }*/ if (jiFen3 > 0 || jinE3 > 0) { fangShi3.FangShi = EyouSoft.Model.EnumType.YlStructure.JiFenDuiHuanFangShi.积分现金; fangShi3.JiFen = jiFen3; fangShi3.JinE = jinE3; info.FangShis.Add(fangShi3); } if (info.FangShis.Count == 0) { RCWE(UtilsCommons.AjaxReturnJson("0", "请填写积分兑换方式")); } int bllRetCode = 0; if (string.IsNullOrEmpty(ShangPinId)) { bllRetCode = new EyouSoft.BLL.YlStructure.BDuiHuan().InsertJiFenShangPin(info); } else { bllRetCode = new EyouSoft.BLL.YlStructure.BDuiHuan().UpdateJiFenShangPin(info); } if (bllRetCode == 1) { RCWE(UtilsCommons.AjaxReturnJson("1", "操作成功")); } else { RCWE(UtilsCommons.AjaxReturnJson("0", "操作失败")); } }
/// <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.MWzJiFenShangPinInfo> GetJiFenShangPins(string companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.YlStructure.MWzJiFenShangPinChaXunInfo chaXun) { IList <EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo> items = new List <EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo>(); string tableName = "view_YL_JiFenShangPin"; string fields = "*"; string orderByString = "IssueTime DESC"; string sumString = string.Empty; StringBuilder sql = new StringBuilder(); sql.AppendFormat(" CompanyId='{0}' ", companyId); if (chaXun != null) { switch (chaXun.PaiXu) { case 0: orderByString = "JiFen DESC"; break; case 1: orderByString = "JiFen ASC"; break; case 2: orderByString = "LiPinKaJinE DESC"; break; case 3: orderByString = "LiPinKaJinE ASC"; break; case 4: orderByString = "XianJinJinE DESC"; break; case 5: orderByString = "XianJinJinE ASC"; break; case 6: orderByString = "IssueTime DESC"; break; case 7: orderByString = "IssueTime ASC"; break; default: orderByString = "IssueTime DESC"; break; } if (!string.IsNullOrEmpty(chaXun.MingCheng)) { sql.AppendFormat(" AND MingCheng LIKE '%{0}%' ", chaXun.MingCheng); } if (chaXun.Status.HasValue) { sql.AppendFormat(" AND Status={0} ", (int)chaXun.Status.Value); } } 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.MWzJiFenShangPinInfo(); info.CompanyId = rdr["CompanyId"].ToString(); info.FangShis = null; info.FuJians = null; info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")); info.MingCheng = rdr["MingCheng"].ToString(); info.OperatorId = rdr["OperatorId"].ToString(); info.ShangPinId = rdr["ShangPinId"].ToString(); info.ShuoMing = rdr["ShuoMing"].ToString(); info.XuZhi = rdr["XuZhi"].ToString(); info.Status = (EyouSoft.Model.EnumType.YlStructure.JiFenShangPinStatus)rdr.GetByte(rdr.GetOrdinal("Status")); info.ShuLiang = rdr.GetInt32(rdr.GetOrdinal("ShuLiang")); info.ChengJiaoShuLiang = rdr.GetInt32(rdr.GetOrdinal("ChengJiaoShuLiang")); info.ShangPinJinE = rdr.GetDecimal(rdr.GetOrdinal("ShangPinJinE")); items.Add(info); } } if (items != null && items.Count > 0) { foreach (var item in items) { item.FangShis = GetJiFenShangPinFangShis(item.ShangPinId); item.FuJians = GetJiFenShangPinFuJians(item.ShangPinId); } } return(items); }