/// <summary>
/// 查看换货时库存情况
///
/// </summary>
/// <param name="storeid"></param>
/// <param name=""></param>
/// <returns></returns>
public DataTable GetReplacement(string condition)
{
InventoryDocDAL inventoryDocDAL = new InventoryDocDAL();
//return inventoryDocDAL.GetReplacement(condition);
return(null);
}
/// <summary>
/// 验证公司逻辑库存是否足够
/// </summary>
/// <param name="orders">订单列表</param>
/// <returns></returns>
public static bool SelectProductNum(IList <StoreOrderModel> orders)
{
bool state = true;
string sql = "select productid,sum(quantity) as Quantity from ordergoodsdetail where ordergoodsid in (''";
foreach (StoreOrderModel order in orders)
{
sql += ",'" + order.StoreorderId + "'";
}
sql += ") group by productid ";
DataTable dt = DBHelper.ExecuteDataTable(sql);
foreach (DataRow dr in InventoryDocDAL.GetNewOrderDetail(dt).Rows)
{
if (DBHelper.ExecuteScalar("select count(0) from LogicProductInventory where productid=@pid", new SqlParameter[] { new SqlParameter("@pid", dr["productid"].ToString()) }, CommandType.Text).ToString() == "0")
{
state = false;
}
else if (Convert.ToInt32(DBHelper.ExecuteScalar("select isnull((totalin-totalout),0) from LogicProductInventory where productid=@pid", new SqlParameter[] { new SqlParameter("@pid", dr["productid"].ToString()) }, CommandType.Text)) < Convert.ToInt32(dr["Quantity"]))
{
state = false;
}
}
return(state);
}
/// <summary>
/// 确认
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSaveOrder_Click(object sender, EventArgs e)
{
string msg = "";
if (Session["storageList"] == null || Session["storageList"].ToString() == "")
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("007154", "报损产品的数量不能全部是0!")));
return;
}
else
{
DateTime dt = DateTime.Now.ToUniversalTime();
string availableOrderID = InventoryDocDAL.GetNewOrderID(Model.Other.EnumOrderFormType.CheckOutStorage);
var boolvalue = GetOrderInfo(out msg);
if (!boolvalue)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(msg));
return;
}
string makeman = txtOperationPerson.Text.Trim().Replace("'", "") == "" ? CommonDataBLL.GetNameByAdminID(Session["Company"].ToString()) : txtOperationPerson.Text.Trim().Replace("'", "");
int docTpyeId = Convert.ToInt32(QueryInStorageBLL.GetDocTypeIDEByDocTypeCode("BS"));//报损单
// CountryBLL bl = new CountryBLL();
InventoryDocModel tobjopda_depotManageDoc = new InventoryDocModel
(CommonDataBLL.GetNameByAdminID(Session["Company"].ToString()), CommonDataBLL.OperateIP, DateTime.UtcNow, CommonDataBLL.OperateBh,
docTpyeId, availableOrderID, dt, makeman, 0, Session["Company"].ToString(), Convert.ToInt32(ddlWareHouse.SelectedValue.Trim()), Convert.ToInt32(ddlDepotSeat.SelectedValue.Trim()),
Convert.ToDouble(ViewState["zongPrice"]), Convert.ToDouble(ViewState["totalPV"]), "",
CommonDataBLL.getMaxqishu(), "BS", txtMemo.Text, 1, DAL.AddFreeOrderDAL.GetCurrenT());
tobjopda_depotManageDoc.OriginalDocID = txtOriginalDocID.Text.Trim().Replace("'", "");
string rt = AddReportDamageBLL.ProductReportEDamage_II(list, Convert.ToInt32(ddlWareHouse.SelectedValue.Trim()),
Convert.ToInt32(ddlDepotSeat.SelectedValue.Trim()), "TotalOut", tobjopda_depotManageDoc);
if (rt == "1")
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("001874", "报损成功") + "');location.href='ReportDamage.aspx'</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("001880", "报损失败") + "" + "" + "');</script>");
}
setProductMenu(ddlCountry.SelectedValue, ddlWareHouse.SelectedValue, ddlDepotSeat.SelectedValue);
}
}
/// <summary>
/// 根据单据号查询单据日志
/// </summary>
/// <param name="docId">单据号</param>
/// <returns></returns>
public string GetNoteByDocId(string docId)
{
return(InventoryDocDAL.GetNoteByDocId(docId));
}
/// <summary>
/// 更新退货款状态为已审核
/// </summary>
/// <param name="warehouseId">仓库ID</param>
/// <param name="number">管理员账号</param>
/// <param name="docId">退货单号</param>
/// <param name="storeId">退货店铺ID</param>
public void UpdateStaInventoryDocOfStateFlag(string depotSeatId, string warehouseId, string number, string docId, string storeId)
{
InventoryDocDAL.UpdateStaInventoryDocOfStateFlag(depotSeatId, warehouseId, number, docId, storeId);
}
//public DataTable GetStock(string storeID, int pageIndex, string key, int pageSize, string condition, out int recordCount, out int pageCount,int expectNum)
//{
// return inventoryDocDAL.GetStock( storeID,pageIndex,key, pageSize, condition, out recordCount, out pageCount,expectNum);
//}
/// <summary>
/// 库存情况全部
///
/// </summary>
/// <param name="storeid"></param>
/// <param name="paymentExpectNum"></param>
/// <returns></returns>
public static DataTable GetStockBySoteID(string storeID)
{
return(InventoryDocDAL.GetStockBySoteID(storeID));
}
/// <summary>
/// 获得店铺汇款信息
///
/// </summary>
/// <param name="storeid"></param>
/// <returns></returns>
public static DataTable GetRemittancesByStoreID(string storeID)
{
return(InventoryDocDAL.GetRemittancesByStoreID(storeID));
}
/// <summary>
/// 获取退货款备注——ds2012——tianfeng
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static string QueryRemark(string id)
{
return(InventoryDocDAL.QueryRemark(id));
}
/// <summary>
/// 得到货币的名称
/// </summary>
/// <param name="countryid"></param>
/// <returns></returns>
public string GetCurrencyName(string countryid)
{
return(InventoryDocDAL.GetCurrencyName(countryid));
}
/// <summary>
/// 库存报损
/// </summary>
/// <param name="?"></param>
/// <returns></returns>
public bool addReportDemage(string DocAuditer, string OperateIP, string OperateNum, string DocID)
{
InventoryDocDAL dao = new InventoryDocDAL();
return(dao.addReportDemage(DocAuditer, OperateIP, OperateNum, DocID));
}
public static string GetPoc(EnumOrderFormType orderType)
{
return(InventoryDocDAL.GetPoc(orderType));
}
/// <summary>
/// 库存调拨
/// </summary>
/// <param name="DepotSeatID"></param>
/// <param name="sum"></param>
/// <param name="productid"></param>
/// <returns></returns>
public static bool productReWareHOuse(int outWarehouse, int outDepotSeatID, int inwarehouse, int inDepotSeatID, double sum, int productid)
{
return(InventoryDocDAL.productReWareHOuse(outWarehouse, outDepotSeatID, inwarehouse, inDepotSeatID, sum, productid));
}
//wujinjian
public static string SetDiaoBo(ArrayList inventoryDocDetailsModels, int outWareHouse, int outDepotSeatID, int inWareHouse, int inDepotSeatID, InventoryDocModel tobjopda_depotManageDoc)
{
return(InventoryDocDAL.SetDiaoBo(inventoryDocDetailsModels, outWareHouse, outDepotSeatID, inWareHouse, inDepotSeatID, tobjopda_depotManageDoc));
}
/// <summary>
/// 得到可用的换货单编号，返回换货单编号
/// </summary>
public static string GetReplacementID()
{
return(InventoryDocDAL.GetReplacementID());
}
/// <summary>
/// 得到可用的单编号，
/// </summary>
public static string GetNewOrderID()
{
return(InventoryDocDAL.GetNewOrderID());
}
/// <summary>
/// 得到货币的名称
/// </summary>
/// <param name="countryid"></param>
/// <returns></returns>
public string GetCurrencyNameByPID(string productid)
{
InventoryDocDAL dao = new InventoryDocDAL();
return("");//dao.GetCurrencyNameByPID(productid);
}
/// <summary>
/// 更新订单的状态为无效的
/// </summary>
/// <param name="docID"></param>
public void UpdateStateFlagAndCloseFlag(string docID)
{
InventoryDocDAL.UpdateStateFlagAndCloseFlag(docID);
}
/// <summary>
/// 出库单 撤单
/// </summary>
/// <param name="outStorageOrderID"></param>
/// <returns></returns>
public static bool SetQuashBillOutOrder(string outStorageOrderID, List <InventoryDocDetailsModel> l_ddm, string storeOrderID)
{
return(InventoryDocDAL.SetQuashBillOutOrder(outStorageOrderID, l_ddm, storeOrderID));
}
//根据条件得到单据信息
public DataTable GetInventoryDocByCondition(string condition)
{
return(InventoryDocDAL.GetInventoryDocByCondition(condition));
}
/// <summary>
/// 获取产品原来订的数量(Outstock)
/// </summary>
/// <param name="storeOrderID"></param>
/// <returns></returns>
public static DataTable GetProductQuantity(string storeOrderID)
{
return(InventoryDocDAL.GetProductQuantity(storeOrderID));
}
public static DataTable outStoreOrder(DateTime fromTime, DateTime toTime, int moneyType, int wareHouseID, int DepotSeatID)
{
return(InventoryDocDAL.outStoreOrder(fromTime, toTime, moneyType, wareHouseID, DepotSeatID));
}
/// <summary>
/// 得到仓库名称
/// </summary>
/// <param name="WareHouseId"></param>
/// <returns></returns>
public string GetWarehouseName(string WareHouseId)
{
return(InventoryDocDAL.GetWarehouseName(WareHouseId));
}
public static string OutOrder(string storeOrderID, string outStorageOrderID, InventoryDocModel idm, List <InventoryDocDetailsModel> l_ddm)
{
return(InventoryDocDAL.OutOrder(storeOrderID, outStorageOrderID, idm, l_ddm));
}
public static bool ProductReportProfit(double sun, int productid, int warehouseid, int DepotSeatID)
{
InventoryDocDAL dao = new InventoryDocDAL();
return(dao.ProductReportProfit(sun, productid, warehouseid, DepotSeatID));
}
/// <summary>
/// 库存情况根据店铺和日期
///
/// </summary>
/// <param name="storeid"></param>
/// <param name="paymentExpectNum"></param>
/// <returns></returns>
public static DataTable GetStock(string storeID, int expectNum)
{
return(InventoryDocDAL.GetStock(storeID, expectNum));
}
/// <summary>
/// 根据单据类型的不同来获取不同的单据ID
/// </summary>
/// <param name="orderType">单据类型</param>
/// <returns></returns>
public string GetDocId(EnumOrderFormType orderType)
{
return(InventoryDocDAL.GetDocId(orderType));
}
/// <summary>
///获得总金额用于店铺帐户情况
///
/// <returns></returns>
public static double SelRemitMoneyByStoreID(string storeID)
{
return(InventoryDocDAL.SelRemitMoneyByStoreID(storeID));
}
/// <summary>
/// 添加退货单和单据明细信息
/// </summary>
/// <param name="nventoryDocModel">退货单</param>
/// <param name="number">管理员ID</param>
/// <param name="storeId">店铺ID</param>
/// <param name="inventoryDocDetailsList">退货单明细集合</param>
public void InsertInventoryDoc(InventoryDocModel nventoryDocModel, string number, string storeId, ArrayList inventoryDocDetailsList)
{
InventoryDocDAL.InsertInventoryDoc(nventoryDocModel, number, storeId, inventoryDocDetailsList);
}
/// <summary>
/// 查询到的已审汇款总额——ds2012——tianfeng
///
/// </summary>
/// <param name="storeid"></param>
/// <param name="paymentExpectNum"></param>
/// <returns></returns>
///
public static double SelRemitMoneyByStoreIDAnExpectNum_Y(string storeID, int PayExpectNum)
{
return(InventoryDocDAL.dSelRemitMoneyByStoreIDAnExpectNum_Y(storeID, PayExpectNum));
}
//////////////////////////////////////////////////////////////
/// <summary>
/// 根据退货单号统计已审核的退货单
/// </summary>
/// <param name="docId"></param>
/// <returns></returns>
public int GetStaInventoryDocByDocId(string docId)
{
return(InventoryDocDAL.GetStaInventoryDocByDocId(docId));
}
