public ActionResult GetExchangGiftsExchangInfo() { StringBuilder sb = new StringBuilder("select * from ExchangLogs where S_ID = " + (Session["UserInfo"] as Users).S_ID); if (!string.IsNullOrEmpty(Request.Form["MC_CardID"])) { string id1 = Request.Form["MC_CardID"].Trim(); if (id1.ToString().Trim().Length == 11)//手机号 { id1 = (from i1 in db.MemCards where i1.MC_Mobile == id1.Trim() select i1).First().MC_CardID.ToString().Trim(); } sb.AppendFormat(" AND MC_CardID like '%{0}%'", id1); } if (!string.IsNullOrEmpty(Request.Form["BTime"]) && !string.IsNullOrEmpty(Request.Form["ETime"])) { sb.AppendFormat(" AND EL_CreateTime >= '{0}' AND CO_CreateTime <= '{1}'", Request.Form["BTime"].Trim(), Request.Form["ETime"].Trim()); } else if (!string.IsNullOrEmpty(Request.Form["BTime"])) { sb.AppendFormat(" AND EL_CreateTime >= '{0}'", Request.Form["BTime"].Trim()); } else if (!string.IsNullOrEmpty(Request.Form["ETime"])) { sb.AppendFormat(" AND EL_CreateTime <= '{0}'", Request.Form["ETime"].Trim()); } DataTable dt = SqlHelper.GetDataTable(sb.ToString()); List <ExchangLogs> ml = new List <ExchangLogs>(); foreach (DataRow dr in dt.Rows) { ExchangLogs e = dr.ToModel <ExchangLogs>(); ml.Add(e); } int pageSize = int.Parse(Request.Form["rows"] == "NaN" ? "1" : Request.Form["rows"]); int pageIndex = int.Parse(Request.Form["page"] == "NaN" ? "1" : Request.Form["page"]); return(Json(new { total = ml.Count, rows = ml.Skip(--pageIndex * pageSize).Take(pageSize).ToList() }, JsonRequestBehavior.AllowGet)); }
public bool PointExchange(ExchangLogs el, MemCards m, Model.ExchangGifts eg) { string sql = "P_PointExchange"; SqlParameter[] para = { new SqlParameter("@S_ID", el.S_ID), new SqlParameter("@U_ID", el.U_ID), new SqlParameter("@MC_ID", el.MC_ID), new SqlParameter("@MC_CardID", el.MC_CardID), new SqlParameter("@MC_Name", el.MC_Name), new SqlParameter("@EG_ID", el.EG_ID), new SqlParameter("@EG_GiftCode", el.EG_GiftCode), new SqlParameter("@EG_GiftName", el.EG_GiftName), new SqlParameter("@EL_Number", el.EL_Number), new SqlParameter("@EL_Point", el.EL_Point), new SqlParameter("@EL_CreateTime", el.EL_CreateTime), new SqlParameter("@MC_Point", m.MC_Point), new SqlParameter("@EG_Number", eg.EG_Number), new SqlParameter("@EG_ExchangNum", eg.EG_ExchangNum) }; return(DBHelper.ExecuteNonQuery(sql, true, para)); }
public bool PointExchange(ExchangLogs el, MemCards m, Model.ExchangGifts eg) { return(_IExchangLogsDAL.PointExchange(el, m, eg)); }