/*
* 机具关联商户号表
*/
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 MachineForSnNoService
{
static string _conn = ConfigurationManager.AppSettings["SqlConnStr"].ToString();
///
/// 查询列表
///
/// 关联表
/// 查询条件(sql语句)
/// 总数(输出)
/// 页码
/// 每页条数
///
public static 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("MakerCode"); //创客编号
fields.Add("RealName"); //真实姓名
fields.Add("Mobile"); //手机号
fields.Add("CertId"); //身份证号
fields.Add("UserLevel"); //创客等级
fields.Add("AgentAreas"); //代理区域
fields.Add("MerchantType"); //商户创客类型
fields.Add("MerchantDate"); //成为商户型创客时间
fields.Add("AuthFlag"); //实名标识
fields.Add("AuthDate"); //实名时间
fields.Add("RiskFlag"); //风控标识
fields.Add("ParentUserId"); //直属创客Id
fields.Add("ParentNav"); //父级集合
// fields.Add("SettleAmount"); //最低结算金额
// fields.Add("CashFreezeAmt"); //提现冻结金额
// fields.Add("CertValidStartDate"); //身份证有效期开始时间
// fields.Add("CertValidEndDate"); //身份证有效期结束时间
// fields.Add("SettleBankCardName"); //结算银行卡户名
// fields.Add("AgentLevel"); //代理等级
// fields.Add("CashStatus"); //代付账户状态
// fields.Add("LeaderLevel"); //盟主等级
// fields.Add("BusinessFlag"); //企业标记
// fields.Add("DeviceType"); //设备类型
// fields.Add("HelpProfitAgree"); //助利宝协议标记
// fields.Add("HelpProfitAgreeDate"); //助利宝协议标记时间
Dictionary obj = new DbService(AppConfig.Base.mainTables, _conn).IndexData("MachineForSnNo", relationData, orderBy, page, limit, condition, fields);
List> diclist = obj["data"] as List>;
count = int.Parse(obj["count"].ToString());
return diclist;
}
public static 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("RealName"); //真实姓名
fields.Add("CertId"); //身份证号
fields.Add("UserLevel"); //创客等级
fields.Add("MerchantType"); //商户创客类型
fields.Add("MerchantDate"); //成为商户型创客时间
fields.Add("AuthFlag"); //实名标识
fields.Add("RiskFlag"); //风控标识
fields.Add("MakerCode"); //创客编号
fields.Add("SettleAmount"); //最低结算金额
fields.Add("CashFreezeAmt"); //提现冻结金额
fields.Add("CertValidStartDate"); //身份证有效期开始时间
fields.Add("CertValidEndDate"); //身份证有效期结束时间
fields.Add("SettleBankCardName"); //结算银行卡户名
fields.Add("AgentLevel"); //代理等级
fields.Add("AgentAreas"); //代理区域
fields.Add("CashStatus"); //代付账户状态
fields.Add("LeaderLevel"); //盟主等级
fields.Add("BusinessFlag"); //企业标记
fields.Add("DeviceType"); //设备类型
fields.Add("HelpProfitAgree"); //助利宝协议标记
fields.Add("HelpProfitAgreeDate"); //助利宝协议标记时间
Dictionary obj = new DbService(AppConfig.Base.mainTables, _conn).IndexData("MachineForSnNo", relationData, orderBy, page, limit, condition, fields);
List> diclist = obj["data"] as List>;
return diclist;
}
///
/// 查询一条记录
///
/// 商户号
///
public static MachineForSnNo Query(string SnNo)
{
WebCMSEntities db = new WebCMSEntities();
MachineForSnNo editData = db.MachineForSnNo.FirstOrDefault(m => m.SnNo == SnNo) ?? new MachineForSnNo();
db.Dispose();
return editData;
}
public static MachineForSnNo Query(string condition, string fields = "*")
{
// DataTable dt = new DbService(AppConfig.Base.mainTables, _conn).QueryDetail(fields, "MachineForSnNo", condition);
// if(dt.Rows.Count > 0)
// {
// Dictionary row = new Dictionary();
// foreach(DataColumn dc in dt.Columns)
// {
// row.Add(dc.ColumnName, dt.Rows[0][dc.ColumnName].ToString());
// }
// return Newtonsoft.Json.JsonConvert.DeserializeObject(Newtonsoft.Json.JsonConvert.SerializeObject(row));
// }
var machineForSnNo = new DbService(AppConfig.Base.mainTables, _conn).Query(fields, "MachineForSnNo", condition);
if (machineForSnNo.Count > 0)
{
return Newtonsoft.Json.JsonConvert.DeserializeObject(Newtonsoft.Json.JsonConvert.SerializeObject(machineForSnNo));
}
return new MachineForSnNo();
}
///
/// 查询记录数
///
/// 主键Id
///
public static int Count(string condition = "")
{
int result = 0;
DataTable dt = CustomerSqlConn.dtable("select count(Id) from MachineForSnNo where 1=1" + condition, _conn);
if (dt.Rows.Count > 0)
{
result = int.Parse(function.CheckInt(dt.Rows[0][0].ToString()));
}
return result;
}
///
/// 查询是否存在
///
/// 商户编号
///
public static bool Exist(string SnNo)
{
WebCMSEntities db = new WebCMSEntities();
bool check = db.MachineForSnNo.Any(m => m.SnNo == SnNo);
db.Dispose();
return check;
}
///
/// 添加数据
///
/// 要设置的字段
///
public static AppResultJson Add(Dictionary fields, bool check = true)
{
int Id = new DbService(AppConfig.Base.mainTables, _conn).Add("MachineForSnNo", fields, 0);
return new AppResultJson() { Status = "1", Data = Id };
}
///
/// 修改数据
///
/// 要设置的字段
/// 主键Id
public static AppResultJson Edit(Dictionary fields, int Id, bool check = true)
{
new DbService(AppConfig.Base.mainTables, _conn).Edit("MachineForSnNo", fields, Id);
return new AppResultJson() { Status = "1", Data = Id };
}
///
/// 逻辑删除
///
/// 机具Id
public static void Remove(int SnId)
{
Dictionary fields = new Dictionary();
fields.Add("Status", -1);
new DbService(AppConfig.Base.mainTables, _conn).Edit("MachineForSnNo", fields, SnId);
}
///
/// 删除数据
///
/// 机具Id
public static void Delete(int SnId)
{
new DbService(AppConfig.Base.mainTables, _conn).Delete("MachineForSnNo", SnId);
}
public static void DeleteByLinq(string condition, string fields = "*")
{
DataTable dt = new DbService(AppConfig.Base.mainTables, _conn).QueryDetail(fields, "MachineForSnNo", condition);
}
///
/// 排序
///
/// 主键Id
/// 排序序号
public static void Sort(int Id, int Sort)
{
new DbService(AppConfig.Base.mainTables, _conn).Sort("MachineForSnNo", Sort, Id);
}
///
/// 导出excel表格
///
/// 查询条件(单个字段)
/// 查询条件(sql语句)
///
// public static void ExportExcel(List relationData, string condition)
// {
// }
}
}