123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229 |
- 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();
-
-
-
-
-
-
-
-
-
- public static List<Dictionary<string, object>> List(List<RelationData> relationData, string condition, out int count, int page = 1, int limit = 30, string orderBy = "Sort desc,Id desc")
- {
- List<string> fields = new List<string>();
- 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");
- fields.Add("ParentNav");
-
-
-
-
-
-
-
-
-
-
-
-
- Dictionary<string, object> obj = new DbService(AppConfig.Base.mainTables, _conn).IndexData("MachineForSnNo", relationData, orderBy, page, limit, condition, fields);
- List<Dictionary<string, object>> diclist = obj["data"] as List<Dictionary<string, object>>;
- count = int.Parse(obj["count"].ToString());
- return diclist;
- }
- public static List<Dictionary<string, object>> List(List<RelationData> relationData, string condition, int page = 1, int limit = 30, string orderBy = "Sort desc,Id desc")
- {
- List<string> fields = new List<string>();
- 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<string, object> obj = new DbService(AppConfig.Base.mainTables, _conn).IndexData("MachineForSnNo", relationData, orderBy, page, limit, condition, fields);
- List<Dictionary<string, object>> diclist = obj["data"] as List<Dictionary<string, object>>;
- 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 = "*")
- {
-
-
-
-
-
-
-
-
-
-
- var machineForSnNo = new DbService(AppConfig.Base.mainTables, _conn).Query(fields, "MachineForSnNo", condition);
- if (machineForSnNo.Count > 0)
- {
- return Newtonsoft.Json.JsonConvert.DeserializeObject<MachineForSnNo>(Newtonsoft.Json.JsonConvert.SerializeObject(machineForSnNo));
- }
- return new MachineForSnNo();
- }
-
-
-
-
-
- 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<string, object> fields, bool check = true)
- {
- int Id = new DbService(AppConfig.Base.mainTables, _conn).Add("MachineForSnNo", fields, 0);
- return new AppResultJson() { Status = "1", Data = Id };
- }
-
-
-
-
-
- public static AppResultJson Edit(Dictionary<string, object> fields, int Id, bool check = true)
- {
- new DbService(AppConfig.Base.mainTables, _conn).Edit("MachineForSnNo", fields, Id);
- return new AppResultJson() { Status = "1", Data = Id };
- }
-
-
-
-
- public static void Remove(int SnId)
- {
- Dictionary<string, object> fields = new Dictionary<string, object>();
- fields.Add("Status", -1);
- new DbService(AppConfig.Base.mainTables, _conn).Edit("MachineForSnNo", fields, SnId);
- }
-
-
-
-
- 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);
-
- }
-
-
-
-
-
- public static void Sort(int Id, int Sort)
- {
- new DbService(AppConfig.Base.mainTables, _conn).Sort("MachineForSnNo", Sort, Id);
- }
-
-
-
-
-
-
-
-
-
- }
- }
|