Calendar webPart的源代码 (原创)

using System;
using System.ComponentModel;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Xml.Serialization;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Utilities;
using Microsoft.SharePoint.WebPartPages;
using Microsoft.SharePoint.WebControls;
using System.Web.UI.HtmlControls;
using System.Drawing;
using Microsoft.VisualBasic;
using System.Xml;
using SPDB.Business;
using System.Globalization;
using System.Threading;

namespace WebPartLibrary1
{
 /// <summary>
 /// Description for WebPart1.
 /// </summary>
 [DefaultProperty("Text"),ToolboxData("<{0}:WebPart1 runat=server></{0}:WebPart1>"),XmlRoot(Namespace="WebPartLibrary1")]

 public class WebPart1 : Microsoft.SharePoint.WebPartPages.WebPart
 {

        private System.Web.UI.WebControls.Calendar _calendar;
  private System.Web.UI.WebControls.Image _imageTop;
  private System.Web.UI.WebControls.Image _imageTitle;
  private System.Web.UI.WebControls.Image _imageDownBlack;
  private System.Web.UI.WebControls.Image _imageMore;
  
  private System.Threading.Thread thread;
  private CultureInfo oldCulture;

  #region property

  private const string defaultListName = "事件";
  private const string defaultDetailUrl = "";
  private string _eventListName = defaultListName;
  private string _eventDetailUrl = defaultDetailUrl;

  [Browsable(true),
  Category("定制"),
  DefaultValue(defaultListName),
  WebPartStorage(Storage.Shared),
  FriendlyName("事件列表标题"),
  Description("事件列表标题.")]
  public string EventListName
  {
   get
   {
    return _eventListName;
   }

   set
   {
    _eventListName = value;
   }
  }
  
  [Browsable(true),
  Category("定制"),
  DefaultValue(defaultDetailUrl),
  WebPartStorage(Storage.Shared),
  FriendlyName("网站地址"),
  Description("网站地址.")]
  public string EventDetailUrl
  {
   get
   {
    return _eventDetailUrl;
   }

   set
   {
    _eventDetailUrl = value;

    if (!_eventDetailUrl.EndsWith("/"))
     _eventDetailUrl += "/";
   }
  }

  private const bool defaultNewWindow = true;
  private bool _NewWindow = defaultNewWindow;

  [Browsable(true),
  Category("定制"),
  DefaultValue(defaultNewWindow),
  WebPartStorage(Storage.Shared),
  FriendlyName("是否打开新窗口"),
  Description("超链接是否打开新窗口")]
  public bool NewWindow
  {
   get
   {
    return _NewWindow;
   }
  
   set
   {
    _NewWindow = value;
   }
  }

  private const string defaultStyleServer = "" ;
  private string _StyleServer=defaultStyleServer;

  [Browsable(true),
  Category("定制"),
  DefaultValue(defaultStyleServer),
  WebPartStorage(Storage.Shared),
  FriendlyName("标题风格URL"),
  Description("标题风格所在网站的URL")]
  public string StyleServer
  {
   get
   {
    return _StyleServer;
   }
  
   set
   {
    _StyleServer = value;

    if (_StyleServer!="" && _StyleServer.IndexOf("/",7)>0)
     _StyleServer = _StyleServer.Substring(0,_StyleServer.IndexOf("/",7));
   }
  }

  private const string defaultStyleName = "" ;
  private string _StyleName=defaultStyleName;

  [Browsable(true),
  Category("定制"),
  DefaultValue(defaultStyleName),
  WebPartStorage(Storage.Shared),
  FriendlyName("标题风格名"),
  Description("标题风格名")]
  public string StyleName
  {
   get
   {
    return _StyleName;
   }
  
   set
   {
    _StyleName = value;
   }
  }

  #endregion

  #region ToolPart

  /// <summary>
  /// This method gets the custom tool parts for this Web Part by overriding the
  /// GetToolParts method of the WebPart base class. You must implement
  /// custom tool parts in a separate class that derives from
  /// Microsoft.SharePoint.WebPartPages.ToolPart.
  /// </summary>
  ///<returns>An array of references to ToolPart objects.</returns>
  public override ToolPart[] GetToolParts()
  {
   ToolPart[] toolparts = new ToolPart[2];
   CustomPropertyToolPart custom = new CustomPropertyToolPart();
   WebPartToolPart wptp = new WebPartToolPart();
   custom.Expand("定制");
   toolparts[0] = custom;
   toolparts[1] = wptp;
   return toolparts;
  }
  
  #endregion

  #region CreateChildControls

  /// <summary>
  /// Add calendar to this webpart.
  /// </summary>
  protected override void CreateChildControls()
  {
            #region Style

   //Top
   _imageTop = new System.Web.UI.WebControls.Image();
   _imageTop.ImageUrl = "E:/SPS/WebPartLibrary1/img/top.gif";
   _imageTop.Width = 300;

   #region meno

   //DownBlack
   _imageDownBlack = new System.Web.UI.WebControls.Image();
   _imageDownBlack.ImageUrl = "E:/SPS/WebPartLibrary1/img/downblack.bmp";
   _imageDownBlack.Height = 30;
   _imageDownBlack.Width = 230;

   //Top
   _imageMore = new System.Web.UI.WebControls.Image();
   _imageMore.ImageUrl = "E:/SPS/WebPartLibrary1/img/more.gif";
   _imageMore.Height = 30;
   _imageMore.Width = 70;
   #endregion

   //Title    "~/img/calender.gif"    "../img/calender.gif"
   _imageTitle = new System.Web.UI.WebControls.Image();
   _imageTitle.ImageUrl = "E:/SPS/WebPartLibrary1/img/calender.gif";
   _imageTitle.Height= 40;
   _imageTitle.Width = 300;
           
   //Calendar
   _calendar = new System.Web.UI.WebControls.Calendar();

   _calendar.Width = 300;
   _calendar.Height = 200;
   _calendar.BorderWidth = 0;

   _calendar.SelectedDate = System.DateTime.Today;
   
   //星期的显示格式
   _calendar.DayNameFormat = DayNameFormat.Full;
   _calendar.FirstDayOfWeek = System.Web.UI.WebControls.FirstDayOfWeek.Default;
   
   //边界
   _calendar.DayStyle.BorderWidth = 0;
   _calendar.EnableViewState = true;
   
   //其他月份
   _calendar.OtherMonthDayStyle.ForeColor = Color.FromArgb(219,242,244);
   _calendar.OtherMonthDayStyle.BackColor = Color.FromArgb(219,242,244);
           
   //字体
   _calendar.Font.Name = "Arial";
   _calendar.ForeColor = Color.Green;
   
   //日期样式
   _calendar.DayStyle.ForeColor = Color.Black;
   _calendar.DayStyle.BackColor = Color.FromArgb(219,242,244);
   
   //标题部分
   _calendar.TitleStyle.HorizontalAlign = HorizontalAlign.Right;
   _calendar.TitleStyle.BackColor = Color.FromArgb(219,242,244);
   
   //星期头部分
   _calendar.DayHeaderStyle.BorderStyle = BorderStyle.Double;
   _calendar.DayHeaderStyle.BackColor = Color.FromArgb(124,135,141);
   _calendar.DayHeaderStyle.ForeColor = Color.White;
   _calendar.DayHeaderStyle.BorderColor = Color.FromArgb(219,242,244);
   _calendar.DayHeaderStyle.BorderWidth = 4;
   _calendar.DayHeaderStyle.Height = 1;
   
   //显示上/下月
   _calendar.ShowNextPrevMonth = true;
   
   #endregion
   
   #region Event

   //事件
            _calendar.DayRender += new System.Web.UI.WebControls.DayRenderEventHandler(Calendar_DayRender);
   _calendar.PreRender += new System.EventHandler(Calendar_PreRender);

   #endregion

   Controls.Add(_imageTop);
   Controls.Add(_imageTitle);
   Controls.Add(_calendar);
   Controls.Add(_imageDownBlack);
   Controls.Add(_imageMore);
  }

  #endregion

  #region RenderWebPart

  /// <summary>
  /// Render this Web Part to the output parameter specified.
  /// </summary>
  /// <param name="output"> The HTML writer to write out to </param>
  protected override void RenderWebPart(HtmlTextWriter output)
  {
   try
   {
    string titleStr="";
    if(_StyleServer!="" && _StyleName!="")
     titleStr=SPDB.Business.SPDBCommon.GetTitleStr(_StyleServer,_StyleName);

    if (titleStr!="")
    {
     titleStr = titleStr.Replace("#Title#",this.Title);
     titleStr = titleStr.Replace("#MoreUrl#",this.DetailLink);
     titleStr = titleStr.Replace("#Description#",this.Description);
     titleStr = titleStr.Replace("#AreaDescription#","");
     titleStr = titleStr.Replace("#Detail#","");
    }
    
    output.Write(titleStr);
                RenderChildren(output);
   }
   catch (Exception ex)
   {
    output.Write(ex.Message);
   }
   finally
   {
    output.Flush();
   }
  }

  #endregion

  #region Event Calendar_DayRender & Calendar_PreRender

  private void Calendar_DayRender(object sender, DayRenderEventArgs e)
  {
   thread.CurrentCulture = this.oldCulture;
           
   //Get each day's events and set it to Tooltips.
   GetEventSetTooltip(sender,e);
  }
  
  //Change Date Style is "日", "一", "二", "三", "四", "五", "六"

  private void Calendar_PreRender(object sender, EventArgs e)
  {
   thread = System.Threading.Thread.CurrentThread;
   oldCulture = thread.CurrentCulture;
   CultureInfo newci = (CultureInfo)oldCulture.Clone();
   newci.DateTimeFormat.DayNames = new string[] { "日", "一", "二", "三", "四", "五", "六" };
   newci.DateTimeFormat.FirstDayOfWeek = DayOfWeek.Sunday;
   thread.CurrentCulture = newci;
  }

  #endregion

  #region GetEventSetTooltip

  private void GetEventSetTooltip (object sender, System.Web.UI.WebControls.DayRenderEventArgs e)
  {
   e.Cell.Text = e.Day.DayNumberText;

   SPSite site=null;
   SPWeb mySite=null;

   try
   {
    string serverStr="",areaStr;

    if (EventDetailUrl!="")
    {
     int i = EventDetailUrl.IndexOf("/",7);
     serverStr = EventDetailUrl.Substring(0,i);
     areaStr = EventDetailUrl.Substring(serverStr.Length);

     site = new SPSite(serverStr);
     mySite = site.OpenWeb(areaStr);
    }
    else
    {
     site = SPControl.GetContextSite(Context);
     mySite = site.OpenWeb();
    }

    // Start to search the events of current day.
    SPList list = mySite.Lists[EventListName];

    string detailUrl = serverStr + list.DefaultViewUrl;

    SPQuery query = new SPQuery();
    query.Query = String.Format("<Where>"
     + "<Or>"
     + "<And>"
     + "<Or>"
     + "<And>"
     + "<Leq>"
     + "<FieldRef Name=\"EventDate\"></FieldRef>"
     + "<Value Type=\"DateTime\">"
     + "{0}"
     + "</Value>"
     + "</Leq>"
     + "<Geq>"
     + "<FieldRef Name=\"EndDate\"></FieldRef>"
     + "<Value Type=\"DateTime\">"
     + "{0}"
     + "</Value>"
     + "</Geq>"
     + "</And>"
     + "<And>"
     + "<Eq>"
     + "<FieldRef Name=\"EventDate\"></FieldRef>"
     + "<Value Type=\"DateTime\">"
     + "{0}"
     + "</Value>"
     + "</Eq>"
     + "<IsNull>"
     + "<FieldRef Name=\"EndDate\"></FieldRef>"
     + "</IsNull>"
     + "</And>"
     + "</Or>"
     + "<Eq>"
     + "<FieldRef Name=\"fRecurrence\"></FieldRef>"
     + "<Value Type=\"Integer\">0</Value>"
     + "</Eq>"
     + "</And>"
     + "<And>"
     + "<And>"
     + "<Leq>"
     + "<FieldRef Name=\"EventDate\"></FieldRef>"
     + "<Value Type=\"DateTime\">"
     + "{0}"
     + "</Value>"
     + "</Leq>"
     + "<Geq>"
     + "<FieldRef Name=\"EndDate\"></FieldRef>"
     + "<Value Type=\"DateTime\">"
     + "{0}"
     + "</Value>"
     + "</Geq>"
     + "</And>"
     + "<Neq>"
     + "<FieldRef Name=\"fRecurrence\"></FieldRef>"
     + "<Value Type=\"Integer\">0</Value>"
     + "</Neq>"
     + "</And>"
     + "</Or>"
     + "</Where>", e.Day.Date);

    SPListItemCollection items = list.GetItems(query);

    String strTooltip = "";
    foreach (SPListItem item in items)
    {
     if (SPDBCommon.ObjToStr(item["fRecurrence"]) == "0")
     {
      strTooltip += SPDBCommon.ObjToStr(item["Title"]) + "("
       + SPDBCommon.FormatDateTime(item["EventDate"]) + " ~ "
       + SPDBCommon.FormatDateTime(item["EndDate"]) + ")"
       + "\n";
     }
     else
     {
      if (IsDateOverlaped(e.Day.Date, (DateTime)item["EventDate"], SPDBCommon.ObjToStr(item["RecurrenceData"])))
      {
       strTooltip += SPDBCommon.ObjToStr(item["Title"]) + "("
        + SPDBCommon.FormatDateTime(item["EventDate"]) + " ~ "
        + SPDBCommon.FormatDateTime(item["EndDate"]) + ")"
        + "\n";
      }
     }
    }

    if (strTooltip != "")
    {
     //判断是否是当前月
     if(!e.Day.IsOtherMonth)
     {
      e.Cell.Font.Underline = true;
     }
     else{
      e.Cell.Font.Size = -1;
      e.Cell.Enabled = false;
     }
     e.Cell.ToolTip = strTooltip;
     e.Cell.Text = "<a href='" + detailUrl + "?CalendarDate=" + SPDBCommon.FormatDateTime(e.Day.Date)+"'";
     if (NewWindow)
      e.Cell.Text += " target=_blank";
     e.Cell.Text += ">" + e.Day.DayNumberText + "</a>";
    }
   }
   catch (System.Exception ex)
   {
    e.Cell.ToolTip += ex.Message;
   }
   finally
   {
    site.Close();
    mySite.Close();
   }
  }

  #endregion
  
  #region IsDateOverlaped

  /// <summary>
  /// If fRecurrence == -1, then check if current day is Overlaped with the event.
  /// </summary>
  /// <param name="dtCurrent">current day</param>
  /// <param name="dtStart">the day when the event start</param>
  /// <param name="strXML">the event description.</param>
  /// <returns>true if the current day is overlaped with the event</returns>
  private bool IsDateOverlaped(DateTime dtCurrent, DateTime dtStart, string strXML)
  {
   string sFirstDayOfWeek;
   double dFrequency;
   TimeSpan TS = new TimeSpan(dtCurrent.Ticks - dtStart.Ticks);
   object[] arrWeekday = {
           new object[] {"su", DayOfWeek.Sunday},
           new object[] {"mo", DayOfWeek.Monday},
           new object[] {"tu", DayOfWeek.Tuesday},
           new object[] {"we", DayOfWeek.Wednesday},
           new object[] {"th", DayOfWeek.Thursday},
           new object[] {"fr", DayOfWeek.Friday},
           new object[] {"sa", DayOfWeek.Saturday}
          };
   

   XmlDocument xmlDoc = new XmlDocument();
   xmlDoc.LoadXml(strXML);

   sFirstDayOfWeek = xmlDoc.SelectSingleNode("/recurrence/rule/firstDayOfWeek").InnerText;

   XmlNode repeatChildNode = xmlDoc.SelectSingleNode("/recurrence/rule/repeat").FirstChild;

   switch (repeatChildNode.Name)
   {
    case "daily":
     dFrequency = Convert.ToDouble(repeatChildNode.Attributes["dayFrequency"].InnerText);
     if (TS.TotalDays % dFrequency == 0)
      return true;
     break;
    case "weekly":
     foreach(object[] oWeekday in arrWeekday)
     {
      if (dtCurrent.DayOfWeek != (DayOfWeek)oWeekday[1])
       continue;
      if (repeatChildNode.Attributes.GetNamedItem(oWeekday[0].ToString()) == null)
       continue;
      if (repeatChildNode.Attributes[oWeekday[0].ToString()].InnerText == "TRUE")
      {
       dFrequency = Convert.ToDouble(repeatChildNode.Attributes["weekFrequency"].InnerText);
       if (Convert.ToInt32(TS.TotalDays/7) % dFrequency == 0)
        return true;
      }
     }
     break;
    case "monthly":
     if (dtCurrent.Day.ToString() != repeatChildNode.Attributes["day"].InnerText)
      return false;
     dFrequency = Convert.ToDouble(repeatChildNode.Attributes["monthFrequency"].InnerText);
     if (DateAndTime.DateDiff(DateInterval.Month,dtStart, dtCurrent, Microsoft.VisualBasic.FirstDayOfWeek.Monday, Microsoft.VisualBasic.FirstWeekOfYear.System) % dFrequency == 0)
      return true;
     break;
    case "monthlyByDay":
     if (GetWeekdayOfMonth(dtCurrent).IndexOf(repeatChildNode.Attributes["weekdayOfMonth"].InnerText) == -1)
      return false;

     foreach(object[] oWeekday in arrWeekday)
     {
      if (dtCurrent.DayOfWeek != (DayOfWeek)oWeekday[1])
       continue;
      if (repeatChildNode.Attributes.GetNamedItem(oWeekday[0].ToString()) == null)
       continue;
      if (repeatChildNode.Attributes[oWeekday[0].ToString()].InnerText == "TRUE")
      {
       dFrequency = Convert.ToDouble(repeatChildNode.Attributes["monthFrequency"].InnerText);
       if (DateAndTime.DateDiff(DateInterval.Month,dtStart, dtCurrent, Microsoft.VisualBasic.FirstDayOfWeek.Monday, Microsoft.VisualBasic.FirstWeekOfYear.System) % dFrequency == 0)
        return true;
      }
     }
     break;
    case "yearly":
     if (dtCurrent.Month != dtStart.Month || dtCurrent.Day != dtStart.Day)
      return false;
     dFrequency = Convert.ToDouble(repeatChildNode.Attributes["yearFrequency"].InnerText);
     if ((dtCurrent.Year - dtStart.Year) % dFrequency == 0)
      return true;
     break;
   }

   return false;
  }

  #endregion

  #region GetWeekdayOfMonth

  /// <summary>
  /// Get the weekday number of the month.
  /// </summary>
  /// <param name="dtCurrent"></param>
  /// <returns></returns>
  private string GetWeekdayOfMonth(DateTime dtCurrent)
  {
   DateTime dtFirstDayOfMonth = new DateTime(dtCurrent.Year, dtCurrent.Month, 1);
   TimeSpan TS = new TimeSpan(dtCurrent.Ticks - dtFirstDayOfMonth.Ticks);

   DateTime dtLastDayOfMonth = dtFirstDayOfMonth.AddMonths(1).AddDays(-1);
   TimeSpan tsLast = new TimeSpan(dtLastDayOfMonth.Ticks - dtCurrent.Ticks);

   string sRet = "";

   switch (Convert.ToInt16(TS.TotalDays/7))
   {
    case 0:
     sRet += "first";
     break;
    case 1:
     sRet += "second";
     break;
    case 2:
     sRet += "third";
     break;
    case 3:
     sRet += "fourth";
     break;
   }

   // Maybe the last week also is the fourth week.
   if (Convert.ToInt16(tsLast.TotalDays/7) == 0)
    sRet += ";last";

   return sRet;
  }

  #endregion

 }
}

------------------------------------------------------------------

using System;
using Microsoft.SharePoint;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.IO;
using System.Xml;
using Microsoft.SharePoint.Utilities;

namespace SPDB.Business
{
 /// <summary>
 /// Summary description for SPDBCommon.
 /// </summary>
 public class SPDBCommon
 {
  public SPDBCommon()
  {
   //
   // TODO: Add constructor logic here
   //
  }

  public static void WriteLog(string sLogFile, string sLogMessage)
  {
   try
   {
    StreamWriter w = File.AppendText(sLogFile);

    w.Write("\r\nLog Entry : ");
    Console.Write("\r\nLog Entry : ");
    w.WriteLine("{0} {1}", DateTime.Now.ToLongTimeString(),
     DateTime.Now.ToLongDateString());
    Console.WriteLine("{0} {1}", DateTime.Now.ToLongTimeString(),
     DateTime.Now.ToLongDateString());
    w.WriteLine("  {0}", sLogMessage);
    Console.WriteLine("  {0}", sLogMessage);
    // Update the underlying file.
    w.Flush();

    // Close the writer and underlying file.
    w.Close();

   }
   catch(Exception e)
   {
    Console.Write(e.Message );
   }
  }

  /// <summary>
  /// Check if the news file is already uploaded.
  /// </summary>
  /// <param name="strFile"></param>
  /// <returns></returns>
  public static bool IsFileUploaded(string strFile)
  {
   string sTemp = "NoDocID";

   string sDocID = strFile.Substring(0, strFile.LastIndexOf("."));
   sDocID = sDocID.Substring(sDocID.LastIndexOf("_") + 1);

   if (sDocID == "") return false;

   string sConnectionString = ConfigurationSettings.AppSettings.Get("SPDB.WorldNewsExterior.SQLConnectionString");
   
   string strSQL = "SELECT ext8 FROM CMS_DOCMAIN WHERE doc_id = " + sDocID;

   SqlConnection newsConn = new SqlConnection(sConnectionString);

   SqlCommand selectCMD = new SqlCommand(strSQL, newsConn);
   selectCMD.CommandTimeout = 5;

   newsConn.Open();

   SqlDataReader reader = reader = selectCMD.ExecuteReader();

   if (reader.Read())
   {
    sTemp = reader.GetString(0);
   }

   newsConn.Close();

   // If already uploaded or NoDocID in this database, then not need upload, so return true;
   if (sTemp == "Uploaded" || sTemp == "NoDocID")
   {
    return true;
   }

   return false;
  }

  /// <summary>
  /// Convert object to string, return "" if object is null.
  /// </summary>
  /// <param name="oItem">input object param</param>
  /// <returns></returns>
  public static string ObjToStr(object oItem)
  {
   if (oItem == null)
   {
    return "";
   }
   else
   {
    return oItem.ToString();
   }
  }

  /// <summary>
  /// Convert date object to string.
  /// </summary>
  /// <param name="oItem">input date object param</param>
  /// <returns></returns>
  public static string FormatDateTime(object oItem)
  {
   if (oItem == null)
   {
    return "";
   }
   else
   {
    DateTime dtItem = (DateTime)oItem;
    return dtItem.Year + "-" + dtItem.Month + "-" + dtItem.Day;
   }
  }

  /// <summary>
  /// Get the world news file name. This logic come from outter news system of ChuangYang company.
  /// </summary>
  /// <param name="sDate"></param>
  /// <param name="sChID"></param>
  /// <param name="sDocID"></param>
  /// <returns></returns>
  public static string GetWorldNewsFileName(string sDate, string sChID, string sDocID)
  {
   DateTime dtTemp = DateTime.Parse(sDate);

   return FormatNumberString(dtTemp.Year.ToString(), 4)
    + FormatNumberString(dtTemp.Month.ToString(), 2)
    + "/"
    + FormatNumberString(dtTemp.Month.ToString(),2)
    + FormatNumberString(dtTemp.Day.ToString(),2)
    + "_"
    + sChID
    + "_"
    + sDocID
    + ".aspx";
  }

  /// <summary>
  /// Add the "0" char at the begin of the string.
  /// </summary>
  /// <param name="sNumber"></param>
  /// <param name="iLen"></param>
  /// <returns></returns>
  public static string FormatNumberString(string sNumber, int iLen)
  {
   return ((string)("0000000000" + sNumber)).Substring(10 + sNumber.Length - iLen);
  }

  /// <summary>
  /// Set file uploaded flag.
  /// </summary>
  /// <param name="strFile"></param>
  public static void SetFileUploaded(string strFile)
  {
   string sDocID = strFile.Substring(0, strFile.LastIndexOf("."));
   sDocID = sDocID.Substring(sDocID.LastIndexOf("_") + 1);

   if (sDocID == "") return;

   string sConnectionString = ConfigurationSettings.AppSettings.Get("SPDB.WorldNewsExterior.SQLConnectionString");
   
   string strSQL = "UPDATE CMS_DOCMAIN SET ext8 = 'Uploaded' WHERE doc_id = " + sDocID;

   SqlConnection newsConn = new SqlConnection(sConnectionString);

   SqlCommand updateCMD = new SqlCommand(strSQL, newsConn);
   updateCMD.CommandTimeout = 5;
   newsConn.Open();

   int intRows = updateCMD.ExecuteNonQuery();

   // Copy the record to table CMSNEWS of internal sql server.
   updateCMD.CommandText = "SELECT * FROM CMSNEWS WHERE doc_id = " + sDocID;
   SqlDataReader dbReader = updateCMD.ExecuteReader();
   
   string sInternalConnectionString = ConfigurationSettings.AppSettings.Get("SPDB.WorldNews.SQLConnectionString");
   
   if (dbReader.Read())
   {
    strSQL = "SELECT type_id, typecode, typename, CHID, DIST_TIME, AUDIT_STATUS,"
     + " doc_id, doc_title, doc_dt_lastmodified, doc_dt_new, ext8, doc_level, doc_hot"
     + " FROM CMSNEWS WHERE doc_id = " + sDocID;

    SqlDataAdapter dbAdapter = new SqlDataAdapter(strSQL, sInternalConnectionString);
    SqlCommandBuilder dbCMDBuilder = new SqlCommandBuilder(dbAdapter);
    DataTable dtNews = new DataTable();

    dbAdapter.Fill(dtNews);

    DataRow drNews;
    if (dtNews.Rows.Count == 0)
    {
     drNews = dtNews.NewRow();
    }
    else
    {
     drNews = dtNews.Rows[0];
    }
    drNews["type_id"] = dbReader.GetValue(0);
    drNews["typecode"] = dbReader.GetValue(1);
    drNews["typename"] = dbReader.GetValue(2);
    drNews["CHID"] = dbReader.GetValue(3);
    drNews["DIST_TIME"] = dbReader.GetValue(4);
    drNews["AUDIT_STATUS"] = dbReader.GetValue(5);
    drNews["doc_id"] = dbReader.GetValue(6);
    drNews["doc_title"] = dbReader.GetValue(7);
    drNews["doc_dt_lastmodified"] = dbReader.GetValue(8);
    drNews["doc_dt_new"] = dbReader.GetValue(9);
    drNews["ext8"] = dbReader.GetValue(10);
    drNews["doc_level"] = dbReader.GetValue(11);
    drNews["doc_hot"] = dbReader.GetValue(12);

    if (dtNews.Rows.Count == 0)
    {
     dtNews.Rows.Add(drNews);
    }

    dbAdapter.Update(dtNews);
   }

   newsConn.Close();

  }

  /// <summary>
  /// Create Xml for WorldNews webpart.
  /// </summary>
  public static void CreateWorldNewsXml()
  {
   try
   {
    string destPath = ConfigurationSettings.AppSettings.Get("destWorldNewsXmlPath");
    if (destPath!="")
    {
     StreamWriter sw = File.CreateText(destPath + "\\WorldNews.xml");

     string strTemp = "";
     string strSQL = "SELECT TOP 100 * FROM CMSNEWS WHERE ext8 = 'Uploaded' ORDER BY dist_time DESC, type_id";
     //string strSQL = ConfigurationSettings.AppSettings.Get("strSQL_GetWorldNews");

     SqlConnection newsConn = new SqlConnection(ConfigurationSettings.AppSettings.Get("SPDB.WorldNewsExterior.SQLConnectionString"));

     SqlCommand selectCMD = new SqlCommand(strSQL, newsConn);
     SqlDataAdapter custDA = new SqlDataAdapter();
     custDA.SelectCommand = selectCMD;

     newsConn.Open();

     DataSet custDS = new DataSet();
     custDA.Fill(custDS, "WorldNews");
   
     sw.Write("<WorldNews>\n");
   
     foreach (DataRow row in custDS.Tables["WorldNews"].Rows)
     {
      strTemp = GetWorldNewsFileName(row["doc_dt_new"].ToString(),
       row["chid"].ToString(),
       row["doc_id"].ToString());

      sw.Write ("<News Title=\"" + SPEncode.HtmlEncode(row["doc_title"].ToString()) + "\" Page=\"" + strTemp + "\" doc_dt_new=\"" + row["doc_dt_new"].ToString() + "\"/>\n");
     }

     sw.Write("</WorldNews>\n");
     sw.Close();

     newsConn.Close();
    }
    else
    {
     throw(new Exception("No destWorldNewsXmlPath Configuration!"));
    }
   }
   catch(Exception e)
   {
    throw(e);
   }
  }

  
  public static string GetTitleStr(string styleServer, string styleName)
  {
   string titleStr="";
   SPSite sites = new SPSite(styleServer);
   SPWeb mysite = sites.OpenWeb("/sites/siteconfig");
 
   SPListItemCollection items = mysite.Lists["stylelibrary"].Items;

   string styleUrl;
   foreach (SPListItem item in items)
   {
    if (item["BaseName"].ToString()==styleName)
    {
     if (item.File.Exists)
     {
      styleUrl =styleServer + item.File.ServerRelativeUrl;
      System.Net.HttpWebRequest request = (System.Net.HttpWebRequest)System.Net.WebRequest.Create(styleUrl);
      System.Net.ICredentials credentials = System.Net.CredentialCache.DefaultCredentials;
      request.Credentials = credentials;
      System.Net.HttpWebResponse response = (System.Net.HttpWebResponse)request.GetResponse();
      System.IO.Stream stream = response.GetResponseStream();

      System.IO.StreamReader reader = new System.IO.StreamReader(stream,System.Text.Encoding.UTF8);

      titleStr = reader.ReadToEnd();
      int start = titleStr.IndexOf("<!-- Begin Panel Layout -->");
      int end = titleStr.IndexOf("<!-- End Panel Layout -->");
      if (start>0 && end > start)
       titleStr = titleStr.Substring(start,end-start);
     }
    }
   }
   return titleStr;
  }
 }
}