/// <summary>
/// Sends a single SalesOrder object for onboarding into eMite.
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public override DTO_Result Onboard(DTO_Base data)
{
bcl.DTO.DTO_Result Results = new DTO_Result();
//Create a sales order list object
DTO.SalesOrder.DTO_SalesOrderList SalesOrders = new DTO.SalesOrder.DTO_SalesOrderList();
//check if the DTO passed is of type DTO_SalesOrder
if (data.GetType() == typeof(DTO.SalesOrder.DTO_SalesOrder))
{
//cast the dto to DTO_SalesOrder object
DTO.SalesOrder.DTO_SalesOrder salesOrder = (DTO.SalesOrder.DTO_SalesOrder)data;
//add the sales order to the list
SalesOrders.Add(salesOrder);
//onboard the sales order.
Results = Onboard(SalesOrders);
}
else
{
//Log DTO not of type DTO_SalesOrder
Log.Error("Record not of type: DTO_SalesOrder");
}
return(Results);
}
/// <summary>
/// 名称：登录验证
/// 时间：1-26
/// 作者：
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public JsonResult Login_Verification(string username, string password)
{
//创建本次请求的返回对象
DTO_Result _res = new DTO_Result();
//验证非空
if (string.IsNullOrEmpty(username))
{
_res.Result_Code = new Random().Next(100000, 999999).ToString();
_res.Result_Title = "手机号不能为空";
return(Json(_res, JsonRequestBehavior.AllowGet));
}
else if (string.IsNullOrEmpty(password))
{
_res.Result_Code = new Random().Next(100000, 999999).ToString();
_res.Result_Title = "密码不能为空";
return(Json(_res, JsonRequestBehavior.AllowGet));
}
else
{
//验证手机号码格式
if (IsMobilePhone(username))
{
//创建数据库上下文对象
MonkeyDBEntities _db = new MonkeyDBEntities();
string _jmpass = MD5JM(password);
//查询用户信息
var _loginuser = _db.ULogin.Where(a => a.ULogin_Phone.Equals(username) && a.ULogin_Password.Equals(_jmpass));
if (_loginuser.Count() == 1)
{
//获取第一个元素
Session["ULogin"] = _loginuser.FirstOrDefault();
//提示登录成功
_res.Result_Code = "000000";
_res.Result_Title = "登录成功";
return(Json(_res, JsonRequestBehavior.AllowGet));
}
else
{
//提示登录失败
_res.Result_Code = new Random().Next(100000, 999999).ToString();
_res.Result_Title = "手机号或密码错误，登录失败";
return(Json(_res, JsonRequestBehavior.AllowGet));
}
}
else
{
_res.Result_Code = new Random().Next(100000, 999999).ToString();
_res.Result_Title = "手机号格式不正确";
return(Json(_res, JsonRequestBehavior.AllowGet));
}
}
}
/// <summary>
/// Sends data for onboarding into eMite
/// </summary>
/// <param name="salesOrders"></param>
/// <returns></returns>
public override DTO_Result Onboard(DTO.SalesOrder.DTO_SalesOrderList salesOrders)
{
bcl.DTO.DTO_Result Results = new DTO_Result();
//We'll use the onboarding helper to onbaord a list of sales order data
Results = OnboardingHelper.SendData(salesOrders,
BM.Helpers.BM_SalesOrderDataTableHelper.SalesOrderIndexerConfig.PrimaryKey,
BM.Helpers.BM_SalesOrderDataTableHelper.SalesOrderIndexerConfig.DateController,
measureFields: BM.Helpers.BM_SalesOrderDataTableHelper.SalesOrderIndexerConfig.MeasureFields);
return(Results);
}
/// <summary>
/// Gets sales orders using the filter criteria supplied.
/// </summary>
/// <param name="filterCriteria"></param>
/// <returns></returns>
public override DTO_Result Get(FC_Base filterCriteria)
{
bcl.DTO.DTO_Result Results = new DTO_Result();
//defines SalesOrderList object to hold all sales orders returned by the poll.
DTO.SalesOrder.DTO_SalesOrderList SalesOrders = new DTO.SalesOrder.DTO_SalesOrderList();
//filter criteria object should be of type FC_SalesOrder
if (filterCriteria.GetType() == typeof(FC.SalesOrder.FC_SalesOrder))
{
//cast the filter criteria to the FC_SalesOrder type.
FC.SalesOrder.FC_SalesOrder cSalesOrder = (FC.SalesOrder.FC_SalesOrder)filterCriteria;
#region "Sql"
string query = @"
SELECT h.[SalesOrderID]
,h.[RevisionNumber]
,h.[OrderDate]
,h.[DueDate]
,h.[ShipDate]
,h.[Status]
,h.[OnlineOrderFlag]
,h.[SalesOrderNumber]
,h.[PurchaseOrderNumber]
,h.[AccountNumber]
,h.[CustomerID]
,h.[SalesPersonID]
,h.[TerritoryID]
,h.[BillToAddressID]
,h.[ShipToAddressID]
,h.[ShipMethodID]
,h.[CreditCardID]
,h.[CreditCardApprovalCode]
,h.[CurrencyRateID]
,h.[SubTotal]
,h.[TaxAmt]
,h.[Freight]
,h.[TotalDue]
,h.[Comment]
,CONVERT(varchar(50), h.[rowguid],120) HeaderRowGuid
,h.[ModifiedDate]
,ISNULL(e.FirstName,'') + ' ' + ISNULL(e.MiddleName,'') + ' ' + ISNULL(e.LastName,'') SalesPerson
,ISNULL(p.FirstName,'') + ' ' + ISNULL(p.MiddleName,'') + ' ' + ISNULL(p.LastName,'') CustomerName
,t.CountryRegionCode + '-' + t.Name Territory
,sh.Name ShipMethod
FROM Sales.SalesOrderHeader h --INNER JOIN Sales.SalesOrderDetail d ON h.SalesOrderID = d.SalesOrderID
LEFT OUTER JOIN Sales.Customer c ON h.CustomerID = c.CustomerID
LEFT OUTER JOIN Person.Person p ON c.PersonID = p.BusinessEntityID
LEFT OUTER JOIN Person.Person e ON h.SalesPersonID = e.BusinessEntityID
LEFT OUTER JOIN Purchasing.ShipMethod sh ON h.ShipMethodID = sh.ShipMethodID
LEFT OUTER JOIN Sales.SalesTerritory t ON h.TerritoryID = t.TerritoryID
WHERE h.ModifiedDate > @StartDate AND h.ModifiedDate <= @EndDate
";
#endregion
IEnumerable <dynamic> results = null;
//run the query (via dapper) on the Adventure Works Database and fetch the results.
using (var conn = new System.Data.SqlClient.SqlConnection(Config.AdventureWorksConnection))
{
results = conn.Query <dynamic>(query, new { StartDate = cSalesOrder.StartDate, EndDate = cSalesOrder.EndDate });
}
//we'll use the Slapper.AutoMapper to map results into the SalesOrder Object. The automapper can map data into a complex DTO hierarchy
Slapper.AutoMapper.Cache.ClearInstanceCache();
//specify the primary key columns
Slapper.AutoMapper.Configuration.AddIdentifiers(typeof(DTO.SalesOrder.DTO_SalesOrder), new List <string> {
"SalesOrderID"
});
//map the results into the SalesOrders List object.
SalesOrders = new DTO.SalesOrder.DTO_SalesOrderList(Slapper.AutoMapper.MapDynamic <DTO.SalesOrder.DTO_SalesOrder>(results));
//fill in the results object for returning
Results = new DTO_Result(true, SalesOrders);
}
else
{
//Filter criteria supplied was not of type FC_SalesOrder
Results = new DTO_Result(false, "Filter criteria not of type: FC_SalesOrder");
Log.Error("Filter criteria not of type: FC_SalesOrder");
}
return(Results);
}
