public int UpdateClientReceivedResult(Dictionary<string, string> dict)

        {

            var dynamicSqlParam = new DynamicParameters();

            var sbSet = new StringBuilder();

            sbSet.Append(" (CASE SmsFlowID ");

            int idx = ;

            foreach (var kv in dict)

            {

                sbSet.Append(string.Format(" WHEN @SmsFlowID{0} THEN @ClientReceivedResult{0} ", idx));

                dynamicSqlParam.Add(string.Format("SmsFlowID{0}", idx), kv.Key, null, null, null);

                dynamicSqlParam.Add(string.Format("ClientReceivedResult{0}", idx), kv.Value, null, null, null);

                idx += ;

            }

            sbSet.Append(" ELSE ClientReceivedResult END) ");

            var sbWhere = new StringBuilder();

            sbWhere.Append(" AND SmsFlowID in @ids ");

            dynamicSqlParam.Add("ids", dict.Keys.ToArray(), null, null, null);

            string sql = string.Format("UPDATE [SmsSendResult] SET  [ClientReceivedResult]={0} WHERE 1=1 {1}", sbSet,

                sbWhere);

            int affectNum = -;

            using (var conn = new SqlConnection(SmsDBConnString))

            {

                affectNum = conn.Execute(sql, dynamicSqlParam);

            }

            return affectNum;

        }

UPDATE [SmsSendResult] SET  [ClientReceivedResult]= (CASE SmsFlowID  WHEN @SmsFlowID0 THEN @ClientReceivedResult0  WHEN @SmsFlowID1 THEN @ClientReceivedResult1  WHEN @SmsFlowID2 THEN @ClientReceivedResult2  WHEN @SmsFlowID3 THEN @ClientReceivedResult3  WHEN @SmsFlowID4 THEN @ClientReceivedResult4  WHEN @SmsFlowID5 THEN @ClientReceivedResult5  WHEN @SmsFlowID6 THEN @ClientReceivedResult6  WHEN @SmsFlowID7 THEN @ClientReceivedResult7  ELSE ClientReceivedResult END)  WHERE 1=1  AND SmsFlowID in @SmsFlowID

var sbWhere = new StringBuilder();

sbWhere.Append(" AND SmsFlowID in @SmsFlowID ");

dynamicSqlParam.Add("SmsFlowID", dict.Keys.ToArray(), null, null, null);