public OperationResult Delete(string ID) { var model = SALES_EORDERSList.FirstOrDefault(t => t.ID == ID); SALES_EORDERSRepository.Delete(model); return(new OperationResult(OperationResultType.Success, "successfully deleted")); }
public OperationResult Insert(SALES_EORDERSModel model) { var entity = new SALES_EORDERS { ID = model.ID, RowID = model.RowID, OrderType = model.OrderType, CustomerID = model.CustomerID, ShipID = model.ShipID, Freight = model.Freight, ShipName = model.ShipName, ShipAddress = model.ShipAddress, ShipCity = model.ShipCity, ShipZip = model.ShipZip, ShipCountry = model.ShipCountry, ShipState = model.ShipState, ShipPhone = model.ShipPhone, AuthCode = model.AuthCode, BillTitle = model.BillTitle, BillName = model.BillName, BillAddress = model.BillAddress, BillCity = model.BillCity, BillState = model.BillState, BillZip = model.BillZip, BillCountry = model.BillCountry, BillPhone = model.BillPhone, CommText = model.CommText, CreditCard = model.CreditCard, CcName = model.CcName, CcExpMonth = model.CcExpMonth, CcExpYear = model.CcExpYear, CcNumber = model.CcNumber, CcType = model.CcType, VerifyWith = model.VerifyWith, PurchaseNo = model.PurchaseNo, OrderDate = model.OrderDate, RequiredDate = model.RequiredDate, ShippedDate = model.ShippedDate, CreateDate = model.CreateDate, ModiDate = model.ModiDate, Creator = model.Creator, Modifier = model.Modifier, IsPrint = model.IsPrint, ProcStatus = model.ProcStatus, Status = model.Status, Item01 = model.Item01, Item02 = model.Item02, Item03 = model.Item03, Item04 = model.Item04, Item05 = model.Item05, ContactID = model.ContactID, Miscellaneous = model.Miscellaneous, }; SALES_EORDERSRepository.Insert(entity); return(new OperationResult(OperationResultType.Success, "Added successfully")); }
public OperationResult Update(SALES_EORDERSModel model) { var entity = SALES_EORDERSList.First(t => t.ID == model.ID); entity.ID = model.ID; entity.RowID = model.RowID; entity.OrderType = model.OrderType; entity.CustomerID = model.CustomerID; entity.ShipID = model.ShipID; entity.Freight = model.Freight; entity.ShipName = model.ShipName; entity.ShipAddress = model.ShipAddress; entity.ShipCity = model.ShipCity; entity.ShipZip = model.ShipZip; entity.ShipCountry = model.ShipCountry; entity.ShipState = model.ShipState; entity.ShipPhone = model.ShipPhone; entity.AuthCode = model.AuthCode; entity.BillTitle = model.BillTitle; entity.BillName = model.BillName; entity.BillAddress = model.BillAddress; entity.BillCity = model.BillCity; entity.BillState = model.BillState; entity.BillZip = model.BillZip; entity.BillCountry = model.BillCountry; entity.BillPhone = model.BillPhone; entity.CommText = model.CommText; entity.CreditCard = model.CreditCard; entity.CcName = model.CcName; entity.CcExpMonth = model.CcExpMonth; entity.CcExpYear = model.CcExpYear; entity.CcNumber = model.CcNumber; entity.CcType = model.CcType; entity.VerifyWith = model.VerifyWith; entity.PurchaseNo = model.PurchaseNo; entity.OrderDate = model.OrderDate; entity.RequiredDate = model.RequiredDate; entity.ShippedDate = model.ShippedDate; entity.CreateDate = model.CreateDate; entity.ModiDate = model.ModiDate; entity.Creator = model.Creator; entity.Modifier = model.Modifier; entity.IsPrint = model.IsPrint; entity.ProcStatus = model.ProcStatus; entity.Status = model.Status; entity.Item01 = model.Item01; entity.Item02 = model.Item02; entity.Item03 = model.Item03; entity.Item04 = model.Item04; entity.Item05 = model.Item05; entity.ContactID = model.ContactID; entity.Miscellaneous = model.Miscellaneous; SALES_EORDERSRepository.Update(entity); return(new OperationResult(OperationResultType.Success, "update completed")); }
/// <summary> /// 获取custid, 当月在shipID下的订单总和 /// </summary> /// <param name="custId"></param> /// <param name="shipId"></param> /// <returns></returns> public double GetOrdersByCurrentMonth(string custId, string shipId) { double returnValue = 0; try { returnValue = SALES_EORDERSRepository.GetOrdersByCurrentMonth(custId, shipId); } catch (Exception ex) { returnValue = 0; } return(returnValue); }
public IEnumerable <InvoiceDetailModel> GetInvdetailByCustid(string Custid, string invoiceNo, int invoiceType) { return(SALES_EORDERSRepository.GetInvdetailByCustid(Custid, invoiceNo, invoiceType)); }
public IEnumerable <InvByCustidModel> GetInvByCustid(string Custid, string dateFrom, string dateTo, string searchKey, string type) { return(SALES_EORDERSRepository.GetInvByCustid(Custid, dateFrom, dateTo, searchKey, type)); }
public IEnumerable <OrderLocaByuseridModel> GetLocaByuserid(string Custid, string userId) { return(SALES_EORDERSRepository.GetLocaByuserid(Custid, userId)); }
public IEnumerable <OrderInvByProdModel> GetInvByProd(string Custid, string itmembr, string date1, string date2) { return(SALES_EORDERSRepository.GetInvByProd(Custid, itmembr, date1, date2)); }
public IEnumerable <OrderSalesByClasalesProductModel> GetclasalesByCustidByprod(string Custid, string date1, string date2, string itclass, string loca) { return(SALES_EORDERSRepository.GetclasalesByCustidByprod(Custid, date1, date2, itclass, loca)); }
public IEnumerable <OrderSalesByClasalesModel> GetClasalesByCustid(string Custid, string date1, string date2, string loca) { return(SALES_EORDERSRepository.GetClasalesByCustid(Custid, date1, date2, loca)); }
public IEnumerable <OrderSalesByCustidByloca> GetsalesByCustidByloca(string Custid, string date1, string date2) { return(SALES_EORDERSRepository.GetsalesByCustidByloca(Custid, date1, date2)); }
public IEnumerable <Order_Status> GetOrderStatus(string Custid) { return(SALES_EORDERSRepository.GetOrderStatus(Custid)); }