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