/*
* 优惠券发放记录
*/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Data;
using MySystem.Models.Main;
using Library;
using LitJson;
namespace MySystem.Service.Main
{
public class CouponAssignRecordsService
{
string _conn = "";
public CouponAssignRecordsService()
{
_conn = ConfigurationManager.AppSettings["SqlConnStr"].ToString();
}
///
/// 查询列表
///
/// 关联表
/// 查询条件(sql语句)
/// 总数(输出)
/// 页码
/// 每页条数
///
public List> List(List relationData, string condition, out int count, int page = 1, int limit = 30, string orderBy = "Sort desc,Id desc")
{
List fields = new List(); //要显示的列
fields.Add("Id");
fields.Add("CreateDate"); //添加时间
fields.Add("Status"); //状态
fields.Add("UserMinLevel"); //创客最低等级
fields.Add("UserMaxLevel"); //创客最高等级
fields.Add("TotalOrderMoneyMin"); //最小消费总额
fields.Add("TotalOrderMoneyMax"); //最大消费总额
fields.Add("TotalUseIntegralMin"); //最小消耗积分总额
fields.Add("TotalUseIntegralMax"); //最大消耗积分总额
fields.Add("CurMoneyMin"); //当前最低余额
fields.Add("CurMoneyMax"); //当前最高余额
fields.Add("UserGroupId"); //创客分组
fields.Add("Areas"); //创客所在地区
fields.Add("Mobile"); //手机号
Dictionary obj = new DbService(AppConfig.Base.dbTables, _conn).IndexData("CouponAssignRecords", relationData, orderBy, page, limit, condition, fields);
List> diclist = obj["data"] as List>;
count = int.Parse(obj["count"].ToString());
return diclist;
}
public List> List(List relationData, string condition, int page = 1, int limit = 30, string orderBy = "Sort desc,Id desc")
{
List fields = new List(); //要显示的列
fields.Add("Id");
fields.Add("CreateDate"); //添加时间
fields.Add("Status"); //状态
fields.Add("UserMinLevel"); //创客最低等级
fields.Add("UserMaxLevel"); //创客最高等级
fields.Add("TotalOrderMoneyMin"); //最小消费总额
fields.Add("TotalOrderMoneyMax"); //最大消费总额
fields.Add("TotalUseIntegralMin"); //最小消耗积分总额
fields.Add("TotalUseIntegralMax"); //最大消耗积分总额
fields.Add("CurMoneyMin"); //当前最低余额
fields.Add("CurMoneyMax"); //当前最高余额
fields.Add("UserGroupId"); //创客分组
fields.Add("Areas"); //创客所在地区
fields.Add("Mobile"); //手机号
Dictionary obj = new DbService(AppConfig.Base.dbTables, _conn).IndexData("CouponAssignRecords", relationData, orderBy, page, limit, condition, fields);
List> diclist = obj["data"] as List>;
return diclist;
}
///
/// 查询一条记录
///
/// 主键Id
///
public CouponAssignRecords Query(int Id)
{
WebCMSEntities db = new WebCMSEntities();
CouponAssignRecords editData = db.CouponAssignRecords.FirstOrDefault(m => m.Id == Id) ?? new CouponAssignRecords();
db.Dispose();
return editData;
}
///
/// 查询记录数
///
/// 主键Id
///
public int Count(string condition = "")
{
int result = 0;
DataTable dt = CustomerSqlConn.dtable("select count(Id) from CouponAssignRecords where 1=1" + condition, _conn);
if(dt.Rows.Count > 0)
{
result = int.Parse(function.CheckInt(dt.Rows[0][0].ToString()));
}
return result;
}
///
/// 查询是否存在
///
/// 主键Id
///
public bool Exist(int Id)
{
WebCMSEntities db = new WebCMSEntities();
bool check = db.CouponAssignRecords.Any(m => m.Id == Id);
db.Dispose();
return check;
}
///
/// 添加数据
///
/// 要设置的字段
///
public AppResultJson Add(Dictionary fields, bool check = true)
{
if(check)
{
if (string.IsNullOrEmpty(fields["TotalOrderMoneyMin"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写最小消费总额" };
}
if (!function.IsNum(fields["TotalOrderMoneyMin"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写正确的最小消费总额" };
}
if (string.IsNullOrEmpty(fields["TotalOrderMoneyMax"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写最大消费总额" };
}
if (!function.IsNum(fields["TotalOrderMoneyMax"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写正确的最大消费总额" };
}
if (string.IsNullOrEmpty(fields["TotalUseIntegralMin"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写最小消耗积分总额" };
}
if (!function.IsNum(fields["TotalUseIntegralMin"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写正确的最小消耗积分总额" };
}
if (string.IsNullOrEmpty(fields["TotalUseIntegralMax"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写最大消耗积分总额" };
}
if (!function.IsNum(fields["TotalUseIntegralMax"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写正确的最大消耗积分总额" };
}
if (string.IsNullOrEmpty(fields["CurMoneyMin"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写当前最低余额" };
}
if (!function.IsNum(fields["CurMoneyMin"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写正确的当前最低余额" };
}
if (string.IsNullOrEmpty(fields["CurMoneyMax"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写当前最高余额" };
}
if (!function.IsNum(fields["CurMoneyMax"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写正确的当前最高余额" };
}
}
int Id = new DbService(AppConfig.Base.dbTables, _conn).Add("CouponAssignRecords", fields, 0);
return new AppResultJson(){ Status = "1", Data = Id };
}
///
/// 修改数据
///
/// 要设置的字段
/// 主键Id
public AppResultJson Edit(Dictionary fields, int Id, bool check = true)
{
if(check)
{
if (string.IsNullOrEmpty(fields["TotalOrderMoneyMin"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写最小消费总额" };
}
if (!function.IsNum(fields["TotalOrderMoneyMin"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写正确的最小消费总额" };
}
if (string.IsNullOrEmpty(fields["TotalOrderMoneyMax"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写最大消费总额" };
}
if (!function.IsNum(fields["TotalOrderMoneyMax"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写正确的最大消费总额" };
}
if (string.IsNullOrEmpty(fields["TotalUseIntegralMin"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写最小消耗积分总额" };
}
if (!function.IsNum(fields["TotalUseIntegralMin"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写正确的最小消耗积分总额" };
}
if (string.IsNullOrEmpty(fields["TotalUseIntegralMax"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写最大消耗积分总额" };
}
if (!function.IsNum(fields["TotalUseIntegralMax"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写正确的最大消耗积分总额" };
}
if (string.IsNullOrEmpty(fields["CurMoneyMin"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写当前最低余额" };
}
if (!function.IsNum(fields["CurMoneyMin"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写正确的当前最低余额" };
}
if (string.IsNullOrEmpty(fields["CurMoneyMax"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写当前最高余额" };
}
if (!function.IsNum(fields["CurMoneyMax"].ToString()))
{
return new AppResultJson() { Status = "-1", Info = "请填写正确的当前最高余额" };
}
}
new DbService(AppConfig.Base.dbTables, _conn).Edit("CouponAssignRecords", fields, Id);
return new AppResultJson(){ Status = "1", Data = Id };
}
///
/// 逻辑删除
///
/// 主键Id
public void Remove(int Id)
{
Dictionary fields = new Dictionary();
fields.Add("Status", -1);
new DbService(AppConfig.Base.dbTables, _conn).Edit("CouponAssignRecords", fields, Id);
}
///
/// 删除数据
///
/// 主键Id
public void Delete(int Id)
{
new DbService(AppConfig.Base.dbTables, _conn).Delete("CouponAssignRecords", Id);
}
///
/// 排序
///
/// 主键Id
/// 排序序号
public void Sort(int Id, int Sort)
{
new DbService(AppConfig.Base.dbTables, _conn).Sort("CouponAssignRecords", Sort, Id);
}
///
/// 导入数据
///
/// json数据
public void Import(string ExcelData)
{
WebCMSEntities db = new WebCMSEntities();
JsonData list = JsonMapper.ToObject(ExcelData);
for (int i = 1; i < list.Count;i++ )
{
JsonData dr = list[i];
db.CouponAssignRecords.Add(new CouponAssignRecords()
{
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now,
});
db.SaveChanges();
}
db.Dispose();
}
///
/// 导出excel表格
///
/// 查询条件(单个字段)
/// 查询条件(sql语句)
///
// public void ExportExcel(List relationData, string condition)
// {
// }
}
}