public String loingeneration()
{
String loin = "";
DateTime tgl = dateTimePicker2.Value;
int julian = tgl.DayOfYear;
String juliancode = julian.ToString();
if (juliancode.Length == 1)
{
juliancode = "00" + juliancode;
}
else if (juliancode.Length == 2)
{
juliancode = "0" + juliancode;
}
String curryear = tgl.ToString("yy");
String pdc = curryear + juliancode;
MainMenu frm = new MainMenu();
List <object[]> data = new List <object[]>();
//get intlotcode the first row
//data = frm.get_data_table_string("increment_loin", "pdc", pdc);
data = frm.get_max_sequence_loin(pdc);
Int32 urutan = 0;
String urutanstr = "";
String maxstring = "";
if (data.Count > 0)
{
maxstring = data[0][0].ToString();
if (!maxstring.Equals(""))
{
string rightnumber = maxstring.Substring(maxstring.Length - 5, 5);
urutan = Int32.Parse(rightnumber) + 1;
}
else
{
urutan = 1;
}
//urutan = Int32.Parse(data[0][1].ToString());
if (urutan.ToString().Length == 1)
{
urutanstr = "0000" + urutan.ToString();
}
else if (urutan.ToString().Length == 2)
{
urutanstr = "000" + urutan.ToString();
}
else if (urutan.ToString().Length == 3)
{
urutanstr = "00" + urutan.ToString();
}
else if (urutan.ToString().Length == 4)
{
urutanstr = "0" + urutan.ToString();
}
else if (urutan.ToString().Length == 5)
{
urutanstr = urutan.ToString();
}
}
else
{
urutan = 1;
urutanstr = "0000" + urutan.ToString();
}
//set next number for loin number
set_nextnumber_loin(pdc, urutan + 1);
String compcode = "";
data = frm.get_data_table_string("tbcompany", "", "");
if (data.Count > 0)
{
compcode = data[0][13].ToString();
}
loin = compcode + "." + curryear + juliancode + "." + urutanstr;
return(loin);
}
