/// <summary> /// 更新标签状态 /// </summary> private void UpdateBarcode2(string strBarcode) { string strSql = "update Mes_Barcode set B_Status = '1' where B_Barcode = '" + strBarcode + "'"; Mes_BarcodeBLL BarcodeBLL = new Mes_BarcodeBLL(); BarcodeBLL.Update(strSql); }
/// <summary> /// 删除原卡信息 /// </summary> /// <param name="strGoodsCode"></param> /// <returns></returns> private void DeleteData(string strBarcode) { Mes_BarcodeBLL BarcodeBLL = new Mes_BarcodeBLL(); //string strSql = "Update Mes_Barcode set B_Remark = '已经分写' where B_Barcode = '"+ strBarcode +"'"; string strSql = "delete from Mes_Barcode where B_Barcode = '" + strBarcode + "'"; BarcodeBLL.Update(strSql); }
/// <summary> /// 保存标签条码 /// </summary> /// <param name="B_Barcode"></param> /// <param name="B_Code"></param> /// <param name="B_Name"></param> /// <param name="B_Qty"></param> /// <param name="B_WorkShopCode"></param> private void SaveBarcode(string B_Barcode, string B_Code, string B_Name, decimal B_Qty, string B_WorkShopCode) { Mes_BarcodeEntity BarcodeEntity = new Mes_BarcodeEntity(); Mes_BarcodeBLL BarcodeBLL = new Mes_BarcodeBLL(); BarcodeEntity.B_Barcode = B_Barcode; BarcodeEntity.B_Code = B_Code; BarcodeEntity.B_Name = B_Name; BarcodeEntity.B_Qty = B_Qty; BarcodeEntity.B_WorkShopCode = B_WorkShopCode; BarcodeEntity.B_Ptime = DateTime.Now; BarcodeEntity.B_Status = 1; BarcodeBLL.SaveEntity("", BarcodeEntity); }
private void Search() { string strSql = "select * from Mes_Barcode where B_WorkShopCode = '" + txtCode.Text + "' and B_Status = '1' order by B_Code"; Mes_BarcodeBLL BarcodeBLL = new Mes_BarcodeBLL(); var row = BarcodeBLL.GetList_Mes_Barcode(strSql); int nLen = row.Count; this.listView1.Items.Clear(); this.listView1.BeginUpdate(); for (int i = 0; i < nLen; i++) { ListViewItem lvi = new ListViewItem(row[i].B_Code); lvi.SubItems.Add(row[i].B_Name); lvi.SubItems.Add(row[i].B_Qty.ToString()); this.listView1.Items.Add(lvi); } this.listView1.EndUpdate(); }
/// <summary> /// 删除ESL标签条码 /// </summary> /// <param name="strId"></param> /// <returns></returns> private bool DeleteBarcode(string strBarcode) { try { string strSql = "delete from Mes_Barcode where B_Barcode = '" + strBarcode + "'"; Mes_BarcodeBLL BarcodeBLL = new Mes_BarcodeBLL(); int nRow = BarcodeBLL.Update(strSql); if (nRow > 0) { return(true); } else { return(false); } } catch (Exception ex) { return(false); } }
/// <summary> /// 保存标签条码 /// </summary> /// <param name="B_Barcode"></param> /// <param name="B_Code"></param> /// <param name="B_Name"></param> /// <param name="B_Qty"></param> /// <param name="B_WorkShopCode"></param> private void SaveBarcode(string B_Barcode, string B_Code, string B_Name, decimal B_Qty, string B_WorkShopCode) { Mes_BarcodeEntity BarcodeEntity = new Mes_BarcodeEntity(); Mes_BarcodeBLL BarcodeBLL = new Mes_BarcodeBLL(); BarcodeEntity.B_Barcode = B_Barcode; BarcodeEntity.B_Code = B_Code; BarcodeEntity.B_Name = B_Name; BarcodeEntity.B_Qty = B_Qty; BarcodeEntity.B_WorkShopCode = B_WorkShopCode; DateTime dt = DateTime.Now; BarcodeEntity.B_Ptime = dt; BarcodeEntity.B_Itime = dt; BarcodeEntity.B_Otime = dt; BarcodeEntity.B_Utime = dt; BarcodeEntity.B_Remark = "由" + txtQty.Text + "分写而来"; BarcodeEntity.B_Status = 1; BarcodeBLL.SaveEntity("", BarcodeEntity); }
private void txtBarcode_KeyDown(object sender, KeyEventArgs e) { try { if (e.KeyValue == 13) { string strBarcode = txtBarcode.Text; if (strBarcode.IndexOf('*') > 0) { string[] strTemp = strBarcode.Split('*'); txtCode.Text = strTemp[0].ToString(); txtPc.Text = strTemp[1].ToString(); txtQty.Text = strTemp[2].ToString(); MesGoodsBLL GoodsBLL = new MesGoodsBLL(); var Goods_rows = GoodsBLL.GetListCondit("where G_Code = '" + txtCode.Text + "'"); int nLen = Goods_rows.Count; if (nLen > 0) { txtName.Text = Goods_rows[0].G_Name; txtPrice.Text = Goods_rows[0].G_Price.ToString(); strUnit = Goods_rows[0].G_Unit.ToString(); } } else { string[] strTemp = strBarcode.Split(','); //MessageBox.Show(strTemp.Length.ToString()); txtCode.Text = Resolve(strTemp[0].ToString()); txtPc.Text = Resolve(strTemp[1].ToString()); txtQty.Text = Resolve(strTemp[2].ToString()); m_strBarcode = strTemp[4].ToString(); Mes_BarcodeBLL BarcodeBLL = new Mes_BarcodeBLL(); var Barcode_rows = BarcodeBLL.GetList_Mes_Barcode("select * from Mes_Barcode where B_Status = 1 and B_Barcode = '" + m_strBarcode + "'"); if (Barcode_rows.Count > 0) { } else { MessageBox.Show("此标签已经入库, 或者状态不对"); txtBarcode.Text = ""; txtBarcode.Focus(); txtBarcode.SelectAll(); return; } MesGoodsBLL GoodsBLL = new MesGoodsBLL(); var Goods_rows = GoodsBLL.GetListCondit("where G_Code = '" + txtCode.Text + "'"); int nLen = Goods_rows.Count; if (nLen > 0) { txtName.Text = Goods_rows[0].G_Name; strUnit = Goods_rows[0].G_Unit; txtPrice.Text = Goods_rows[0].G_Price.ToString(); } } Save(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }