private void BatchSendSM_Click(object sender, EventArgs e)
{
#region Batch short message sending
if (())
{
string groupidlist = (",");
if (groupidlist == "")
{
( "", "<script>alert('Please select the relevant user group first, and then click the Submit button');</script>");
return;
}
int percount = 10; //Every record is a waiting time
int count = 0; //The current number of records
// GetUserNameListByGroupid is to obtain the id and username of all users of the selected user group
foreach (DataRow dr in ().GetUserNameListByGroupid(groupidlist).Rows)
{
().SendPMToUser(("'", "''"), userid, dr["username"].ToString().Replace("'", "''"), Convert.ToInt32(dr["uid"].ToString()), (), , (), );
if (count >= percount)
{
(3500);
count = 0;
}
count++;
}
( "PAGE", "='global_sendSMtogroup.aspx';");
}
#endregion
}
//SendPMToUser function is as follows:
public void SendPMToUser(string msgfrom, int msgfromid, string msgto, int msgtoid, int folder, string subject, DateTime postdatetime, string message)
{
DbParameter[] parms =
{
("@msgfrom", (DbType),50, msgfrom),
("@msgfromid", (DbType), 4, msgfromid),
("@msgto", (DbType),50, msgto),
("@msgtoid", (DbType), 4, msgtoid),
("@folder", (DbType), 2, folder),
("@subject", (DbType),60, subject),
("@postdatetime", (DbType),8, postdatetime),
("@message",(DbType), 0,message)
};
string sql = "INSERT INTO [" + + "pms] (msgfrom,msgfromid,msgto,msgtoid,folder,new,subject,postdatetime,message) " +
"VALUES (@msgfrom,@msgfromid,@msgto,@msgtoid,@folder,1,@subject,@postdatetime,@message)";
(, sql, parms);
sql = "UPDATE [" + + "users] SET [newpmcount]=[newpmcount]+1 WHERE [uid] =@msgtoid";
(, sql, parms);
}