|
<div class="codetitle"><a style="CURSOR: pointer" data="85270" class="copybut" id="copybut85270" onclick="doCopy('code85270')"> 代码如下:<div class="codebody" id="code85270">
public bool SaveSMSMessage(SMSBatch smsBatch,DataSet smsMessages)
{
//using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Suppress))
//{
foreach (DataRow row in smsMessages.Tables[0].Rows)
row.SetModified();
SqlDatabase db = new SqlDatabase(this.ConsultantsConnString);
string sqlCmd = "EXEC cn.SMSSaveSMSMessage @SMSBatchID,@SMSTypeID,@SubsidiaryID,@ContactID,@Message,@PhoneNumber";
using (SqlCommand cmd = db.GetSqlStringCommand(sqlCmd) as SqlCommand)
{
cmd.CommandTimeout = 600;
cmd.Parameters.AddWithValue("@SMSBatchID",smsBatch.SMSBatchID);
cmd.Parameters.AddWithValue("@SMSTypeID",smsBatch.SMSType.SMSTypeID);
cmd.Parameters.AddWithValue("@SubsidiaryID",smsBatch.SMSType.SubsidiaryID);
db.AddInParameter(cmd,"@ContactID",DbType.Int64,"ContactID",DataRowVersion.Current);
db.AddInParameter(cmd,"@Message",DbType.String,"Message",DataRowVersion.Current);
if (smsMessages.Tables[0].Columns.Contains("PhoneNumber"))
{
db.AddInParameter(cmd,"@PhoneNumber","PhoneNumber",DataRowVersion.Current);
}
else
{
db.AddInParameter(cmd,DBNull.Value);
}
int rowsEffected = db.UpdateDataSet(smsMessages,"SMSMessage",null,cmd,UpdateBehavior.Transactional);
sqlCmd = rowsEffected.ToString();
}
// ts.Complete();
//}
return true;
}
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
