private void frmStorageAdd_Load(object sender, EventArgs e)
{
comStock.Items.Clear();
comProductNo.Items.Clear();
MesStockBLL StockBLL = new MesStockBLL();
var row = StockBLL.GetData(" where s_Kind = 1");
int nCount = row.Count;
for (int i = 0; i < nCount; i++)
{
comStock.Items.Add(row[i].S_Code.ToString() + "$" + row[i].S_Name.ToString());
}
MesProductOrderHeadBLL ProductOrderHeadBLL = new MesProductOrderHeadBLL();
var Product = ProductOrderHeadBLL.GetList("");
int nCount2 = Product.Count;
for (int j = 0; j < nCount2; j++)
{
comProductNo.Items.Add(Product[j].P_OrderNo.ToString() + "$" + Product[j].P_OrderDate.ToString());
}
string strCondit = " where S_EffectTime > '" + DateTime.Now + "'";
MesSupplyBLL SupplyBLL = new MesSupplyBLL();
var Supply = SupplyBLL.GetList(strCondit);
int nCount3 = Supply.Count;
for (int k = 0; k < nCount3; k++)
{
cmbSupply.Items.Add(Supply[k].S_Code + "$" + Supply[k].S_Name);
}
}
private void cmbStock_SelectedIndexChanged(object sender, EventArgs e)
{
MesStockBLL StockBLL = new MesStockBLL();
var row = StockBLL.GetData(" where S_Code = '" + cmbStock.Text + "'");
cmbStockName.Text = row[0].S_Name;
}
private void cmbStock_SelectedIndexChanged(object sender, EventArgs e)
{
MesStockBLL StockBLL = new MesStockBLL();
var row = StockBLL.GetData(" where S_Code = '" + cmbStock.Text + "'");
cmbStockName.Text = row[0].S_Name;
cmbGoodsCode.Items.Clear();
cmbGoodsName.Items.Clear();
MesInventoryBLL InventoryBLL = new MesInventoryBLL();
var row2 = InventoryBLL.GetData("where I_StockCode = '" + cmbStock.Text + "' and I_Qty > 0 ");
for (int i = 0; i < row2.Count; i++)
{
if (!cmbGoodsCode.Items.Contains(row2[i].I_GoodsCode))
{
cmbGoodsCode.Items.Add(row2[i].I_GoodsCode);
}
if (!cmbGoodsName.Items.Contains(row2[i].I_GoodsName))
{
cmbGoodsName.Items.Add(row2[i].I_GoodsName);
}
}
if (row2.Count == 1)
{
cmbGoodsCode.Text = row2[0].I_GoodsCode;
cmbGoodsName.Text = row2[0].I_GoodsName;
}
}
private void frmInventory_Load(object sender, EventArgs e)
{
MesStockBLL StockBLL = new MesStockBLL();
var Stock_rows = StockBLL.GetData(" where S_Kind = '4'");
for (int i = 0; i < Stock_rows.Count; i++)
{
cmbStock.Items.Add(Stock_rows[i].S_Code);
cmbStockName.Items.Add(Stock_rows[i].S_Name);
}
if (cmbStock.Items.Contains(Globels.strStockCode))
{
cmbStock.Text = Globels.strStockCode;
}
listView1.Items.Clear();
}
private void frmOutWorkShopList_Load(object sender, EventArgs e)
{
MesProductOrderHeadBLL ProductOrderHeadBLL = new MesProductOrderHeadBLL();
var row_ProductOrder = ProductOrderHeadBLL.GetListAll();
for (int i = 0; i < row_ProductOrder.Count; i++)
{
//cmb .Items.Add(row_ProductOrder[i].W_Code);
comOrderNo.Items.Add(row_ProductOrder[i].P_OrderNo);
}
MesWorkShopBLL WorkShopBLL = new MesWorkShopBLL();
var rows = WorkShopBLL.GetList();
for (int i = 0; i < rows.Count; i++)
{
cmbWorkShop.Items.Add(rows[i].W_Code);
cmbWorkshopName.Items.Add(rows[i].W_Name);
}
if (cmbWorkShop.Items.Contains(Globels.strWorkShop))
{
cmbWorkShop.Text = Globels.strWorkShop;
}
MesStockBLL StockBLL = new MesStockBLL();
var Stock_rows = StockBLL.GetData(" where S_Kind = '4'");
for (int i = 0; i < Stock_rows.Count; i++)
{
cmbStock.Items.Add(Stock_rows[i].S_Code);
cmbStockName.Items.Add(Stock_rows[i].S_Name);
}
if (cmbStock.Items.Contains(Globels.strStockCode))
{
cmbStock.Text = Globels.strStockCode;
}
MesRecordBLL RecordBLL = new MesRecordBLL();
var Record_rows = RecordBLL.GetList();
for (int i = 0; i < Record_rows.Count; i++)
{
cmbRecord.Items.Add(Record_rows[i].R_Record);
}
}
private void frmSearchConver_Load(object sender, EventArgs e)
{
txtStockCode.Text = Globels.strStockCode;
MesStockBLL StockBLL = new MesStockBLL();
var row = StockBLL.GetData(" where S_Code = '" + Globels.strStockCode + "'");
txtStockName.Text = row[0].S_Name;
//DateTime dt = DateTime.Now.Date.AddDays(-1);
//string strSql = "SELECT DISTINCT b.O_SecGoodsCode,b.O_SecGoodsName FROM Mes_OrgResHead AS a LEFT JOIN dbo.Mes_OrgResDetail AS b ON a.O_OrgResNo = b.O_OrgResNo WHERE a.O_StockCode = '" + Globels.strStockCode + "' AND a.O_UploadDate > '" + dt + "'";
//DataSet ds = new DataSet();
//Mes_ConvertBLL ConvertBLL = new Mes_ConvertBLL();
//ds = ConvertBLL.GetList(strSql);
//cmbGoodsName.Items.Clear();
//int nLen = ds.Tables[0].Rows.Count;
//for (int i = 0; i < nLen; i++)
//{
// cmbGoodsName.Items.Add(ds.Tables[0].Rows[i]["O_SecGoodsName"].ToString());
//}
}
private void frmInWorkShop_Load(object sender, EventArgs e)
{
MesProductOrderHeadBLL ProductOrderHeadBLL = new MesProductOrderHeadBLL();
var row_ProductOrder = ProductOrderHeadBLL.GetListAll();
for (int i = 0; i < row_ProductOrder.Count; i++)
{
//cmb .Items.Add(row_ProductOrder[i].W_Code);
comOrderNo.Items.Add(row_ProductOrder[i].P_OrderNo);
}
MesWorkShopBLL WorkShopBLL = new MesWorkShopBLL();
var rows = WorkShopBLL.GetList();
for (int i = 0; i < rows.Count; i++)
{
cmbWorkShop.Items.Add(rows[i].W_Code);
cmbWorkshopName.Items.Add(rows[i].W_Name);
}
if (cmbWorkShop.Items.Contains(Globels.strWorkShop))
{
cmbWorkShop.Text = Globels.strWorkShop;
//cmbStockName.Text =
}
MesStockBLL StockBLL = new MesStockBLL();
var Stock_rows = StockBLL.GetData(" where S_Kind = 4 order by S_Code asc");
for (int i = 0; i < Stock_rows.Count; i++)
{
cmbStock.Items.Add(Stock_rows[i].S_Code);
cmbStockName.Items.Add(Stock_rows[i].S_Name);
}
if (cmbStock.Items.Contains(Globels.strStockCode))
{
cmbStock.Text = Globels.strStockCode;
}
MesRecordBLL RecordBLL = new MesRecordBLL();
var Record_rows = RecordBLL.GetList();
for (int i = 0; i < Record_rows.Count; i++)
{
cmbRecord.Items.Add(Record_rows[i].R_Record);
}
//MesBasketBLL BasketBLL = new MesBasketBLL();
//var Basket_rows = BasketBLL.GetList();
//for (int i = 0; i < Basket_rows.Count; i++)
//{
// cmbBasket.Items.Add(Record_rows[i].R_Record);
//}
//MesInventoryBLL InventoryBLL = new MesInventoryBLL();
//var Goods_rows = InventoryBLL.GetList();
//for (int i = 0; i < Goods_rows.Count; i++)
//{
// cmbStock.Items.Add(Goods_rows[i].G_Code);
//}
}
