private int GetOverDays(string serialNumber, int goodsID, out decimal goodsPrice, out int stockCount) { //计算距离过期时间 GoodsBaseInfo bInfo = new GoodsBaseInfo(); bInfo.SerialNumber = serialNumber; OQL q = OQL.From(bInfo) .Select(bInfo.CanUserMonth) .Where(bInfo.SerialNumber) .END; bInfo = EntityQuery <GoodsBaseInfo> .QueryObject(q); int canUseMonth = bInfo.CanUserMonth; GoodsStock stock = new GoodsStock(); stock.GoodsID = goodsID; EntityQuery <GoodsStock> .Fill(stock); goodsPrice = stock.GoodsPrice; stockCount = stock.Stocks; //距离过期时间 int overDays = canUseMonth * 30 - DateTime.Now.Subtract(stock.MakeOnDate).Days; return(overDays); }
public static T GetModelB <T>(string ID) where T : EntityBase, IStringID, new() { T model = new T(); model.ID = ID; return(EntityQuery <T> .Fill(model) ? model : null); }
/// <summary> /// 查 根据Id获取详情,如果没有则返回空对象 /// </summary> /// <param name="customerID"></param> /// <returns></returns> public BankAccountModel GetModelById(int accountId) { BankAccountModel model = new BankAccountModel() { ID = accountId }; if (EntityQuery<BankAccountModel>.Fill(model)) return model; else return null; }
/// <summary> /// 获取一条商品信息 /// </summary> /// <param name="sn">条码号</param> /// <returns></returns> public GoodsBaseInfo GetGoodsBaseInfo(string sn) { GoodsBaseInfo info = new GoodsBaseInfo() { SerialNumber = sn }; EntityQuery <GoodsBaseInfo> .Fill(info); return(info); }
/// <summary> /// 使用用户名密码参数来登录,但是根据实体类的主键来填充实体类并判断是否成功。 /// </summary> /// <param name="name"></param> /// <param name="pwd"></param> /// <returns></returns> public bool Login6(string name, string pwd) { User user = new User(); user.PrimaryKeys.Clear(); user.PrimaryKeys.Add("Name"); user.PrimaryKeys.Add("Pwd"); user.Name = name; user.Pwd = pwd; bool result= EntityQuery<User>.Fill(user);//静态方法,使用默认的连接对象 return result; }
/// <summary> /// 查 根据Id获取详情,如果没有则返回空对象 /// </summary> /// <param name="customerID"></param> /// <returns></returns> public AdminAccount GetModelById(int accountId) { AdminAccount model = new AdminAccount() { ID = accountId }; if (EntityQuery <AdminAccount> .Fill(model)) { return(model); } else { return(null); } }
/// <summary> /// 查 根据Id获取详情,如果没有则返回空对象 /// </summary> /// <param name="MerchanterID"></param> /// <returns></returns> public MerchantTypeModel GetModelById(int accountId) { MerchantTypeModel model = new MerchantTypeModel() { ID = accountId }; if (EntityQuery <MerchantTypeModel> .Fill(model)) { return(model); } else { return(null); } }
/// <summary> /// 查 根据Id获取详情,如果没有则返回空对象 /// </summary> /// <param name="customerID"></param> /// <returns></returns> public BankModel GetModelById(int accountId) { BankModel model = new BankModel() { ID = accountId }; if (EntityQuery <BankModel> .Fill(model)) { return(model); } else { return(null); } }
/// <summary> /// 查 根据Id获取详情,如果没有则返回空对象 /// </summary> /// <param name="TicketerID"></param> /// <returns></returns> public TicketInfo GetModelById(int accountId) { TicketInfo model = new TicketInfo() { ID = accountId }; if (EntityQuery <TicketInfo> .Fill(model)) { return(model); } else { return(null); } }
/// <summary> /// 查 根据Id获取详情,如果没有则返回空对象 /// </summary> /// <param name="customerID"></param> /// <returns></returns> public AdminMenu GetModelById(long Id) { AdminMenu model = new AdminMenu() { ID = Id }; if (EntityQuery <AdminMenu> .Fill(model)) { return(model); } else { return(null); } }
/// <summary> /// 查 根据Id获取详情,如果没有则返回空对象 /// </summary> /// <param name="CustomAccReceiptEntryerID"></param> /// <returns></returns> public CustomAccReceiptEntryModel GetModelById(int accountId) { CustomAccReceiptEntryModel model = new CustomAccReceiptEntryModel() { ID = accountId }; if (EntityQuery <CustomAccReceiptEntryModel> .Fill(model)) { return(model); } else { return(null); } }
/// <summary> /// 查 根据Id获取详情,如果没有则返回空对象 /// </summary> /// <param name="TicketerID"></param> /// <returns></returns> public CustomChargeCardsModel GetModelById(int accountId) { CustomChargeCardsModel model = new CustomChargeCardsModel() { ID = accountId }; if (EntityQuery <CustomChargeCardsModel> .Fill(model)) { return(model); } else { return(null); } }
/// <summary> /// 查 根据Id获取详情,如果没有则返回空对象 /// </summary> /// <param name="TicketerID"></param> /// <returns></returns> public ContractModel GetModelById(long id) { ContractModel model = new ContractModel() { ID = id }; if (EntityQuery <ContractModel> .Fill(model)) { return(model); } else { return(null); } }
/// <summary> /// 查 根据Id获取详情,如果没有则返回空对象 /// </summary> /// <param name="MerchanterID"></param> /// <returns></returns> public MerchantModel GetModelById(int Id) { MerchantModel model = new MerchantModel() { TenantId = TenantId, ID = Id }; if (EntityQuery <MerchantModel> .Fill(model)) { return(model); } else { return(null); } }
/// <summary> /// 查 根据Id获取详情,如果没有则返回空对象 /// </summary> /// <param name="TicketerID"></param> /// <returns></returns> public CustomFinancialModel GetModelById(int customFinancialId) { CustomFinancialModel model = new CustomFinancialModel() { ID = customFinancialId }; if (EntityQuery <CustomFinancialModel> .Fill(model)) { return(model); } else { return(null); } }
/// <summary> /// 查 根据Id获取详情,如果没有则返回空对象 /// </summary> /// <param name="customerID"></param> /// <returns></returns> public CinemaChainModel GetModelById(int accountId) { CinemaChainModel model = new CinemaChainModel() { ID = accountId }; if (EntityQuery <CinemaChainModel> .Fill(model)) { return(model); } else { return(null); } }
/// <summary> /// 获取一个顾客信息,如果没有则返回空对象 /// </summary> /// <param name="customerID"></param> /// <returns></returns> public CustomerContactInfo GetCustomerContactInfo(string customerID) { CustomerContactInfo info = new CustomerContactInfo() { CustomerID = customerID }; if (EntityQuery <CustomerContactInfo> .Fill(info)) { return(info); } else { return(null); } }
/// <summary> /// 查 根据Id获取详情,如果没有则返回空对象 /// </summary> /// <param name="customerID"></param> /// <returns></returns> public TenantModel GetModelById(int accountId) { TenantModel model = new TenantModel() { ID = accountId }; if (EntityQuery <TenantModel> .Fill(model)) { return(model); } else { return(null); } }
/// <summary> /// 查 根据Id获取详情,如果没有则返回空对象 /// </summary> /// <param name="customerID"></param> /// <returns></returns> public AdminRole GetModelById(int Id) { AdminRole model = new AdminRole() { ID = Id }; if (EntityQuery <AdminRole> .Fill(model)) { return(model); } else { return(null); } }
/// <summary> /// 查 根据Id获取详情,如果没有则返回空对象 /// </summary> /// <param name="TicketerID"></param> /// <returns></returns> public ContractViewModel GetViewModelById(long contractId) { ContractModel contract = GetModelById(contractId); if (contract != null) { CustomModel customModel = new CustomModel() { ID = contract.CustomId }; if (EntityQuery <CustomModel> .Fill(customModel)) { return(new ContractViewModel() { ID = contract.ID, CustomId = contract.CustomId, CustomName = customModel.CustomName, ContractNo = contract.ContractNo, ContractAmount = contract.ContractAmount, Deductions = contract.Deductions, Balance = contract.Balance, Remark = contract.Remark, Sort = contract.Sort, Status = contract.Status, CreateId = contract.CreateId, CreateUser = contract.CreateUser, CreateIP = contract.CreateIP, CreateTime = contract.CreateTime, }); } else { return(null); } } else { return(null); } }