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));
}
