UC知道我是新手，麻烦大家帮帮忙
来源：百度知道 编辑：UC知道 时间：2024/05/06 20:18:49
public static void SaveMessageOut(string strSendPer, string strPerson, string strText, string strType, string strDateTime)
{
if (strDateTime == " ")
{
strDateTime = DateTime.Now.ToString();
}
SqlCommand cmdMessage = new SqlCommand();
SqlConnection frmConn = new SqlConnection(ConnectionString);
try
{
frmConn.Open();
cmdMessage.Connection = frmConn;
SqlTransaction objTransaction = frmConn.BeginTransaction();
try
{
foreach (string s in strPerson.Split(new char[] { ',' }))
{
if (s.Trim() != "")
{
string strSql = "insert SMS_TOSEND (person,SENDTIME,PHONE,MSGTEXT,SENDFLAG,MSGTYPE) values('" + strSendPer + "','" + strDateTime + "','" + s + "','" + strText
{
if (strDateTime == " ")
{
strDateTime = DateTime.Now.ToString();
}
SqlCommand cmdMessage = new SqlCommand();
SqlConnection frmConn = new SqlConnection(ConnectionString);
try
{
frmConn.Open();
cmdMessage.Connection = frmConn;
SqlTransaction objTransaction = frmConn.BeginTransaction();
try
{
foreach (string s in strPerson.Split(new char[] { ',' }))
{
if (s.Trim() != "")
{
string strSql = "insert SMS_TOSEND (person,SENDTIME,PHONE,MSGTEXT,SENDFLAG,MSGTYPE) values('" + strSendPer + "','" + strDateTime + "','" + s + "','" + strText
SqlTransaction objTransaction = frmConn.BeginTransaction();
开始事务，调用事务~
事务就是可以方便中途意外或者撤销、执行等等操作时不会丢失数据~
cmdMessage.CommandText = strSql;
赋SQL语句，和cmdMessage.ExecuteNonQuery()一起执行数据库操作;
objTransaction.Commit();
objTransaction.Rollback();
事务执行和不成功时的回滚~
Normal.WriteLog("CancomOA.DataAccess.Message, SaveMessageOut(string strSendPer,string strPerson,string strText,string strType,string strDateTime) ", ex.Message);
事务日志，基本不用管~
if (frmConn.State != ConnectionState.Closed)
检查连接是否关闭
frmConn.Dispose();
关闭SQL命令