/// <summary> /// 팔레트 생성 /// </summary> public bool InsertPallet(PalletVO item, string userid) { using (SqlCommand comm = new SqlCommand()) { comm.Connection = new SqlConnection(Connstr); comm.CommandText = @"InsertPallet"; comm.CommandType = CommandType.StoredProcedure; comm.Parameters.AddWithValue("@Pallet_No", item.Pallet_No); comm.Parameters.AddWithValue("@Workorderno", item.WorkOrderNo); comm.Parameters.AddWithValue("@Barcode_No", item.Barcode_No); comm.Parameters.AddWithValue("@Grade_Detail_Code", item.Grade_Detail_Code); comm.Parameters.AddWithValue("@Grade_Code", item.Boxing_Grade_Code); comm.Parameters.AddWithValue("@Size_Code", item.Size_Code); comm.Parameters.AddWithValue("@In_Qty", item.In_Qty); comm.Parameters.AddWithValue("@CurrentQty", item.CurrentQty); comm.Parameters.AddWithValue("@userid", userid); comm.Connection.Open(); int result = comm.ExecuteNonQuery(); comm.Connection.Close(); return(result > 1); } }
/// <summary> /// 바코드 번호로 팔레트 검색 /// </summary> /// <param name="barcodeNo"></param> /// <returns></returns> public PalletVO GetPalletByBarcode(string barcodeNo) { PalletVO item = null; string barcode = barcodeNo.Substring(0, 15); string seq = barcodeNo.Substring(15); using (SqlCommand comm = new SqlCommand()) { comm.Connection = new SqlConnection(Connstr); comm.CommandText = @" SELECT TOP(1) pal.[Pallet_No] ,pal.[WorkOrderNo] ,pal.[Barcode_No] ,pal.[Grade_Detail_Code] ,bdm.[Grade_Detail_Name] ,bdm.[Boxing_Grade_Code] ,pal.[Size_Code] ,pal.[In_Qty] ,pal.[CurrentQty] ,pal.[Use_YN] ,wo.[Item_Code] ,im.[Item_Name] FROM [Pallet_Master] as pal LEFT OUTER JOIN [WorkOrder] as wo ON pal.[WorkorderNo] = wo.[Workorderno] LEFT OUTER JOIN [Item_Master] as im ON im.[Item_Code] = wo.[Item_Code] LEFT OUTER JOIN [BoxingGrade_Detail_Master] as bdm ON bdm.[Use_YN] = 'Y' AND pal.Grade_Detail_Code = bdm.Boxing_Grade_Code WHERE pal.[Use_YN] = 'Y' AND pal.[Barcode_No] = @barcodeNo ; "; comm.CommandType = CommandType.Text; comm.Parameters.AddWithValue("@barcodeNo", barcodeNo); comm.Connection.Open(); SqlDataReader reader = comm.ExecuteReader(); if (reader.Read()) { item = new PalletVO() { Pallet_No = reader[0].ToString(), WorkOrderNo = reader[1].ToString(), Barcode_No = reader[2].ToString(), Grade_Detail_Code = reader[3].ToString(), Grade_Detail_Name = reader[4].ToString(), Boxing_Grade_Code = reader[5].ToString(), Size_Code = reader[6].ToString(), In_Qty = Convert.ToInt32(reader[7]), CurrentQty = Convert.ToInt32(reader[8]), Use_YN = reader[9].ToString(), Item_Code = reader[10].ToString(), Item_Name = reader[11].ToString() }; } comm.Connection.Close(); return(item); } }
/// <summary> /// 팔레트 생성 /// </summary> public bool InsertPallet(PalletVO item, string userid) { Pallet_MasterDAC dac = new Pallet_MasterDAC(); return(dac.InsertPallet(item, userid)); }