private void txtPalletNo_searchclick(object sender, EventArgs e)
{
Pallet_MasterService service = new Pallet_MasterService();
PalletTodayInVO item = service.GetPalletInfo(txtPalletNo.TextBoxText);
txtPalletNo.TextBoxText = item.Pallet_No;
txtSize.TextBoxText = item.Size_Code;
txtBoxingGradeDatail.TextBoxText = item.Wc_Code;
txtBoxingGrade.TextBoxText = item.Boxing_Grade_Code;
}
/// <summary>
/// 팔레트 정보 가져오기
/// </summary>
/// <param name="palletno"></param>
/// <returns></returns>
public PalletTodayInVO GetPalletInfo(string palletno)
{
PalletTodayInVO item = new PalletTodayInVO();
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = new SqlConnection(Connstr);
comm.CommandText =
@" SELECT gih.[Workorderno]
,wo.[Plan_Date]
,gih.[Pallet_No]
,pal.[Barcode_No]
,pal.[Grade_Detail_Code]
,bdm.[Grade_Detail_Name]
,bdm.[Boxing_Grade_Code]
,pal.[In_Qty]
,pal.[CurrentQty]
,pal.Size_Code
,gih.[In_Date]
,gih.[In_YN]
,wo.[Item_Code]
,wo.[Wc_Code]
FROM [WorkOrder] as wo
RIGHT OUTER JOIN [Goods_In_History] as gih ON gih.[Workorderno] = wo.[Workorderno]
LEFT OUTER JOIN [Pallet_Master] as pal ON pal.[Pallet_No] = gih.[Pallet_No] AND pal.Workorderno = gih.Workorderno AND pal.[Use_YN] = 'Y'
LEFT OUTER JOIN [BoxingGrade_Detail_Master] as bdm ON bdm.[Grade_Detail_Code] = pal.[Grade_Detail_Code] AND bdm.[Use_YN] = 'Y'
WHERE gih.[Pallet_No] =@palletNo ; ";
comm.CommandType = CommandType.Text;
comm.Parameters.AddWithValue("@palletNo", palletno);
comm.Connection.Open();
SqlDataReader reader = comm.ExecuteReader();
if (reader.Read())
{
item.Workorderno = reader[0].ToString();
item.Plan_Date = Convert.ToDateTime(reader[1].ToString());
item.Pallet_No = reader[2].ToString();
item.Barcode_No = reader[3].ToString();
item.Grade_Detail_Code = reader[4].ToString();
item.Grade_Detail_Name = reader[5].ToString();
item.Boxing_Grade_Code = reader[6].ToString();
item.In_Qty = Convert.ToInt32(reader[7].ToString());
item.CurrentQty = Convert.ToInt32(reader[8].ToString());
item.Size_Code = reader[9].ToString();
item.In_YN = reader[11].ToString();
item.Item_Code = reader[12].ToString();
item.Wc_Code = reader[13].ToString();
}
comm.Connection.Close();
return(item);
}
}
