private void GetIDDatMon()
{
int time = Convert.ToInt32(DateTime.Now.Year.ToString().Substring(2) + String.Format("{0:00}", DateTime.Now.Month));
string sql = "SELECT MAX(IDDatMon) FROM DatMon WHERE LEFT(IDDatMon, 4) = " + time + "";
object maxValue = new ExecuteBLL().ExecuteScalar(sql);
iD = (!maxValue.ToString().Equals("")) ? (int)maxValue + 1 : Convert.ToInt32(time.ToString() + String.Format("{0:0000}", 1));
txtID.Text = iD.ToString();
}
private void btnThem_Click(object sender, EventArgs e)
{
HinhAnh ha = GetInfo();
if (ha == null)
{
return;
}
try
{
object value = new ExecuteBLL().ExecuteScalar("SELECT MAX(IDHinhAnh) FROM HinhAnh");
ha.iD = (!value.ToString().Equals("")) ? Convert.ToInt32(value) + 1 : 1;
new HinhAnhBLL().Add(ha);
RefreshInfo();
LoadPanel();
}
catch (Exception ex)
{
MessageBox.Show("Lỗi: " + ex.Message, "Chú ý!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
