贴段代码，分析分析

[ 1423 查看 / 0 回复 ]

返回列表
发新话题 回复该主题
shenyoujia
头像

陈健

  • 管理员
  • 14848
  • 1423
  • 2009-11-07
2010-01-25 14:57 |只看楼主 1#
t T
  1. using System;
  2. using System.Collections;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Web;
  6. using System.Web.Services;
  7. using System.Web.Services.Protocols;
  8. using System.Configuration;
  9. using System.Xml;
  10. using System.Text;
  11. using System.Net;
  12. using System.IO;
  13. using System.Collections.Generic;

  15. namespace WebService
  16. {
  17.     /// <summary>
  18.     /// Summary description for Service1
  19.     /// </summary>
  20.     [WebService(Namespace = "WebService_cs")]
  21.     [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
  22.     [ToolboxItem(false)]
  23.     public class Service1 : System.Web.Services.WebService
  24.     {
  25.         [WebMethod(Description = "传输数据")]
  26.         public string[] SendMessage()
  27.         {
  28.             List<string> Items = new List<string>();
  29.             Items.Clear();

  31.             DataSet ds;
  32.             string sql = "select id,phone,contents from WaitSend where (flag='N' or flag='F') and convert(varchar(10),create_dt,121) = convert(varchar(10),getdate(),121) ";
  33.             ds = SqlHelper.ExecuteDataset(SqlHelper.ConnectionString, CommandType.Text, sql);

  35.             if (ds.Tables[0].Rows.Count > 0)
  36.             {
  37.                 for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
  38.                 {
  39.                     Items.Add(String.Format("{0}|{1}|{2}", ds.Tables[0].Rows[i][0].ToString().Trim(), ds.Tables[0].Rows[i][1].ToString().Trim(), ds.Tables[0].Rows[i][2].ToString().Trim()));
  40.                 }
  41.             }
  42.             sql = "update WaitSend set flag='F' where flag='N' ";
  43.             SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString, CommandType.Text, sql);
  44.             return Items.ToArray();
  45.         }


  48.         [WebMethod(Description = "更新数据库")]
  49.         public void UpdateSQL(string IDList)
  50.         {
  51.             string sql = "update WaitSend set flag='Y' where flag='F' and id in (" + IDList + ")";
  52.             SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString, CommandType.Text, sql);
  53.         }
  54.     }
  55. }
复制代码
TOP
返回列表
上一主题 | 下一主题