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