public OpResult SetState(string ids, short state) { var idlist = ids.Split(',').Select(o => int.Parse(o)); var list = CompanyAuthorRepository.GetQuery(o => idlist.Contains(o.Id)).ToList(); list.ForEach(o => o.Status = state); CompanyAuthorRepository.SaveChanges(); return(OpResult.Success()); }
public CompanyAuthorize GetOneTitleByCID(int cid) { var company = CompanyAuthorRepository.GetQuery(o => o.CID == cid).OrderByDescending(o => o.CreateDT).FirstOrDefault(); if (company != null && !company.OpenScopeId.IsNullOrEmpty()) { var scopeids = company.OpenScopeId.Split(','); company.OpenScopeId = string.Join(",", BusinessRepository.GetQuery(o => scopeids.Contains(o.ById)).Select(o => o.Title)); } return(company); }
public OpResult Add(CompanyAuthorize obj) { if (CompanyAuthorRepository.GetQuery(o => o.CID == obj.CID && (o.Status == 0 || o.Status == 1)).Any()) { return(OpResult.Fail("商户已续签!")); } obj.AppProper = obj.AppProper ?? "N"; obj.StoreProper = obj.StoreProper ?? "N"; obj.PosMinorDisp = obj.PosMinorDisp ?? "N"; obj.MemberShared = obj.MemberShared ?? "Y"; obj.CreateDT = DateTime.Now; obj.CreateUID = CurrentUser.UID; obj.ExpirationDT = DateTime.Parse(obj.EffectiveDT).AddMonths(obj.ValidityNum.GetValueOrDefault()).ToString("yyyy-MM-dd"); CompanyAuthorRepository.Add(obj); return(OpResult.Success()); }
public bool RegisterAgain(CompanyAuthorize company) { if (company.CID.HasValue) { var obj = CompanyAuthorRepository.GetQuery(o => o.CID == company.CID.Value).OrderByDescending(o => o.CreateDT).FirstOrDefault(); if (obj == null) { return(false); } obj.Way = company.Way; obj.Title = company.Title; obj.UserNum = company.UserNum; obj.StoreNum = company.StoreNum; obj.StoreProper = company.StoreProper; obj.PosMinorDisp = company.PosMinorDisp; obj.AppProper = company.AppProper; obj.OpenVersionId = company.OpenVersionId; obj.MachineSN = company.MachineSN; obj.SerialNo = company.SerialNo; CompanyAuthorRepository.SaveChanges(); return(true); } return(false); }
public OpResult SaveOrUpdate(CompanyAuthorize obj) { if (!TraderRepository.GetQuery(o => o.CID == obj.CID).Any()) { return(OpResult.Fail("商户不存在!")); } //if(!obj.RealmName.IsNullOrEmpty()) obj.RealmName=obj.RealmName.Trim(); //if(!obj.RealmName.IsNullOrEmpty() && RealmRepository.GetQuery(o => o.Name == obj.RealmName && o.Url!=obj.RealmUrl).Any()) // return OpResult.Fail("子域名已存在!"); obj.AppProper = obj.AppProper ?? "N"; obj.StoreProper = obj.StoreProper ?? "N"; obj.PosMinorDisp = obj.PosMinorDisp ?? "N"; obj.MemberShared = obj.MemberShared ?? "Y"; if (obj.Id == 0) { if (CompanyAuthorRepository.GetQuery(o => o.CID == obj.CID).Any()) { return(OpResult.Fail("该商户已存在,如果已过期,请选择续约方式")); } obj.CreateDT = DateTime.Now; obj.CreateUID = CurrentUser.UID; obj.ExpirationDT = DateTime.Parse(obj.EffectiveDT).AddMonths(obj.ValidityNum.GetValueOrDefault()).ToString("yyyy-MM-dd"); if (obj.RealmName.IsNullOrEmpty()) { CompanyAuthorRepository.Add(obj); } else { //CompanyAuthorRepository.Add(obj, false); //RealmRepository.Add(new Realm() { CID = obj.CID.Value, Name = obj.RealmName, State = Convert.ToInt16(obj.RealmState), Url = obj.RealmName + obj.RealmSuffixUrl }); } } else { var res = CompanyAuthorRepository.Get(obj.Id); var pwd = res.SupperPassword; obj.ToCopyProperty(res, new List <string>() { "CreateDT", "CreateUID", "CID", "MachineSN", "SerialNo" }); res.ExpirationDT = DateTime.Parse(obj.EffectiveDT).AddMonths(obj.ValidityNum.GetValueOrDefault()).ToString("yyyy-MM-dd"); if (obj.SupperPassword.IsNullOrEmpty()) { res.SupperPassword = pwd; } //if(!res.RealmName.IsNullOrEmpty()) //{ // var realm = RealmRepository.Find(o => o.Url == res.RealmUrl && o.CID==res.CID.Value); // if (realm == null) // { // realm = new Realm(); // realm.CID = res.CID.Value; // RealmRepository.Add(realm,false); // } // realm.Name = res.RealmName; // realm.Url = res.RealmName + res.RealmSuffixUrl; // realm.State = Convert.ToInt16(res.RealmState); //} //else if (res.RealmName.IsNullOrEmpty()) //{ // var reals = RealmRepository.GetQuery(o => o.Url == res.RealmUrl && o.CID == res.CID).ToList(); // RealmRepository.RemoveRange(reals, false); //} CompanyAuthorRepository.SaveChanges(); } return(OpResult.Success()); }
public Pharos.Utility.OpResult Deletes(int[] ids) { var list = CompanyAuthorRepository.GetQuery(o => ids.Contains(o.Id)).ToList(); return(OpResult.Result(CompanyAuthorRepository.RemoveRange(list))); }
public IEnumerable <dynamic> GetPageList(System.Collections.Specialized.NameValueCollection nvl, out int recordCount) { var text = nvl["searchText"]; var searchField = nvl["searchField"]; var state = nvl["state"]; var Assigner = nvl["Assigner"]; var Way = nvl["Way"]; var OpenVersionId = nvl["OpenVersionId"]; var ValidityNum = nvl["ValidityNum"]; var queryUser = UserRepository.GetQuery(); var queryDict = DataDictRepository.GetQuery(); var queryProductVer = ProductVerRepository.GetQuery(); var bussinessList = BusinessRepository.GetQuery().ToList(); var where = DynamicallyLinqHelper.Empty <CompanyAuthorize>(); if (!text.IsNullOrEmpty()) { int cid = 0; text = text.Trim(); int.TryParse(text, out cid); if (searchField == "Cid") { where = where.And(o => o.CID == cid); } else if (searchField == "Title") { where = where.And(o => o.Title.Contains(text)); } else if (searchField == "ContractNo") { where = where.And(o => o.ContractNo != null && o.ContractNo.StartsWith(text)); } } short way = 0, st = 0, verid = 0, validnum = 0; short.TryParse(Way, out way); short.TryParse(state, out st); short.TryParse(OpenVersionId, out verid); short.TryParse(ValidityNum, out validnum); where = where.And(o => o.AssignerUID == Assigner, Assigner.IsNullOrEmpty()).And(o => o.Way == way, Way.IsNullOrEmpty()).And(o => o.Status == st, state.IsNullOrEmpty()) .And(o => o.OpenVersionId == verid, OpenVersionId.IsNullOrEmpty()).And(o => o.ValidityNum == validnum, ValidityNum.IsNullOrEmpty()); var query = CompanyAuthorRepository.GetQuery(where); var q = from x in query join y in queryProductVer on x.OpenVersionId equals y.ProductId select new { x.Id, x.CreateDT, x, BusinessModeTitle = queryDict.Where(o => o.DicSN == x.BusinessMode).Select(o => o.Title).FirstOrDefault(), Assigner = queryUser.Where(o => o.UserId == x.AssignerUID).Select(o => o.FullName).FirstOrDefault(), y.ProductId, y.SysName }; recordCount = q.Count(); var list = q.ToPageList(); return(list.Select(o => new{ o.x.Id, o.x.CID, o.x.Source, o.x.Way, o.x.AppProper, o.x.StoreProper, o.x.Title, o.x.ContractNo, o.x.EffectiveDT, o.x.ExpirationDT, o.x.ValidityNum, o.x.UserNum, o.x.StoreNum, o.x.PosMinorDisp, o.x.MemberShared, o.x.OpenVersionId, o.x.Status, o.x.SupperAccount, o.x.CreateDT, o.x.OpenScopeId, o.BusinessModeTitle, o.Assigner, OpenVersionTitle = "(" + o.ProductId + ")" + o.SysName, StatusTitle = Enum.GetName(typeof(CompanyAuthorizeState), o.x.Status), OpenScopeTitle = o.x.OpenScopeId.IsNullOrEmpty() ? "" : string.Join(",", bussinessList.Where(i => o.x.OpenScopeId.Split(',').Contains(i.ById)).Select(i => i.Title)) })); }