/* * 机具关联商户号表 */ 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) // { // } } }