public static List<CC_SlabInfo> GetCC_SlabInfo(string SlabNo)
{
List<CC_SlabInfo> LST = new List<CC_SlabInfo>();
CC_SlabInfo lst = new CC_SlabInfo(); CC_SlabInfo_Ini(ref lst);
Object Obj = new object();
string str = "";
string strSQL = "SELECT * FROM SLAB_L2_REPORTS WHERE slab_no='" + SlabNo + "'";
DataTable dt = GetDataFromOledb(strSQL, lyqstr);
for (int RowIndex = 0; RowIndex < dt.Rows.Count; RowIndex++)
{
lst = new CC_SlabInfo(); CC_SlabInfo_Ini(ref lst);
lst.slab_no = dt.Rows[RowIndex]["slab_no"].ToString();
lst.HEAT_ID = dt.Rows[RowIndex]["HEAT_ID"].ToString();
lst.STEEL_GRADE = dt.Rows[RowIndex]["STEEL_GRADE"].ToString();
lst.CCM = dt.Rows[RowIndex]["CCM"].ToString();
lst.STRAND_NO = dt.Rows[RowIndex]["STRAND_NO"].ToString();
lst.PROD_NO = dt.Rows[RowIndex]["PROD_NO"].ToString();
lst.PROD_COUNTER = dt.Rows[RowIndex]["PROD_COUNTER"].ToString();
lst.TAPER_START = dt.Rows[RowIndex]["TAPER_START"].ToString();
lst.TAPER_END = dt.Rows[RowIndex]["TAPER_END"].ToString();
str = dt.Rows[RowIndex]["WIDTH"].ToString(); lst.WIDTH = str.Split(new char[] { '.' })[0];
str = dt.Rows[RowIndex]["WIDTH_HEAD"].ToString(); lst.WIDTH_HEAD = str.Split(new char[] { '.' })[0];
str = dt.Rows[RowIndex]["WIDTH_TAIL"].ToString(); lst.WIDTH_TAIL = str.Split(new char[] { '.' })[0];
str = dt.Rows[RowIndex]["THICKNESS"].ToString(); lst.THICKNESS = str.Split(new char[] { '.' })[0];
str = dt.Rows[RowIndex]["LENGTH"].ToString(); lst.LENGTH = str.Split(new char[] { '.' })[0];
str = dt.Rows[RowIndex]["WEIGHT"].ToString(); lst.WEIGHT = str.Split(new char[] { '.' })[0];
lst.START_TIME = dt.Rows[RowIndex]["START_TIME"].ToString();
lst.STOP_TIME = dt.Rows[RowIndex]["STOP_TIME"].ToString();
str = dt.Rows[RowIndex]["START_CAST_POS"].ToString(); lst.START_CAST_POS = str.Split(new char[] { '.' })[0];
str = dt.Rows[RowIndex]["STOP_CAST_POS"].ToString(); lst.STOP_CAST_POS = str.Split(new char[] { '.' })[0];
str = dt.Rows[RowIndex]["SAMPLE_WGT"].ToString(); lst.SAMPLE_WGT = str.Split(new char[] { '.' })[0];
str = dt.Rows[RowIndex]["DEFECT_LEVEL"].ToString(); lst.DEFECT_LEVEL = str.Split(new char[] { '.' })[0];
lst.MANUAL_REPORT_FLG = dt.Rows[RowIndex]["MANUAL_REPORT_FLG"].ToString();
lst.MANUAL_CUT_FLG = dt.Rows[RowIndex]["MANUAL_CUT_FLG"].ToString();
lst.CUT_DATE = dt.Rows[RowIndex]["CUT_DATE"].ToString();
lst.WEIGHT_REAL = dt.Rows[RowIndex]["WEIGHT_REAL"].ToString();
LST.Add(lst);
}
dt.Dispose();
return LST;
}
public static void CC_SlabInfo_Ini(ref CC_SlabInfo lst)
{
lst.slab_no = "-"; lst.HEAT_ID = "-"; lst.STEEL_GRADE = "-"; lst.CCM = "-";
lst.STRAND_NO = "-"; lst.PROD_COUNTER = "-"; lst.PROD_NO = "-"; lst.WIDTH = "-";
lst.WIDTH_HEAD = "-"; lst.WIDTH_TAIL = "-"; lst.THICKNESS = "-"; lst.TAPER_START = "-";
lst.TAPER_END = "-"; lst.LENGTH = "-"; lst.WEIGHT = "-"; lst.START_TIME = "-";
lst.STOP_TIME = "-"; lst.START_CAST_POS = "-"; lst.STOP_CAST_POS = "-"; lst.SAMPLE_WGT = "-";
lst.DEFECT_LEVEL = "-"; lst.MANUAL_REPORT_FLG = "-"; lst.MANUAL_CUT_FLG = "-"; lst.CUT_DATE = "-";
lst.WEIGHT_REAL = "-";
}