// サブプロシージャ：新規バッチの発行
private string getNewBatch()
{
string subAssyNo = cmbSubAssyNo.Text;
string sql;
TfSQL tf = new TfSQL();
sql = "select batch_prefix from t_model_sub_assy where sub_assy_no = '" + subAssyNo + "'";
string batchPrefix = tf.sqlExecuteScalarString(sql);
sql = "select max(batch_no) from t_batch_no where batch_no like '" + batchPrefix + "%'";
string batchOld = tf.sqlExecuteScalarString(sql);
DateTime dateOld = new DateTime(0);
long numberOld = 0;
string batchNew;
if (batchOld != string.Empty)
{
dateOld = DateTime.ParseExact(VBStrings.Mid(batchOld, 10, 6), "yyMMdd", CultureInfo.InvariantCulture);
numberOld = long.Parse(VBStrings.Right(batchOld, 4));
}
if (dateOld != DateTime.Today)
{
batchNew = batchPrefix + "#" + DateTime.Today.ToString("yyMMdd") + "#" + "0001";
}
else
{
batchNew = batchPrefix + "#" + DateTime.Today.ToString("yyMMdd") + "#" + (numberOld + 1).ToString("0000");
}
return(batchNew);
}
