/// <summary>
/// 向数据库中添加一条记录
/// </summary>
/// <param name="model">要添加的实体</param>
/// <returns>插入数据的ID</returns>
public int Insert(OrderReturns model)
{
#region SQL语句
const string sql = @"
INSERT INTO [dbo].[OrderReturns] (
[orderId]
,[payPrice]
,[returnPrice]
,[returnStatus]
,[returnTime]
)
VALUES (
@orderId
,@payPrice
,@returnPrice
,@returnStatus
,@returnTime
);select @@IDENTITY";
#endregion
var res = SqlHelper.ExecuteScalar(sql,
new SqlParameter("@orderId", model.orderId),
new SqlParameter("@payPrice", model.payPrice),
new SqlParameter("@returnPrice", model.returnPrice),
new SqlParameter("@returnStatus", model.returnStatus),
new SqlParameter("@returnTime", model.returnTime)
);
return(res == null ? 0 : Convert.ToInt32(res));
}
public static OpResult SaveTuiHuang(OrderReturns obj, string receiveNum)
{
var op = new OpResult();
try
{
obj.CompanyId = CommonService.CompanyId;
if (obj.Id == 0)
{
obj.State = 0;
var dist = OrderDistributionService.Find(o => o.DistributionId == obj.DistributionId);
if (dist != null)
{
dist.State = 6;
dist.ReceivedNum = dist.DeliveryNum - obj.ReturnNum;
dist.ReceivedDT = DateTime.Now;
if (obj.ReturnType == 0)//退货时
{
OrderDistributionService.Update(dist);
Update(obj.DistributionId, null, obj.Barcode);
obj.State = 1;
}
}
obj.CreateDT = DateTime.Now;
obj.CreateUID = Sys.CurrentUser.UID;
op = OrderReturnBLL.Add(obj);
//if(op.Successed)
// InventoryRecordService.SaveLog(new List<InventoryRecord>(){
// new InventoryRecord(){Barcode=obj.Barcode,StoreId=Sys.CurrentUser.StoreId,Source=12,Number=obj.ReturnNum.GetValueOrDefault()}
// });
}
else
{
var resour = OrderReturnBLL.FindById(obj.Id);
obj.ToCopyProperty(resour);
op = OrderReturnBLL.Update(resour);
}
}
catch (Exception e)
{
op.Message = e.Message;
new Sys.LogEngine().WriteError(e);
}
return(op);
}
/// <summary>
/// 根据主键ID更新一条记录
/// </summary>
/// <param name="model">更新后的实体</param>
/// <returns>执行结果受影响行数</returns>
public int Update(OrderReturns model)
{
#region SQL语句
const string sql = @"
UPDATE [dbo].[OrderReturns]
SET
[orderId] = @orderId
,[payPrice] = @payPrice
,[returnPrice] = @returnPrice
,[returnStatus] = @returnStatus
,[returnTime] = @returnTime
WHERE [returnId] = @returnId";
#endregion
return(SqlHelper.ExecuteNonQuery(sql,
new SqlParameter("@returnId", model.returnId),
new SqlParameter("@orderId", model.orderId),
new SqlParameter("@payPrice", model.payPrice),
new SqlParameter("@returnPrice", model.returnPrice),
new SqlParameter("@returnStatus", model.returnStatus),
new SqlParameter("@returnTime", model.returnTime)
));
}
/// <summary>
/// 根据主键ID更新一条记录
/// </summary>
/// <param name="model">更新后的实体</param>
/// <returns>执行结果受影响行数</returns>
public int Update(OrderReturns model)
{
return(_dao.Update(model));
}
/// <summary>
/// 向数据库中添加一条记录
/// </summary>
/// <param name="model">要添加的实体</param>
/// <returns>插入数据的ID</returns>
public int Insert(OrderReturns model)
{
return(_dao.Insert(model));
}
public OrderReturnsDetails GetOrderReturnDetails(int tenantId, int userId, OrderReturnsFilterRequest orderReturnsFilter)
{
DataSet ds = new DataSet();
OrderReturnsDetails objdetails = new OrderReturnsDetails();
List <OrderReturns> orderReturns = new List <OrderReturns>();
int TotalCount = 0;
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SP_PHYGetOrderReturnsDetails", conn)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@_tenantID", tenantId);
cmd.Parameters.AddWithValue("@_UserID", userId);
cmd.Parameters.AddWithValue("@_SearchText", orderReturnsFilter.SearchText);
cmd.Parameters.AddWithValue("@_pageno", orderReturnsFilter.PageNo);
cmd.Parameters.AddWithValue("@_pagesize", orderReturnsFilter.PageSize);
cmd.Parameters.AddWithValue("@_FilterStatus", orderReturnsFilter.FilterStatus);
MySqlDataAdapter da = new MySqlDataAdapter
{
SelectCommand = cmd
};
da.Fill(ds);
if (ds != null && ds.Tables[0] != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
OrderReturns obj = new OrderReturns
{
ReturnID = Convert.ToInt32(ds.Tables[0].Rows[i]["ReturnID"]),
OrderID = Convert.ToInt32(ds.Tables[0].Rows[i]["OrderID"]),
AWBNo = Convert.ToString(ds.Tables[0].Rows[i]["AWBNo"]),
InvoiceNo = Convert.ToString(ds.Tables[0].Rows[i]["InvoiceNo"]),
CustomerName = Convert.ToString(ds.Tables[0].Rows[i]["CustomerName"]),
MobileNumber = Convert.ToString(ds.Tables[0].Rows[i]["MobileNumber"]),
Date = Convert.ToString(ds.Tables[0].Rows[i]["Date"]),
Time = Convert.ToString(ds.Tables[0].Rows[i]["Time"]),
StatusName = Convert.ToString(ds.Tables[0].Rows[i]["StatusName"]),
orderReturnsItems = new List <OrderReturnsItem>()
};
obj.orderReturnsItems = ds.Tables[1].AsEnumerable().Where(x => (x.Field <int>("OrderID")).Equals(obj.OrderID)).Select(x => new OrderReturnsItem()
{
ItemID = Convert.ToString(x.Field <string>("ItemID")),
ItemName = Convert.ToString(x.Field <string>("ItemName")),
ItemPrice = x.Field <double>("ItemPrice"),
Quantity = x.Field <int>("Quantity")
}).ToList();
orderReturns.Add(obj);
}
}
if (ds != null && ds.Tables[2] != null)
{
TotalCount = ds.Tables[2].Rows[0]["TotalOrder"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[2].Rows[0]["TotalOrder"]);
}
objdetails.orderReturns = orderReturns;
objdetails.TotalCount = TotalCount;
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
if (ds != null)
{
ds.Dispose();
}
}
return(objdetails);
}
