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