方法处理

          List<int> sysNoList = new List<int>();
                foreach (DataRow row in dt.Rows)
                    sysNoList.Add(Convert.ToInt32(row["SysNo"]));

                int isOK = Promotion_9Sky_Manager.GetInstance().UpdatePromotion_9Sky(
                    oCustomer.SysNo, nightSkyId, sysNoList);

                DataTable dtt = Promotion_9Sky_Manager.GetInstance().SelUserInfoToEmail(sysNoList);


  public static int UpdatePromotion_9Sky(int SysNo, string SkyID, List<int> sysNoList)
        {
            string SqlUpdate = @"UPDATE Ecommerce.dbo.Promotion_9Sky SET
                CustomerSysNo=" + SysNo + ", CustomerIdSky='" + Util.SafeFormat(SkyID) + @"', CreateDate = GetDate()
                WHERE SysNo in(" + CommonFunctions.GetStringFromIntList(sysNoList) + ")";

            return DataAccessFacade.ExecSqlCommand(SqlUpdate);
        }


 //整理字符串到安全格式
        public static string SafeFormat(string strInput)
        {
            if (string.IsNullOrEmpty(strInput) == true)
                return string.Empty;

            return strInput.Trim().Replace("'", "''");
        }



 /// <summary>
        /// 把int列表转换为字符串列表
        /// </summary>
        /// <param name="list">int列表</param>
        public static string GetStringFromIntList(List<int> list)
        {
            string strList = string.Empty;

            foreach (int id in list)
            {
                strList += (strList.Length == 0 ? "" : ",") + id.ToString();
            }

            return strList;
        }