public int Add(T_MailAddress modelIn)
{
string cmdStr = "insert into T_MailAddress(MAILADDRESS) values(@MAILADDRESS)";
OleDbParameter parm = new OleDbParameter("MAILADDRESS", modelIn.MAILADDRESS);
SQLHelpler.ExecuteNonQuery(cmdStr, parm);
return((int)SQLHelpler.ExecuteSclary("select max(ID) from T_MailAddress"));
}
public IList <T_MailAddress> GetAll()
{
string cmdStr = "select * from T_MailAddress";
List <T_MailAddress> models = new List <T_MailAddress>();
foreach (DataRow drTemp in SQLHelpler.ExecuteAdapter(cmdStr).Rows)
{
T_MailAddress modelTemp = new T_MailAddress();
modelTemp.ID = (int)drTemp["ID"];
modelTemp.MAILADDRESS = (string)drTemp["MAILADDRESS"];
models.Add(modelTemp);
}
return(models);
}
private void btnAddressAdd_Click(object sender, EventArgs e)
{
formAddInfo formInfo = new formAddInfo();
if (formInfo.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
modelAdd = new T_MailAddress()
{
MAILADDRESS = formInfo.mailAddress
};
modelAdd.ID = bllAdd.Add(modelAdd);
lstAddress.Items.Add(modelAdd);
lstAddress.SelectedItem = modelAdd;
}
}
public int Add(T_MailAddress modelIn)
{
return(new T_MailAddressDAL().Add(modelIn));
}
private void lstAddress_SelectedIndexChanged(object sender, EventArgs e)
{
modelAdd = (T_MailAddress)lstAddress.SelectedItem;
}
