예제 #1
0
        /// <summary>
        /// 处理超期条码
        /// </summary>
        /// <param name="dtHandle"></param>
        private void BarCodeExpiryDateHandle(DataTable dtHandle)
        {
            Dictionary <string, string> dicBarCode = new Dictionary <string, string>();//KEY-BarCode Value- flag 0-正常 1-超期 2-预警

            if (dtHandle.Rows.Count > 0)
            {
                foreach (DataRow dr in dtHandle.Rows)
                {
                    if (dicBarCode.ContainsKey(dr["SerialNumber"].ToString()))
                    {
                        continue;
                    }
                    if (dr["flag"].ToString() == "0")
                    {
                        dicBarCode.Add(dr["SerialNumber"].ToString(), "0");
                    }
                    else if (dr["flag"].ToString() == "1")
                    {
                        dicBarCode.Add(dr["SerialNumber"].ToString(), "1");
                    }
                    else if (dr["flag"].ToString() == "2")
                    {
                        dicBarCode.Add(dr["SerialNumber"].ToString(), "2");
                    }
                }
                BLL_Bllb_StockInfo_tbsi.UpdateBarCodeLockStatus(dicBarCode);
            }
        }
예제 #2
0
 private void btn_ok_Click(object sender, EventArgs e)
 {
     if (cboStatus.Text.Trim() == string.Empty)
     {
         MsgBox.Error("请先选择状态!");
         return;
     }
     //查询需要送检的条码
     dtBarCode = BLL_Bllb_StockInfo_tbsi.QuerySendToErCheckBarCode(cboStatus.Text.Trim());
     if (dtBarCode.Rows.Count == 0)
     {
         MsgBox.Error("该状态下无条码!");
         return;
     }
     try
     {
         string strwhere_materialcode = string.Empty;
         if (cboStatus.Text.Trim() == "预警")
         {
             strwhere_materialcode += string.Format("and dateDiff(month,a.Finally_Time,getDate()) between -7 and 0  and (a.Lock_Flag='0' or a.Lock_Flag is null  or a.Lock_Flag='')");
         }
         else if (cboStatus.Text.Trim() == "超期")
         {
             strwhere_materialcode += string.Format("and a.Finally_Time <= getDate() and a.Lock_Flag = '2'");
         }
         BLL_Bllb_StockInfo_tbsi.SendToErCheckBarCode(dtBarCode, strwhere_materialcode, cboStatus.Text.Trim());
     }
     catch (Exception ex)
     {
         MsgBox.Error(ex.Message.ToString());
         return;
     }
     this.DialogResult = DialogResult.OK;
     this.Close();
 }
예제 #3
0
        /// <summary>
        /// 查询
        /// </summary>
        private void Query()
        {
            string strwhere = string.Empty;

            ///无条件处理超期条码
            BarCodeExpiryDateHandle(BLL_Bllb_StockInfo_tbsi.QueryExpiryDate(strwhere));
            if (!string.IsNullOrEmpty(txtMaterialCode.Text.Trim()))
            {
                strwhere += string.Format(" and a.MaterialCode='{0}'", txtMaterialCode.Text.Trim());
            }
            dtExpriyDate          = BLL_Bllb_StockInfo_tbsi.QueryShowData(strwhere);
            dgvBarCode.DataSource = dtExpriyDate;
        }