/// <summary>
/// 查询 要上传的库存信息
/// </summary>
/// <returns></returns>
public GetInventoryBySearchConditionResponse GetConfirmInventory()
{
GetInventoryBySearchConditionResponse Response = new GetInventoryBySearchConditionResponse();
DataSet ds = this.ExecuteDataSet("Proc_WMS_GetAkzoInventoryConfirm");
Response.InventoryCollection = ds.Tables[0].ConvertToEntityCollection <Inventorys>();
return(Response);
}
/// <summary>
/// 库存移动上传数据查询
/// </summary>
/// <returns></returns>
public GetInventoryBySearchConditionResponse GetAkzoInventoryMoveConfirm()
{
GetInventoryBySearchConditionResponse response = new GetInventoryBySearchConditionResponse();
//DbParam[] dbParams = new DbParam[]{
// new DbParam("@adjustnumber",DbType.String,AdjustNumber,ParameterDirection.Input)
//};
DataSet ds = this.ExecuteDataSet("Proc_WMS_GetAkzoInventoryMoveConfirm");
response.AdjustCollection = ds.Tables[0].ConvertToEntityCollection <Adjustment>();
response.AdjustDetailCollection = ds.Tables[1].ConvertToEntityCollection <AdjustmentDetail>();
return(response);
}
public GetInventoryBySearchConditionResponse GetPrintByAdjust(string AdjustNumber)
{
GetInventoryBySearchConditionResponse response = new GetInventoryBySearchConditionResponse();
DbParam[] dbParams = new DbParam[] {
new DbParam("@adjustnumber", DbType.String, AdjustNumber, ParameterDirection.Input)
};
DataSet ds = this.ExecuteDataSet("Proc_WMS_GetPrintByAdjust", dbParams);
response.AdjustDetailCollection = ds.Tables[0].ConvertToEntityCollection <AdjustmentDetail>();
return(response);
}
/// <summary>
/// 库存移动上传数据查询
/// </summary>
/// <returns></returns>
public GetInventoryBySearchConditionResponse GetInventoryWarning()
{
GetInventoryBySearchConditionResponse response = new GetInventoryBySearchConditionResponse();
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(@" select * from (select CustomerID,CustomerName,Warehouse,SKU,GoodsName,SUM(Qty) Qty,(select top 1 ISNULL(Grade,0) from WMS_Product where
WMS_Inventory_108.SKU=WMS_Product.SKU) QtyWarning from WMS_Inventory_108
where InventoryType =1 and CustomerID=108
group by CustomerID,CustomerName,GoodsName,Warehouse,SKU) i
where (i.Qty<=i.QtyWarning or i.QtyWarning !=0)");
DataTable dt = this.ScanDataTable(stringBuilder.ToString());
response.InventoryCollection = dt.ConvertToEntityCollection <Inventorys>();
//response.AdjustDetailCollection = ds.Tables[1].ConvertToEntityCollection<AdjustmentDetail>();
return(response);
}
public GetInventoryBySearchConditionResponse GetInventoryBySKU(string Warehouse, string CustomerID, string SKU)
{
GetInventoryBySearchConditionResponse response = new GetInventoryBySearchConditionResponse();
DbParam[] dbParams = new DbParam[] {
new DbParam("@SKU", DbType.String, SKU, ParameterDirection.Input),
new DbParam("@CustomerID", DbType.String, CustomerID, ParameterDirection.Input),
new DbParam("@Warehouse", DbType.String, Warehouse, ParameterDirection.Input)
};
DataSet ds = this.ExecuteDataSet("Proc_WMS_GetInventoryBySKU", dbParams);
response.InventoryCollection = ds.Tables[0].ConvertToEntityCollection <Inventorys>();
response.ReceiptCollection = ds.Tables[1].ConvertToEntityCollection <Receipt>();
response.OrderCollection = ds.Tables[2].ConvertToEntityCollection <OrderInfo>();
response.AdjustCollection = ds.Tables[3].ConvertToEntityCollection <Adjustment>();
return(response);
}
public GetInventoryBySearchConditionResponse TotalReport(InventorySearchCondition Condition)
{
GetInventoryBySearchConditionResponse Response = new GetInventoryBySearchConditionResponse();
string sqlWhere = this.GetInventoryRemainingWhere(Condition);
// string sqlOrderByType = this.OrderByType(Condition);
int tempRowCount = 0;
DbParam[] dbParams = new DbParam[] {
new DbParam("@SqlWhere", DbType.String, sqlWhere, ParameterDirection.Input),
new DbParam("@StateDate", DbType.String, "AND CONVERT(VARCHAR(100), CreateTime, 23) ='" + Condition.StateDate.Value.ToString("yyyy-MM-dd") + "'", ParameterDirection.Input)
};
DataSet ds = this.ExecuteDataSet("[Proc_SCInventorySummaryReport]", dbParams);
Response.directAddInventory = ds.Tables[0].ConvertToEntityCollection <DirectAddInventory>();
Response.Total = ds.Tables[1].ConvertToEntityCollection <DirectAddInventory>();
Response.daily = ds.Tables[2].ConvertToEntityCollection <DirectAddInventory>();
//RowCount = (int)dbParams[3].Value;
return(Response);
}
public GetInventoryBySearchConditionResponse InventoryCompare(DataSet ds, User p, out string message)
{
message = "";
GetInventoryBySearchConditionResponse response = new GetInventoryBySearchConditionResponse();
//DbParam[] dbParams = new DbParam[]{
// new DbParam("@adjustnumber",DbType.String,AdjustNumber,ParameterDirection.Input)
//};
//DataSet ds = this.ExecuteDataSet("Proc_WMS_GetPrintByAdjust", dbParams);
DataTable dt = ds.Tables[0];
using (SqlConnection conn = new SqlConnection(BaseAccessor._dataBase.ConnectionString))
{
SqlCommand cmd = new SqlCommand("Pro_wms_GetInventoryCompareResult", conn);//对比库存存过
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@InsertData", dt);
cmd.Parameters[0].SqlDbType = SqlDbType.Structured;
cmd.Parameters.AddWithValue("@userid", p.ID);
cmd.Parameters[1].SqlDbType = SqlDbType.BigInt;
cmd.Parameters.AddWithValue("@projectid", p.ProjectID);
cmd.Parameters[2].SqlDbType = SqlDbType.BigInt;
cmd.Parameters.AddWithValue("@customerid", p.CustomerID);
cmd.Parameters[3].SqlDbType = SqlDbType.BigInt;
cmd.Parameters.AddWithValue("@warehouseid", p.WarehouseID);
cmd.Parameters[4].SqlDbType = SqlDbType.BigInt;
cmd.Parameters.Add("@message", SqlDbType.NVarChar, 50);
cmd.Parameters[5].Direction = ParameterDirection.Output;
cmd.CommandTimeout = 300;
conn.Open();
DataSet dss = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
sda.Fill(dss);
message = sda.SelectCommand.Parameters["@message"].Value.ToString();
conn.Close();
response.InventoryCompareCollection = dss.Tables[0].ConvertToEntityCollection <InventoryCompare>();
}
return(response);
}
public GetInventoryBySearchConditionResponse GetInventoryBySearchConditionGroup(InventorySearchCondition SearchCondition, int PageIndex, int PageSize, out int RowCount)
{
GetInventoryBySearchConditionResponse response = new GetInventoryBySearchConditionResponse();
string sqlWhere = this.GenGetInventory(SearchCondition);
string sqlOrderByType = this.OrderByType(SearchCondition);
string sqlOrderByType2 = this.OrderByType2(SearchCondition);
int tempRowCount = 0;
DbParam[] dbParams = new DbParam[] {
new DbParam("@Where", DbType.String, sqlWhere, ParameterDirection.Input),
new DbParam("@OrderByType", DbType.String, sqlOrderByType, ParameterDirection.Input),
new DbParam("@OrderByType2", DbType.String, sqlOrderByType2, ParameterDirection.Input),
new DbParam("@PageIndex", DbType.Int32, PageIndex, ParameterDirection.Input),
new DbParam("@PageSize", DbType.Int32, PageSize, ParameterDirection.Input),
new DbParam("@RowCount", DbType.Int32, tempRowCount, ParameterDirection.Output)
};
DataSet ds = this.ExecuteDataSet("Proc_WMS_GetInventoryBySearchConditionGroup", dbParams);
RowCount = (int)dbParams[5].Value;
//return ds.Tables[0].ConvertToEntityCollection<Inventorys>();
response.InventoryCollection = ds.Tables[0].ConvertToEntityCollection <Inventorys>();
response.InventoryCollection2 = ds.Tables[1].ConvertToEntityCollection <Inventorys>();
return(response);
}
