private void addbutton_Click(object sender, EventArgs e)
{
string[] date = DateTime.Now.ToString("MM-dd").Split('-');
string monthday = date[0] + date[1];
string sql = "select UserName,Telephone from UserInfo where substring(PersonID,11,4) =" + monthday;
dataGridView1.DataSource = BirthdayMes.ExcuteQuery(connstr, sql);
BirthdayMessage.insertMessage(connstr);
}
//调用接口
//参数为待使用数据库连接字符串，例如"Server=localhost;Database=TestDB;Trusted_Connection=SSPI"
public static bool insertMessage(string connectstring)
{
bool result = false;
string connstr = connectstring;
//取出当前系统时间
string[] date = DateTime.Now.ToString("MM-dd").Split('-');
string monthday = date[0] + date[1];
string sql = "select UserName,Telephone from UserInfo where substring(PersonID,11,4) =" + monthday;
//执行查询
DataTable table = BirthdayMes.ExcuteQuery(connstr, sql);
if (table == null)
{
result = false;
}
else if (writeMessage(connstr, table) == true)
{
result = true;
}
return(result);
}
private void showbutton_Click(object sender, EventArgs e)
{
string sql = "select * from UserMessage";
dataGridView1.DataSource = BirthdayMes.ExcuteQuery(connstr, sql);
}
