protected void btnCheck_Click(object sender, EventArgs e)
        {
            string userName        = ToolCode.Tool.GetUser().UserName;
            string inventoryNumber = ToolManager.GetQueryString("InventoryNumber");
            string sql             = string.Format(@" select   Auditor  from StockInventoryLog
where InventoryNumber ='{0}' ", inventoryNumber);
            string tempstr         = SqlHelper.GetScalar(sql);

            if (!string.IsNullOrEmpty(tempstr))
            {
                lbMsg.Text = string.Format("审核失败!原因:该盘点单已由" + tempstr + "审核,请勿重复审核!");
                return;
            }
            string result = StoreroomToolManager.CheckStockInventoryLog(inventoryNumber, userName);


            if (result.Equals("1"))
            {
                Response.Redirect("StockInventoryLogList.aspx");
            }
            else
            {
                lbMsg.Text = string.Format("审核失败!原因:" + result);
            }
        }
        /// <summary>
        /// 原材料生产出库审核
        /// </summary>
        /// <param name="auditor"></param>
        /// <param name="warehouseNumber"></param>
        /// <returns></returns>
        public static string SCCKAuditor(string auditor, string warehouseNumber)
        {
            string        error = string.Empty;
            List <string> sqls  = new List <string>();
            //            string sql = string.Format(@" update MaterialStock set StockQty =vmq.StockQty-mwld.Qty   from  MaterialWarehouseLogDetail mwld
            //inner join MaterialStock vmq on mwld.MaterialNumber =vmq.MaterialNumber
            //where mwld.WarehouseNumber='{0}' ", warehouseNumber);
            //            sqls.Add(sql);

            //写入欠料明细
            //            string sql = string.Format(@"
            //insert into T_LessMaterialBreakdown(WarehouseNumber ,DocumentNumber ,MaterialNumber ,RowNumber ,LeadTime ,CustomerMaterialNumber
            //,LibraryQty,StockQty ,LessMaterialQty ,CreateTime ,IsLessMaterial )
            //select mwld.WarehouseNumber,mwld.DocumentNumber ,mwld. MaterialNumber,mwld.RowNumber ,
            //mwld.LeadTime ,mwld.CustomerMaterialNumber,mwld. Qty,vmq.StockQty,
            //case when vmq.StockQty<0 then mwld.Qty else
            //vmq.StockQty -mwld.Qty end,'{1}','未还料'   from  MaterialWarehouseLogDetail mwld
            //inner join MaterialStock vmq on mwld.MaterialNumber =vmq.MaterialNumber
            //where mwld.WarehouseNumber='{0}'
            //and vmq.StockQty-mwld.Qty <0", warehouseNumber, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
            //            sqls.Add(sql);
            string sql = string.Format(@"insert into T_LessMaterialBreakdown(WarehouseNumber ,DocumentNumber ,MaterialNumber ,RowNumber ,LeadTime ,CustomerMaterialNumber
,LibraryQty,StockQty ,LessMaterialQty ,CreateTime ,IsLessMaterial )
select '',mwld.DocumentNumber ,mwld. MaterialNumber,'',
'' ,mwld.CustomerMaterialNumber,mwld. Qty,vmq.StockQty,
case when vmq.StockQty<0 then 0-mwld.Qty else
vmq.StockQty -mwld.Qty end,'{1}','未还料'   from  (
select DocumentNumber,MaterialNumber,CustomerMaterialNumber,SUM(Qty) Qty from MaterialWarehouseLogDetail
where WarehouseNumber ='{0}'
group by DocumentNumber,MaterialNumber,CustomerMaterialNumber) mwld
inner join MaterialStock vmq on mwld.MaterialNumber =vmq.MaterialNumber
where
 vmq.StockQty-mwld.Qty <0
 ", warehouseNumber, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));

            sqls.Add(sql);
            //更新库存
            sql = string.Format(@"
update MaterialStock set StockQty =
case when a.ChangeDirection='入库' then StockQty +a.Qty else StockQty-a.Qty end
,UpdateTime =CONVERT (varchar(100),GETDATE(),120) from
( select mwld.MaterialNumber,mwl.ChangeDirection,sum(mwld.Qty) as Qty from  MaterialWarehouseLogDetail mwld
  inner join MarerialWarehouseLog mwl on
 mwld.WarehouseNumber =mwl.WarehouseNumber
 where mwl.WarehouseNumber='{0}' and mwld.Qty>0
 group by mwld.MaterialNumber,mwl.ChangeDirection) a
 inner join MaterialStock ms on ms.MaterialNumber=a.MaterialNumber
 where  ms.WarehouseName ='ycl'
 ", warehouseNumber);
            sqls.Add(sql);

            sql = string.Format(@" update MarerialWarehouseLog set Auditor='{0}' , CheckTime='{1}' where WarehouseNumber  ='{2}'", auditor, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), warehouseNumber);
            sqls.Add(sql);

            //更新瞬时库存数量
            sqls.Add(StoreroomToolManager.GetUpDateInventoryQtySql(warehouseNumber));
            //写入流水账
            sqls.Add(StoreroomToolManager.WriteMateriLSZ(warehouseNumber, auditor));
            return(SqlHelper.BatchExecuteSql(sqls, ref error) ? "1" : error);
        }
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            string warehouseNumber   = ToolManager.GetQueryString("WarehouseNumber");
            string cgOrderNumber     = txtCGorderNumber.Text.Trim();
            string supplMareitNumber = txtSuppliMateriNumber.Text.Trim();
            string qty    = txtQty.Text;
            string remark = txtRemark.Text;

            if (string.IsNullOrEmpty(cgOrderNumber) || string.IsNullOrEmpty(supplMareitNumber) ||
                string.IsNullOrEmpty(qty))
            {
                lbSubmit.Text = "信息填写不完整";
                return;
            }

            string error  = string.Empty;
            bool   result = StoreroomToolManager.AddCCTLCKDetail(warehouseNumber, cgOrderNumber, supplMareitNumber, qty, remark, ref error);

            if (result)
            {
                Response.Write(ToolManager.GetClosePageJS());
                Response.End();
                return;
            }
            else
            {
                lbSubmit.Text = "添加失败!原因:" + error;
            }
        }
Example #4
0
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            string error           = string.Empty;
            string warehouseNumber = ToolManager.GetQueryString("WarehouseNumber");

            lbMsg.Text = StoreroomToolManager.AddYPCK(warehouseNumber, drpOrderNumber.SelectedValue, ref error) ? "添加成功" : "添加失败!原因:" + error;
        }
Example #5
0
        public void ProcessRequest(HttpContext context)
        {
            string result = string.Empty;
            string sql    = string.Empty;

            //取原材料或者产品
            if (ToolManager.CheckQueryString("IsMaterial"))
            {
                //原材料
                if (ToolManager.GetQueryString("IsMaterial").Equals("true"))
                {
                    sql = string.Format(@" select top 20  MaterialNumber,MaterialName from MarerialInfoTable ");

                    sql += string.Format(@"  where
MaterialNumber like '%{0}%' or MaterialNumber like'%{0}' or MaterialNumber like '{0}%' or
MaterialName like '%{0}%' or MaterialName like'%{0}' or MaterialName like '{0}%' 
order by MaterialNumber asc", ToolManager.GetQueryString("MaterialNumber"));

                    DataTable dt = SqlHelper.GetTable(sql);
                    if (dt.Rows.Count > 0)
                    {
                        foreach (DataRow dr in dt.Rows)
                        {
                            result += string.Format(" <tr><td>{0}</td><td>{1}</td></tr>", dr["MaterialName"], dr["MaterialNumber"]);
                        }
                    }
                }
                else//产品
                {
                }
            }
            //取库存数量
            if (ToolManager.CheckQueryString("TableName"))
            {
                string tableName                 = ToolManager.GetQueryString("TableName");
                string warehouseNumber           = ToolManager.GetQueryString("WarehouseNumber"); //出入库编号
                string supplierMaterialNumberStr = string.Empty;                                  //供应商物料编号字符串
                string customerMaterialNumberStr = string.Empty;                                  //客户物料编号字符串
                string qty = string.Empty;                                                        //库存数量
                //原材料
                if (ToolManager.GetQueryString("IsMaterialForQty").Equals("true"))
                {
                    string materialNumber = ToolManager.GetQueryString("MaterialNumber"); //原材料编号
                    sql = string.Format(@"select SupplierMaterialNumber
from MaterialSupplierProperty where MaterialNumber='{0}'", materialNumber);
                    supplierMaterialNumberStr = ControlBindManager.GetOption(sql, "SupplierMaterialNumber", "SupplierMaterialNumber");
                    sql = string.Format(@"
select CustomerMaterialNumber from MaterialCustomerProperty where MaterialNumber='{0}'", materialNumber);
                    customerMaterialNumberStr = ControlBindManager.GetOption(sql, "CustomerMaterialNumber", "CustomerMaterialNumber");
                    qty    = StoreroomToolManager.GetinventoryQty(materialNumber, "", "", warehouseNumber, tableName, ToolEnum.ProductType.Marerial);
                    result = supplierMaterialNumberStr + "^" + customerMaterialNumberStr + "^" + qty;
                }
                else //产品
                {
                }
            }
            context.Response.ContentType = "text/plain";
            context.Response.Write(result);
        }
Example #6
0
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            string error           = string.Empty;
            string warehouseNumber = ToolManager.GetQueryString("WarehouseNumber");

            lbMsg.Text = StoreroomToolManager.AddYPRK(warehouseNumber, txtSuppilMateriNumber.Text.Trim()
                                                      , txtQty.Text.Trim(), txtRemark.Text, ref error) ? "添加成功" : "添加失败!原因:" + error;
        }
Example #7
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         string error = string.Empty;
         //删除
         if (ToolManager.CheckQueryString("ids"))
         {
             string ids     = ToolManager.GetQueryString("ids");
             string temp    = StoreroomToolManager.MarerialWarehouseLogListDelete(ids);
             bool   restult = temp == "1" ? true : false;
             if (restult)
             {
                 Tool.WriteLog(Tool.LogType.Operating, "删除原材料出入库信息" + ToolManager.ReplaceSingleQuotesToBlank(ids), "删除成功");
                 Response.Write(temp);
                 Response.End();
                 return;
             }
             else
             {
                 Tool.WriteLog(Tool.LogType.Operating, "删除原材料出入库信息" + ToolManager.ReplaceSingleQuotesToBlank(ids), "删除失败!原因" + temp);
                 Response.Write(temp);
                 Response.End();
                 return;
             }
         }
         //查询
         if (ToolManager.CheckQueryString("pageIndex"))
         {
             GetPage("AddOrEditMarerialWarehouseLog.aspx", "btnSearch", "Transfer", "260", "600");
         }
         //审核
         if (ToolManager.CheckQueryString("check"))
         {
             string check  = ToolManager.GetQueryString("check");
             string temp   = MarerialWarehouseLogListManager.AuditorMarerialWarehouseLog(ToolCode.Tool.GetUser().UserNumber, check);
             bool   result = temp == "1" ? true : false;
             if (result)
             {
                 Tool.WriteLog(Tool.LogType.Operating, "审核原材料出入库信息" + ToolManager.ReplaceSingleQuotesToBlank(check), "审核成功");
                 Response.Write(temp);
                 Response.End();
                 return;
             }
             else
             {
                 Tool.WriteLog(Tool.LogType.Operating, "审核原材料出入库信息" + ToolManager.ReplaceSingleQuotesToBlank(check), "审核失败!原因" + temp);
                 Response.Write(temp);
                 Response.End();
                 return;
             }
         }
         divAdd.Visible    = ToolCode.Tool.GetUserMenuFunc("L0404", "Add");
         divDelete.Visible = ToolCode.Tool.GetUserMenuFunc("L0404", "Delete");
         //divCheck.Visible = ToolCode.Tool.GetUserMenuFunc("L0404", "Audit");
     }
 }
        private string checkProductHouse(string check)
        {
            string auditor = ToolCode.Tool.GetUser().UserNumber;

            //string CheckTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            //string error = string.Empty;
            //string sql = string.Format(@" update ProductWarehouseLog set Auditor='{0}' , CheckTime='{1}' where WarehouseNumber in ({2})",
            //    Auditor, CheckTime, check);
            //return SqlHelper.ExecuteSql(sql, ref error) == true ? "1" : error;
            return(StoreroomToolManager.AutiorProductWarehouseLog(check, auditor));
        }
        public void ProcessRequest(HttpContext context)
        {
            string result = string.Empty;

            if (ToolManager.GetQueryString("IsQueryOdersNumber").Equals("true")) //查询订单的ajax请求
            {
                string    sql = string.Format(@"  select distinct top 10  InventoryNumber from StockInventoryLog  
 where 
InventoryNumber like '%{0}%' or InventoryNumber like'%{0}' or InventoryNumber like '{0}%'  order by  InventoryNumber desc ", ToolManager.GetQueryString("OdersNumber"));
                DataTable dt  = SqlHelper.GetTable(sql);
                if (dt.Rows.Count > 0)
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        result += string.Format(" <tr><td>{0}</td></tr>", dr["InventoryNumber"]);
                    }
                }
            }
            else if (ToolManager.GetQueryString("IsQueryOdersNumber").Equals("false"))
            {
                string odersNumber = ToolManager.GetQueryString("OdersNumber");         //盘点编号
                string sql         = string.Format(@"select distinct (mo.MaterialNumber+'^'+mo.Version) as Value,
(p.ProductName+' 【'+mo.Version+'】') as Text 
 from (select * from StockInventoryLogDetail where [Version] !='0') mo
inner join Product p on mo.MaterialNumber=p.ProductNumber
where mo.InventoryNumber='{0}'  ", odersNumber);
                result = "<option value =\"\">- - - - - 请 选 择 - - - - -</option>";
                DataTable dt = SqlHelper.GetTable(sql);
                foreach (DataRow dr in dt.Rows)
                {
                    result += string.Format(" <option value ='{0}'>{1}</option> ", dr["Value"], dr["Text"]);
                }
            }
            else
            {
                string ordersNumber = ToolManager.GetQueryString("OdersNumber"); //盘点
                string product      = ToolManager.GetQueryString("Prouduct");
                if (string.IsNullOrEmpty(product))
                {
                    result = "";
                }
                else
                {
                    string   warehouseNumber = ToolManager.GetQueryString("WarehouseNumber");
                    string[] products        = product.Split('^');
                    string   inventoryQty    = StoreroomToolManager.GetinventoryQty("", products[0], products[1], warehouseNumber, "ProductStock", "ProductWarehouseLog", ToolEnum.ProductType.Product);
                    inventoryQty = inventoryQty == "" ? "0" : inventoryQty;
                    result       = inventoryQty;
                }
            }

            context.Response.ContentType = "text/plain";
            context.Response.Write(result);
        }
        protected void drpProduct_SelectedIndexChanged(object sender, EventArgs e)
        {
            string products = drpProduct.SelectedValue;

            string[] temp = products.Split('^');
            if (string.IsNullOrEmpty(products))
            {
                lbInventoryQty.Text = "";
                return;
            }
            lbInventoryQty.Text = StoreroomToolManager.GetinventoryQty("", temp[0], temp[1], warehouseNumber, "ProductStock", "ProductWarehouseLog", ToolEnum.ProductType.Product);
        }
Example #11
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string requestString = ToolManager.GetRequestString("Action");

            if (requestString != null)
            {
                if (!(requestString == "Save"))
                {
                    if (requestString == "Get")
                    {
                        this.Get();
                    }
                    else if (requestString == "Delete")
                    {
                        this.Delete();
                    }
                    else if (requestString == "Autior")
                    {
                        string str2 = string.Empty;
                        try
                        {
                            string auditor    = ToolCode.Tool.GetUser().UserNumber;
                            string number     = "'" + Request["WarehouseNumber"] + "'";
                            string tempResult = StoreroomToolManager.AutiorProductWarehouseLog(number, auditor);

                            if (!tempResult.Equals("1"))
                            {
                                str2 = JsonConvert.SerializeObject(new { Status = false, Msg = tempResult });
                            }
                            else
                            {
                                str2 = JsonConvert.SerializeObject(new { Status = true, Msg = string.Empty });
                            }
                            base.Response.Write(str2);
                            HttpContext.Current.ApplicationInstance.CompleteRequest();
                        }
                        catch (Exception exception)
                        {
                            str2 = JsonConvert.SerializeObject(new { Status = false, Msg = exception.Message });
                            base.Response.Write(str2);
                            HttpContext.Current.ApplicationInstance.CompleteRequest();
                        }
                    }
                }
                else
                {
                    this.Save();
                }
            }
        }
Example #12
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                trPlanNumberOrderNumber.Visible = false;
                Check();
                string warehouseNumber = ToolManager.GetQueryString("WarehouseNumber");
                lbWarehouseNumber.Text = warehouseNumber;
                if (ToolManager.CheckQueryString("DocumentNumber") && ToolManager.CheckQueryString("WarehouseNumber") &&
                    ToolManager.CheckQueryString("ProductNumber") && ToolManager.CheckQueryString("Version") &&
                    ToolManager.CheckQueryString("PlanNumberOrderNumber") && ToolManager.CheckQueryString("RowNumber")
                    )
                {
                    string    documentNumber        = ToolManager.GetQueryString("DocumentNumber");
                    string    productNumber         = ToolManager.GetQueryString("ProductNumber");
                    string    version               = ToolManager.GetQueryString("Version");
                    string    planNumberOrderNumber = ToolManager.GetQueryString("PlanNumberOrderNumber");
                    string    rowNumber             = ToolManager.GetQueryString("RowNumber");
                    string    sql = string.Format(@" select * from ProductWarehouseLogDetail where WarehouseNumber='{0}'
 and DocumentNumber='{1}' and ProductNumber ='{2}' and Version ='{3}'  and RowNumber='{4}' and OrdersNumber='{5}'", warehouseNumber, documentNumber, productNumber, version, rowNumber, planNumberOrderNumber);
                    DataTable dt  = SqlHelper.GetTable(sql);
                    if (dt.Rows.Count > 0)
                    {
                        DataRow dr = dt.Rows[0];
                        lbOdersNumber.Text            = dr["DocumentNumber"] == null ? "" : dr["DocumentNumber"].ToString();
                        lbProduct.Text                = dr["ProductNumber"].ToString() + "|" + dr["Version"].ToString();
                        txtCustomerProductNumber.Text = dr["CustomerProductNumber"] == null ? "" : dr["CustomerProductNumber"].ToString();
                        txtQty.Text          = dr["Qty"] == null ? "" : dr["Qty"].ToString();
                        lbOldQty.Text        = dr["Qty"] == null ? "" : dr["Qty"].ToString();
                        txtReason.Text       = dr["ReturnReason"] == null ? "" : dr["ReturnReason"].ToString() == "" ? "无" : dr["ReturnReason"].ToString();
                        txtRemark.Text       = dr["Remark"] == null ? "" : dr["Remark"].ToString();
                        txtInventoryQty.Text = StoreroomToolManager.GetinventoryQty("", dr["ProductNumber"].ToString(), dr["Version"].ToString(), warehouseNumber
                                                                                    , "ProductStock", "ProductWarehouseLog", ToolEnum.ProductType.Product);
                        lbOrdersNumber.Text    = dr["OrdersNumber"] == null ? "" : dr["OrdersNumber"].ToString();
                        lbRowNumber.Text       = dr["RowNumber"] == null ? "" : dr["RowNumber"].ToString();
                        txtOdersNumber.Visible = false;
                        lbOdersNumber.Visible  = true;
                        drpProduct.Visible     = false;
                        btnSubmit.Text         = "修改";

                        if (!planNumberOrderNumber.Equals("0"))
                        {
                            trPlanNumberOrderNumber.Visible = false;
                            trRowNumber.Visible             = false;
                        }
                    }
                }
            }
        }
Example #13
0
        protected void btnUpload_Click(object sender, EventArgs e)
        {
            string year  = drpYear.SelectedValue;
            string month = drpMonth.SelectedValue;
            string error = string.Empty;

            if (StoreroomToolManager.ImpT_ExaminationLog_KFList(year, month, FU_Excel, Server, ref error))
            {
                lbMsg.Text = "导入成功";
            }
            else
            {
                lbMsg.Text = "导入失败!<br/>" + error;
            }
        }
        protected void btnCheck_Click(object sender, EventArgs e)
        {
            string auditor = ToolCode.Tool.GetUser().UserNumber;
            string number  = "'" + ToolManager.GetQueryString("WarehouseNumber") + "'";
            string result  = StoreroomToolManager.AutiorProductWarehouseLog(number, auditor);

            if (result.Equals("1"))
            {
                Response.Redirect("ProductWarehouseLogList.aspx");
            }
            else
            {
                lbSubmit.Text = "审核失败!原因:" + result;
            }
        }
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            string error = string.Empty;
            string year  = drpYear.SelectedValue;
            string month = drpMonth.SelectedValue;

            if (StoreroomToolManager.AddWarehousePerformanceReviewLog(year, month, ref error))
            {
                Response.Write(ToolManager.GetClosePageJS());
                Response.End();
                return;
            }
            else
            {
                lbMsg.Text = "上报失败!原因:" + error;
            }
        }
Example #16
0
        protected void btnCheck_Click(object sender, EventArgs e)
        {
            string userName = ToolCode.Tool.GetUser().UserName;
            string error    = string.Empty;

            warehouseNumber = ToolManager.GetQueryString("WarehouseNumber");
            type            = Server.UrlDecode(ToolManager.GetQueryString("type")).Trim();
            bool result = StoreroomToolManager.SHYPCRK(warehouseNumber, type, userName, ref error);

            if (result)
            {
                Response.Redirect("SampleCRK.aspx");
            }
            else
            {
                lbMsg.Text = "审核失败!原因:" + error;
            }
        }
        protected void btnUpload_Click(object sender, EventArgs e)
        {
            string error  = string.Empty;
            bool   result = StoreroomToolManager.ImpMarerialScrapLogList(FU_Excel, Server, ref error);

            if (result == true)
            {
                lbMsg.Text = "导入成功";
                Tool.WriteLog(Tool.LogType.Operating, "导入报废信息", "导入成功!");
                return;
            }
            else
            {
                lbMsg.Text = error;
                Tool.WriteLog(Tool.LogType.Operating, "导入报废信息", "导入失败!原因" + error);
                return;
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                Check();
                BindDrpProduct();
                if (ToolManager.CheckQueryString("DocumentNumber") && ToolManager.CheckQueryString("WarehouseNumber") &&
                    ToolManager.CheckQueryString("ProductNumber") && ToolManager.CheckQueryString("Version"))
                {
                    string documentNumber  = "无";
                    string warehouseNumber = ToolManager.GetQueryString("WarehouseNumber");
                    string productNumber   = ToolManager.GetQueryString("ProductNumber");
                    string version         = ToolManager.GetQueryString("Version");
                    string sql             = string.Format(@"
 select ReturnReason ,Qty ,Remark  from ProductWarehouseLogDetail
 where WarehouseNumber ='{0}' and DocumentNumber ='{1}' and ProductNumber ='{2}' and Version ='{3}'", warehouseNumber, documentNumber
                                                           , productNumber, version);
                    DataTable dt = SqlHelper.GetTable(sql);
                    if (dt.Rows.Count > 0)
                    {
                        DataRow dr = dt.Rows[0];
                        txtProductNumber.Text = productNumber;
                        txtVersion.Text       = version;
                        lbProduct.Text        = productNumber + "|" + version;
                        txtQty.Text           = dr["Qty"] == null ? "" : dr["Qty"].ToString();
                        lbOldQty.Text         = dr["Qty"] == null ? "" : dr["Qty"].ToString();
                        txtReason.Text        = dr["ReturnReason"] == null ? "" : dr["ReturnReason"].ToString();
                        txtRemark.Text        = dr["Remark"] == null ? "" : dr["Remark"].ToString();

                        lbInventoryQty.Text = StoreroomToolManager.GetinventoryQty("", productNumber, version, warehouseNumber, "ProductStock", "ProductWarehouseLog", ToolEnum.ProductType.Product);

                        btnSubmit.Text     = "修改";
                        drpProduct.Visible = false;
                        lbProduct.Visible  = true;
                    }
                }
                else
                {
                    btnSubmit.Text     = "添加";
                    drpProduct.Visible = true;
                    lbProduct.Visible  = false;
                }
            }
        }
Example #19
0
        protected void btnCheck_Click(object sender, EventArgs e)
        {
            string error    = string.Empty;
            string userId   = ToolCode.Tool.GetUser().UserNumber;
            string userName = ToolCode.Tool.GetUser().UserName;

            warehousenumber = ToolManager.GetQueryString("WarehouseNumber");
            bool result = StoreroomToolManager.FPCRKCheck(warehousenumber, userId, userName, ref error);

            if (result)
            {
                Response.Redirect("ScarpWarehouseLogList.aspx");
            }
            else
            {
                lbMsg.Text = "审核失败!原因:" + error;
                return;
            }
        }
Example #20
0
        protected void btnUpload_Click(object sender, EventArgs e)
        {
            bool   result = false;
            string error  = string.Empty;
            string type   = drpType.SelectedValue;

            try
            {
                if (type.Equals("0"))//原材料库存数量导入
                {
                    result = StoreroomToolManager.ImpMaterialQty(FU_Excel, Server, ref error);
                }
                else if (type.Equals("1"))//产品库存数量
                {
                    result = StoreroomToolManager.ImpProductQty(FU_Excel, Server, ref error);
                }
                lbMsg.Text = result ? "导入成功!" : "导入失败<br/>" + error;
            }
            catch (Exception ex)
            {
                lbMsg.Text = "请检查导入类型和所选的excel模板是否一致!" + ex.Message;
                return;
            }
        }
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            string        qty          = txtQty.Text;
            string        reason       = txtReason.Text;
            string        remark       = txtRemark.Text;
            string        inventoryQty = lbInventoryQty.Text;
            List <string> sqls         = new List <string>();
            string        sql          = string.Empty;
            string        error        = string.Empty;
            bool          result       = false;

            if (btnSubmit.Text.Equals("添加"))
            {
                string   temp          = drpProduct.SelectedValue;
                string[] products      = temp.Split('^');
                string   productNumber = txtProductNumber.Text.Trim();
                string   version       = txtVersion.Text.Trim();
                if (!ProductManager.IsExit(productNumber, version))
                {
                    lbSubmit.Text = "系统不存在该产成品编号和版本,请重新输入!";
                    return;
                }
                //if (Convert.ToInt32(inventoryQty) < Convert.ToInt32(qty))
                //{
                //    lbSubmit.Text = "库存数量小于出库数量!无法出库";
                //    return;
                //}
                if (StoreroomToolManager.IsExitForProductWarehouseLogDetail(warehouseNumber, "无", productNumber, version))
                {
                    lbSubmit.Text = "已存在相同记录!";
                    return;
                }
                sql = string.Format(@"  insert into ProductWarehouseLogDetail (WarehouseNumber ,DocumentNumber ,ProductNumber
 ,Version ,ReturnReason ,Qty ,InventoryQty ,Remark ,RowNumber) values('{0}','无','{1}','{2}','{3}',{4},0,'{5}','无') "
                                    , warehouseNumber, productNumber, version, reason, qty, remark);
                sqls.Add(sql);
                result        = SqlHelper.BatchExecuteSql(sqls, ref error);
                lbSubmit.Text = result == true ? "添加成功" : "添加失败,原因:" + error;
                if (result)
                {
                    Tool.WriteLog(Tool.LogType.Operating, "增加产品报废出库信息" + warehouseNumber, "增加成功");
                    Response.Write("<script>window.close();</script>");
                    return;
                }
                else
                {
                    Tool.WriteLog(Tool.LogType.Operating, "增加产品报废出库信息" + warehouseNumber, "增加失败!原因" + error);
                    return;
                }
            }
            else
            {
                string documentNumber  = "无";
                string warehouseNumber = ToolManager.GetQueryString("WarehouseNumber");
                string productNumber   = ToolManager.GetQueryString("ProductNumber");
                string version         = ToolManager.GetQueryString("Version");
                //string oldQty = lbOldQty.Text;
                //int poor = Convert.ToInt32(qty) - Convert.ToInt32(oldQty); //算差值
                //if (poor > 0) //还要出库
                //{
                //    if (Convert.ToInt32(inventoryQty) < poor) //库存数量小于要修改的差
                //    {
                //        lbSubmit.Text = "库存数量低!无法进行此操作";
                //        return;
                //    }

                //}
                //poor = 0 - poor;//取反
                sql = string.Format(@" update ProductWarehouseLogDetail set ReturnReason ='{0}',Qty ='{1}',Remark ='{2}'
 where WarehouseNumber ='{3}' and DocumentNumber ='{4}' and ProductNumber ='{5}' and Version ='{6}' "
                                    , reason, qty, remark, warehouseNumber, documentNumber, productNumber, version);
                sqls.Add(sql);
                result        = SqlHelper.BatchExecuteSql(sqls, ref error);
                lbSubmit.Text = result == true ? "修改成功" : "修改失败,原因:" + error;
                if (result)
                {
                    Tool.WriteLog(Tool.LogType.Operating, "编辑产品报废出库明细" + warehouseNumber, "编辑成功");
                    Response.Write("<script>window.close();</script>");
                    return;
                }
                else
                {
                    Tool.WriteLog(Tool.LogType.Operating, "编辑产品报废出库明细" + warehouseNumber, "编辑失败!原因" + error);
                    return;
                }
            }
        }
        public void ProcessRequest(HttpContext context)
        {
            string result = string.Empty;

            if (ToolManager.GetQueryString("IsQueryOdersNumber").Equals("true")) //查询销售订单的ajax请求
            {
                string changeDirection = System.Web.HttpContext.Current.Server.UrlDecode(ToolManager.GetQueryString("ChangeDirection")).Trim();
                string conditon        = string.Empty;
                switch (changeDirection)
                {
                case "退货入库": conditon = " and  so.OdersType ='正常订单' ";
                    break;

                case "包装入库": conditon = " and  so.OdersType ='正常订单' ";
                    break;

                case "维修入库": conditon = " and  so.OdersType ='维修订单' ";
                    break;

                case "销售出库": conditon = " and  so.OdersType ='正常订单' ";
                    break;

                case "样品出库": conditon = " and  so.OdersType ='样品订单' ";
                    break;

                case "维修出库": conditon = " and  so.OdersType ='维修订单' ";
                    break;
                }

                string    sql = string.Format(@"select distinct top 10 t.OdersNumber from ( select distinct top 10   mo.OdersNumber from MachineOderDetail mo inner join SaleOder so on so.OdersNumber =mo.OdersNumber
   where 1=1   {1}
order by mo.OdersNumber desc) t where 
t.OdersNumber like '%{0}%' or t.OdersNumber like'%{0}' or t.OdersNumber like '{0}%'  ", ToolManager.GetQueryString("OdersNumber"), conditon);
                DataTable dt  = SqlHelper.GetTable(sql);
                if (dt.Rows.Count > 0)
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        result += string.Format(" <tr><td>{0}</td></tr>", dr["OdersNumber"]);
                    }
                }
            }
            else if (ToolManager.GetQueryString("IsQueryOdersNumber").Equals("false"))
            {
                string odersNumber = ToolManager.GetQueryString("OdersNumber");         //销售订单号
                string sql         = string.Format(@"select distinct (mo.ProductNumber+'^'+mo.Version) as Value,
(p.ProductName+' 【'+mo.Version+'】') as Text 
 from MachineOderDetail mo
inner join Product p on mo.ProductNumber=p.ProductNumber
where mo.OdersNumber='{0}'  ", odersNumber);
                result = "<option value =\"\">- - - - - 请 选 择 - - - - -</option>";
                DataTable dt = SqlHelper.GetTable(sql);
                foreach (DataRow dr in dt.Rows)
                {
                    result += string.Format(" <option value ='{0}'>{1}</option> ", dr["Value"], dr["Text"]);
                }
            }
            else
            {
                string ordersNumber = ToolManager.GetQueryString("OdersNumber");
                string product      = ToolManager.GetQueryString("Prouduct");
                if (string.IsNullOrEmpty(product))
                {
                    result = "^";
                }
                else
                {
                    string   warehouseNumber = ToolManager.GetQueryString("WarehouseNumber");
                    string[] products        = product.Split('^');
                    string   sql             = string.Format(@"select CustomerProductNumber from  ProductCustomerProperty
where CustomerId=(
select CustomerId from SaleOder where OdersNumber ='{0}')
and ProductNumber='{1}' and Version ='{2}'", ordersNumber, products[0], products[1]);
                    result = SqlHelper.GetScalar(sql);
                    string inventoryQty = StoreroomToolManager.GetinventoryQty("", products[0], products[1], warehouseNumber, "ProductStock", "ProductWarehouseLog", ToolEnum.ProductType.Product);
                    inventoryQty = inventoryQty == "" ? "0" : inventoryQty;
                    result       = result + "^" + inventoryQty;
                }
            }

            context.Response.ContentType = "text/plain";
            context.Response.Write(result);
        }
        /// <summary>
        /// 销售出库(贸易)审核
        /// </summary>
        /// <param name="warehouseNumber"></param>
        /// <returns></returns>
        public static string CheckMYXS(string auditor, string warehouseNumber)
        {
            string        sql    = string.Empty;
            DataTable     dtTemp = new DataTable();
            string        result = string.Empty;
            List <string> sqls   = new List <string>();
            string        error  = string.Empty;

            sql    = string.Format(@"select mwld.DocumentNumber ,mwld.MaterialNumber ,mwld.LeadTime
from MaterialWarehouseLogDetail mwld inner join MarerialWarehouseLog mwl on mwl.WarehouseNumber =mwld.WarehouseNumber
left join TradingOrderDetail cod  on mwld.DocumentNumber=cod.OdersNumber
and mwld.MaterialNumber =cod.ProductNumber and mwld.LeadTime =cod.Delivery  and mwld.RowNumber =cod.RowNumber
where mwld.Qty -cod.NonDeliveryQty >0
and mwl.WarehouseNumber ='{0}'", warehouseNumber);
            dtTemp = SqlHelper.GetTable(sql);
            if (dtTemp.Rows.Count > 0)
            {
                foreach (DataRow dr in dtTemp.Rows)
                {
                    result += string.Format(" 订单编号为:{0} 原材料编号为:{1} 交期为{2}的记录的数量大于订单未交数量!&nbsp;&nbsp;"
                                            , dr["DocumentNumber"], dr["MaterialNumber"], dr["LeadTime"]);
                }
                return(result);
            }
            //纠错 仅限于销售出库(贸易)
            string tempsql1 = string.Format(@"
DELETE MaterialWarehouseLogDetail
WHERE  WarehouseNumber = '{0}'
       AND Qty < 0;
", warehouseNumber);

            SqlHelper.ExecuteSql(tempsql1);

            //更新订单完成数量
            //sqls.Add(GetUpdateQtySql(warehouseNumber));

            //生成送货单
            List <string> sqlsTemp = GetSqlForShSHD(warehouseNumber);

            if (sqlsTemp.Count > 0)
            {
                sqls.AddRange(sqlsTemp);
            }
            sql = string.Format(@"
INSERT INTO T_LessMaterialBreakdown(WarehouseNumber ,DocumentNumber ,MaterialNumber ,RowNumber ,LeadTime ,CustomerMaterialNumber ,LibraryQty,StockQty ,LessMaterialQty ,CreateTime ,IsLessMaterial)
SELECT '',
       mwld.DocumentNumber ,
       mwld. MaterialNumber,
       '',
       '' ,
       mwld.CustomerMaterialNumber,
       mwld. Qty,
       vmq.StockQty,
       CASE
           WHEN vmq.StockQty<0 THEN 0-mwld.Qty
           ELSE vmq.StockQty -mwld.Qty
       END,
       '{1}',
       '未还料'
FROM
  (SELECT DocumentNumber,
          MaterialNumber,
          CustomerMaterialNumber,
          SUM(Qty) Qty
   FROM MaterialWarehouseLogDetail
   WHERE WarehouseNumber ='{0}'
   GROUP BY DocumentNumber,
            MaterialNumber,
            CustomerMaterialNumber) mwld
INNER JOIN MaterialStock vmq ON mwld.MaterialNumber =vmq.MaterialNumber
WHERE vmq.StockQty-mwld.Qty <0
 ", warehouseNumber, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
            sqls.Add(sql);
            //更新库存
            sql = string.Format(@"update MaterialStock set StockQty =
case when a.ChangeDirection='入库' then StockQty +a.Qty else StockQty-a.Qty end
,UpdateTime =CONVERT (varchar(100),GETDATE(),120) from
( select mwld.MaterialNumber,mwl.ChangeDirection,sum(mwld.Qty) as Qty from  MaterialWarehouseLogDetail mwld
  inner join MarerialWarehouseLog mwl on
 mwld.WarehouseNumber =mwl.WarehouseNumber
 where mwl.WarehouseNumber='{0}'
 group by mwld.MaterialNumber,mwl.ChangeDirection) a
 inner join MaterialStock ms on ms.MaterialNumber=a.MaterialNumber
 where  ms.WarehouseName ='ycl'
 ", warehouseNumber);
            sqls.Add(sql);

            sql = string.Format(@" update MarerialWarehouseLog set Auditor='{0}' , CheckTime='{1}' where WarehouseNumber  ='{2}'", auditor, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), warehouseNumber);
            sqls.Add(sql);
            //更新瞬时库存数量
            sqls.Add(StoreroomToolManager.GetUpDateInventoryQtySql(warehouseNumber));
            //写入流水账
            sqls.Add(StoreroomToolManager.WriteMateriLSZ(warehouseNumber, auditor));

            sql = string.Format(" delete DeliveryNoteDetailed where DeliveryQty=0 ");//清除发货数量为0的送货单
            sqls.Add(sql);
            return(SqlHelper.BatchExecuteSql(sqls, ref error) ? "1" : error);
        }
        /// <summary>
        /// 原材料出入库审核【单条审核】
        /// </summary>
        /// <param name="auditor"></param>
        /// <param name="warehouseNumber"></param>
        /// <returns></returns>
        public static string AuditorMarerialWarehouseLogForWarehouseNumber(string auditor, string warehouseNumber)
        {
            string checksqls = string.Format(@" select CheckTime from MarerialWarehouseLog where WarehouseNumber='{0}'", warehouseNumber);

            if (!string.IsNullOrEmpty(SqlHelper.GetScalar(checksqls)))
            {
                return("该单已审核,请勿重复审核!");
            }

            List <string> sqls   = new List <string>();
            DataTable     dtTemp = null;
            string        result = string.Empty;
            string        sql    = string.Format(@"
select COUNT(*) from MaterialWarehouseLogDetail where WarehouseNumber='{0}'", warehouseNumber);

            if (SqlHelper.GetScalar(sql).Equals("0"))
            {
                return("没有需要审核的记录!");
            }
            sql = string.Format("select Type from MarerialWarehouseLog where WarehouseNumber='{0}'", warehouseNumber);
            string type = SqlHelper.GetScalar(sql);

            if (type.Equals("生产出库") || type.Equals("包装出库"))
            {
                return(SCCKAuditor(auditor, warehouseNumber));
            }
            if (type.Equals("销售出库(贸易)"))
            {
                return(CheckMYXS(auditor, warehouseNumber));
            }
            //步骤一:检测采购入库和销售出库(贸易)的数量-订单未交数量是否大于0(大于0为异常数据)
            if (type.Equals("采购入库"))
            {
                sql    = string.Format(@"
select t.DocumentNumber ,t.MaterialNumber ,t.LeadTime from (
select WarehouseNumber,DocumentNumber,MaterialNumber,LeadTime,sum(isnull(Qty,0)) qty from MaterialWarehouseLogDetail
where WarehouseNumber ='{0}'
group by
WarehouseNumber,DocumentNumber,MaterialNumber,LeadTime
)t  left join CertificateOrdersDetail cod  on t.DocumentNumber=cod.OrdersNumber
and t.MaterialNumber =cod.MaterialNumber and t.LeadTime =cod.LeadTime  where t.Qty -cod.NonDeliveryQty >0", warehouseNumber);
                dtTemp = SqlHelper.GetTable(sql);
                if (dtTemp.Rows.Count > 0)
                {
                    foreach (DataRow dr in dtTemp.Rows)
                    {
                        result += "<br/>" + string.Format(" 订单编号为:{0} 原材料编号为:{1} 交期为{2}的记录数量大于订单未交数量!&nbsp;&nbsp;"
                                                          , dr["DocumentNumber"], dr["MaterialNumber"], dr["LeadTime"]);
                    }
                    return(result);
                }
                //sqls.AddRange(FinancialManager.GetCSYF(warehouseNumber));
            }
            else if (type.Equals("销售出库(贸易)"))
            {
                sql    = string.Format(@"select mwld.DocumentNumber ,mwld.MaterialNumber ,mwld.LeadTime
from MaterialWarehouseLogDetail mwld inner join MarerialWarehouseLog mwl on mwl.WarehouseNumber =mwld.WarehouseNumber
left join TradingOrderDetail cod  on mwld.DocumentNumber=cod.OdersNumber
and mwld.MaterialNumber =cod.ProductNumber and mwld.LeadTime =cod.Delivery  and mwld.RowNumber =cod.RowNumber
where mwld.Qty -cod.NonDeliveryQty >0
and mwl.WarehouseNumber ='{0}'", warehouseNumber);
                dtTemp = SqlHelper.GetTable(sql);
                if (dtTemp.Rows.Count > 0)
                {
                    foreach (DataRow dr in dtTemp.Rows)
                    {
                        result += string.Format(" 订单编号为:{0} 原材料编号为:{1} 交期为{2}的记录的数量大于订单未交数量!&nbsp;&nbsp;"
                                                , dr["DocumentNumber"], dr["MaterialNumber"], dr["LeadTime"]);
                    }
                    return(result);
                }

                //纠错 仅限于销售出库(贸易)
                string tempsql1 = string.Format(@"
DELETE MaterialWarehouseLogDetail
WHERE  WarehouseNumber = '{0}'
       AND Qty < 0;
", warehouseNumber);
                SqlHelper.ExecuteSql(tempsql1);

                //更新订单完成数量
                sqls.Add(GetUpdateQtySql(warehouseNumber));

                //生成送货单
                List <string> sqlsTemp = GetSqlForShSHD(warehouseNumber);
                if (sqlsTemp.Count > 0)
                {
                    sqls.AddRange(sqlsTemp);
                }
            }
            //步骤二:检测库存数量是否满足出库

            if (type.Equals("销售出库(贸易)"))
            {
                string tempchecksql = string.Format(@" select COUNT (*) from (
 select t.MaterialNumber,t.WarehouseName, (ISNULL ( ms.StockQty,0)-t.Qty) as 差 from (
 select mwld.MaterialNumber ,sum( mwld.Qty ) as Qty,mwl.WarehouseName
  from MaterialWarehouseLogDetail mwld
  inner join MarerialWarehouseLog mwl on mwld.WarehouseNumber=mwl.WarehouseNumber
  where mwl.ChangeDirection ='出库'  and mwl.WarehouseNumber in ('{0}') and mwld.Qty>0
  group by mwld.MaterialNumber,mwl.WarehouseName ) t left join MaterialStock ms on t.MaterialNumber=ms.MaterialNumber  ) t where 差<0", warehouseNumber);
                if (!SqlHelper.GetScalar(tempchecksql).Equals("0"))
                {
                    return("当前库存数量低,无法满足当前出库操作。");
                }
                //return SqlHelper.GetScalar(sql).Equals("0") ? true : false;
            }
            else
            {
                //if (!CheckInventoryQty("'" + warehouseNumber + "'"))
                //{
                //    return "当前库存数量低,无法满足当前出库操作。";
                //}
            }

            //步骤三:同步更新库存数量 并产生应付 同步更新采购入库的已交货数量
            string paymentdays    = string.Empty;
            string mode           = string.Empty;
            string CGOrderNumbers = string.Empty;
            string error          = string.Empty;

            sql    = string.Format(@"select * from V_MaterialWarehouseLogDetail_Detail where 出入库编号='{0}' ", warehouseNumber);
            dtTemp = SqlHelper.GetTable(sql);
            foreach (DataRow dr in dtTemp.Rows)
            {
                if (type.Equals("采购入库"))          //产生应付
                {
                    sql = string.Format(@"update CertificateOrdersDetail set DeliveryQty +={0}
where OrdersNumber='{1}' and MaterialNumber='{2}' and LeadTime ='{3}' and Status ='未完成'
 ", dr["数量"], dr["订单编号"], dr["原材料编号"], dr["交期"]); //同步更新采购入库的已交货数量
                    sqls.Add(sql);
                    CGOrderNumbers += string.Format("'{0}',", dr["订单编号"]);
                }
                //同步更新库存数量
                //sqls.Add(GetUpdateInventoryQtySql(dr["原材料编号"].ToString(), dr["仓库ID"].ToString(), dr["数量"].ToString(), dr["方向"].ToString()));
            }
            string timeNow = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

            //类型为采购入库=======生成预付第二层信息
            sql = string.Format(@"insert into T_AccountsPayable_Detail(ReceiptNo,PurchaseOrderNumber ,PurchaseContractNumber,MaterialNumber ,SupplierMaterialNumber
,Description,PurchaseCount,NumberOfArrival,UnitPrice ,SumPrice ,TransportNo,LeadTime,CreateTime )
select vmld.WarehouseNumber ,vmld.DocumentNumber ,co.HTNumber,co.MaterialNumber,co.SupplierMaterialNumber,mit.Description ,co.OrderQty
,vmld.Qty,co.UnitPrice ,co.UnitPrice *vmld.Qty ,vmld.RoadTransport,vmld.LeadTime,'{1}'  from (  select mwl.Type,mwld.* from MarerialWarehouseLog mwl inner join MaterialWarehouseLogDetail mwld on mwl.WarehouseNumber =mwld.WarehouseNumber
) vmld inner join ( select co.HTNumber ,co.PaymentMode ,cod.* from CertificateOrders co inner join CertificateOrdersDetail cod on co.OrdersNumber=cod.OrdersNumber
) co on vmld.DocumentNumber =
co.OrdersNumber and vmld.MaterialNumber =co.MaterialNumber and vmld.LeadTime =co.LeadTime
inner join MarerialInfoTable mit on vmld .MaterialNumber =mit.MaterialNumber
 where vmld.WarehouseNumber ='{0}' and vmld.Type ='采购入库' ", warehouseNumber, timeNow);
            sqls.Add(sql);
            //类型为采购入库的生成应付第一层
            sql = string.Format(@"insert into T_AccountsPayable_Main(OrdersNumber,CreateTime ,CGHTNumber ,ArrivalNumber,SumPrice ,ArrivalPrice
,SupplierId,PaymentTypes,PaymentMode,DeliveryDate)
select a.OrdersNumber ,'{0}',co.HTNumber ,a.到货数量,a.订单总价,a.到货总价,si.SupplierId ,si.PayType,si.PaymentMode,CONVERT(varchar(100), GETDATE(), 23) from (
select co.OrdersNumber,SUM(vmld.Qty ) as 到货数量,SUM (vmld .Qty *co.UnitPrice ) as 到货总价,SUM( co.SumPrice) as 订单总价   from (  select mwl.Type,mwld.* from MarerialWarehouseLog mwl inner join MaterialWarehouseLogDetail mwld on mwl.WarehouseNumber =mwld.WarehouseNumber
) vmld inner join ( select co.HTNumber ,co.PaymentMode,co.SupplierId  ,cod.* from CertificateOrders co inner join CertificateOrdersDetail cod on co.OrdersNumber=cod.OrdersNumber
) co on vmld.DocumentNumber =
co.OrdersNumber and vmld.MaterialNumber =co.MaterialNumber and vmld.LeadTime =co.LeadTime
inner join MarerialInfoTable mit on vmld .MaterialNumber =mit.MaterialNumber
inner join SupplierInfo si on co.SupplierId=si.SupplierId
 where vmld.WarehouseNumber ='{1}' and vmld.Type ='采购入库' and co.PaymentMode!='YFBF' and co.PaymentMode!='YFQK'
 group by co.OrdersNumber) a  inner join CertificateOrders co on a.OrdersNumber =co.OrdersNumber
 inner join SupplierInfo si on co.SupplierId =si.SupplierId ", timeNow, warehouseNumber);
            sqls.Add(sql);

            //统一更新库存数量
            //            sql = string.Format(@"update MaterialStock set StockQty =
            //case when mwl.ChangeDirection='入库' then StockQty +a.Qty else StockQty-a.Qty end
            //,UpdateTime =CONVERT (varchar(100),GETDATE(),120) from
            //( select mwld.MaterialNumber,sum(mwld.Qty) as Qty from  MaterialWarehouseLogDetail mwld
            //  inner join MarerialWarehouseLog mwl on
            // mwld.WarehouseNumber =mwl.WarehouseNumber
            // where mwl.WarehouseNumber='{0}'
            // group by mwld.MaterialNumber) a
            // inner join MaterialStock ms on ms.MaterialNumber=a.MaterialNumber
            // where  ms.WarehouseName ='ycl'
            // ", warehouseNumber);
            sql = string.Format(@"update MaterialStock set StockQty =
case when a.ChangeDirection='入库' then StockQty +a.Qty else StockQty-a.Qty end
,UpdateTime =CONVERT (varchar(100),GETDATE(),120) from
( select mwld.MaterialNumber,mwl.ChangeDirection,sum(mwld.Qty) as Qty from  MaterialWarehouseLogDetail mwld
  inner join MarerialWarehouseLog mwl on
 mwld.WarehouseNumber =mwl.WarehouseNumber
 where mwl.WarehouseNumber='{0}'
 group by mwld.MaterialNumber,mwl.ChangeDirection) a
 inner join MaterialStock ms on ms.MaterialNumber=a.MaterialNumber
 where  ms.WarehouseName ='ycl'
 ", warehouseNumber);
            sqls.Add(sql);

            //如果是采购退料出库则反写出库单号至采购订单上
            if (type.Equals("采购退料出库"))
            {
                string tempSql = string.Format(@"
update  CertificateOrders set CCTCOrdersNumber='{0}'
where OrdersNumber in (
select distinct DocumentNumber from MaterialWarehouseLogDetail
where WarehouseNumber='{0}'
)", warehouseNumber);
                sqls.Add(tempSql);
                //warehouseNumber
            }

            //步骤四:同步更新采购入库订单明细的已交货、未交货、状态以及整条订单状态
            sql = string.Format("update CertificateOrdersDetail set NonDeliveryQty =OrderQty-DeliveryQty");
            sqls.Add(sql);
            sql = string.Format("update CertificateOrdersDetail  set Status ='已完成'  where NonDeliveryQty=0");
            sqls.Add(sql);
            if (!string.IsNullOrEmpty(CGOrderNumbers))
            {
                sql = string.Format(@"update CertificateOrders set OrderStatus ='已完成'
where OrdersNumber in (
 select OrdersNumber from CertificateOrdersDetail where OrdersNumber in({0})
 group by OrdersNumber having SUM(NonDeliveryQty )=0
)  and OrderStatus ='未完成'", CGOrderNumbers.TrimEnd(',')); //更新采购订单主表的状态
                sqls.Add(sql);
            }
            sql = string.Format(@" update MarerialWarehouseLog set Auditor='{0}' , CheckTime='{1}' where WarehouseNumber  ='{2}'", auditor, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), warehouseNumber);
            sqls.Add(sql);
            //更新瞬时库存数量
            sqls.Add(StoreroomToolManager.GetUpDateInventoryQtySql(warehouseNumber));
            //写入流水账
            sqls.Add(StoreroomToolManager.WriteMateriLSZ(warehouseNumber, auditor));

            sql = string.Format(" delete DeliveryNoteDetailed where DeliveryQty=0 ");//清除发货数量为0的送货单
            sqls.Add(sql);
            return(SqlHelper.BatchExecuteSql(sqls, ref error) ? "1" : error);
        }
Example #25
0
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            string warehouseNumber       = ToolManager.GetQueryString("WarehouseNumber");
            string planNumber            = string.Empty;
            string customerMaterilNumber = txtCustomerMaterilNumber.Text.Trim();
            string material = string.Empty;
            string qty      = txtQty.Text;
            string sql      = string.Empty;

            if (string.IsNullOrEmpty(customerMaterilNumber) || string.IsNullOrEmpty(qty) || string.IsNullOrEmpty(customerMaterilNumber))
            {
                lbSubmit.Text = "信息填写不完整";
                return;
            }
            if (drpType.SelectedValue == "供应商物料编号")
            {
                sql = string.Format(@"select top 1 MaterialNumber from MaterialSupplierProperty where SupplierMaterialNumber='{0}'", customerMaterilNumber);
                if (SqlHelper.GetScalar(sql).Equals(""))
                {
                    lbSubmit.Text = "未知的供应商物料编号!";
                    return;
                }
                else
                {
                    material = SqlHelper.GetScalar(sql);
                }
            }
            if (drpType.SelectedValue == "客户物料编号")
            {
                sql = string.Format(@"select top 1 MaterialNumber from MaterialCustomerProperty where CustomerMaterialNumber='{0}'", customerMaterilNumber);
                if (SqlHelper.GetScalar(sql).Equals(""))
                {
                    lbSubmit.Text = "未知的客户物料编号!";
                    return;
                }
                else
                {
                    material = SqlHelper.GetScalar(sql);
                }
            }
            if (drpType.SelectedValue == "瑞普迪编号")
            {
                sql = string.Format(@"select top 1 MaterialNumber from MarerialInfoTable where MaterialNumber='{0}'", customerMaterilNumber);
                if (SqlHelper.GetScalar(sql).Equals(""))
                {
                    lbSubmit.Text = "未知的瑞普迪编号!";
                    return;
                }
                else
                {
                    material = SqlHelper.GetScalar(sql);
                }
            }
            if (drpType.SelectedValue == "物料描述")
            {
                sql = string.Format(@"select top 1 MaterialNumber from MarerialInfoTable where Description='{0}'", customerMaterilNumber);
                if (SqlHelper.GetScalar(sql).Equals(""))
                {
                    lbSubmit.Text = "未知的物料描述!";
                    return;
                }
                else
                {
                    material = SqlHelper.GetScalar(sql);
                }
            }
            string remark = txtRemark.Text;
            string error  = string.Empty;
            bool   result = StoreroomToolManager.AddFLCKDetail(warehouseNumber, planNumber, customerMaterilNumber, material, qty, remark, ref error);

            if (result)
            {
                Response.Write(ToolManager.GetClosePageJS());
                Response.End();
                return;
            }
            else
            {
                lbSubmit.Text = "添加失败!原因:" + error;
            }
        }