using System; 
using System.Collections.Generic; 
using System.Text; 
using System.Data; 
using SysBaseLibs; 
using System.Web.Script.Serialization;
using System.Web.UI.HtmlControls;
namespace SysDataLibs.TableClass
{
    #region      BulletinInfo
    public partial class BulletinInfo_info : ITableInfo
    {
        #region      BulletinInfo表 字段信息
        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： smallint;
        /// 数据长度： 2;
        /// 是否允许为空： Y;
        /// 默认值： ((1));
        /// 描述： 是否审核;
        /// </summary>
        public const string cAuditFlag = "AuditFlag";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： int;
        /// 数据长度： 4;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 公告类型;
        /// </summary>
        public const string cBulletinTypeID = "BulletinTypeID";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： text;
        /// 数据长度： 16;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 公告内容;
        /// </summary>
        public const string ccontent = "content";

        /// <summary> 
        /// 为关键字段： Y --- PrimaryKey;
        /// 自动增长： Y;
        /// 数据类型： int;
        /// 数据长度： 4;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 编号;
        /// </summary>
        public const string cID = "ID";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： char;
        /// 数据长度： 10;
        /// 是否允许为空： Y;
        /// 默认值： ;
        /// 描述： 市场编号;
        /// </summary>
        public const string cMarketID = "MarketID";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： nvarchar;
        /// 数据长度： 200;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 标题;
        /// </summary>
        public const string cTitle = "Title";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： smalldatetime;
        /// 数据长度： 4;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 更新时间;
        /// </summary>
        public const string cUpdateTime = "UpdateTime";

        /// <summary> 
        /// 为关键字段： N ;
        /// 自动增长： N;
        /// 数据类型： varchar;
        /// 数据长度： 30;
        /// 是否允许为空： N;
        /// 默认值： ;
        /// 描述： 发布者;
        /// </summary>
        public const string cUserID = "UserID";

        #endregion
        public BulletinInfo_info() { }

        public BulletinInfo_info(DataRow poRow)
        {
            CreateTableInfo(poRow);
        }

        public void CreateTableInfo(DataRow poRow)
        {
            _AuditFlag = UtilStr.StrFromObj(poRow[cAuditFlag]);
            _BulletinTypeID = UtilStr.StrFromObj(poRow[cBulletinTypeID]);
            _content = UtilStr.StrFromObj(poRow[ccontent]);
            _ID = UtilStr.StrFromObj(poRow[cID]);
            _MarketID = UtilStr.StrFromObj(poRow[cMarketID]);
            _Title = UtilStr.StrFromObj(poRow[cTitle]);
            _UpdateTime = UtilStr.StrFromObj(poRow[cUpdateTime]);
            _UserID = UtilStr.StrFromObj(poRow[cUserID]);
        }

        public BulletinInfo_info(string pcID, DBConnSql poDBConn)
        {
            if (pcID.Trim().Length > 0 && poDBConn != null)
            {
                string lcSql = "select * from " + Tn.BulletinInfo + " where ID='" + pcID + "'";
                rsQuery loQuery = poDBConn.OpenQuery(lcSql);
                if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 1)
                {
                    loQuery.MoveFirst();
                    CreateTableInfo(loQuery.CurrentRow);
                }
            }
        }
        private string _AuditFlag = "";
        public string AuditFlag
        {
            get { return _AuditFlag; }
            set { _AuditFlag = value; }
        }

        private string _BulletinTypeID = "";
        public string BulletinTypeID
        {
            get { return _BulletinTypeID; }
            set { _BulletinTypeID = value; }
        }

        private string _content = "";
        public string content
        {
            get { return _content; }
            set { _content = value; }
        }

        private string _ID = "";
        public string ID
        {
            get { return _ID; }
            set { _ID = value; }
        }

        private string _MarketID = "";
        public string MarketID
        {
            get { return _MarketID; }
            set { _MarketID = value; }
        }

        private string _Title = "";
        public string Title
        {
            get { return _Title; }
            set { _Title = value; }
        }

        private string _UpdateTime = "";
        public string UpdateTime
        {
            get { return _UpdateTime; }
            set { _UpdateTime = value; }
        }

        private string _UserID = "";
        public string UserID
        {
            get { return _UserID; }
            set { _UserID = value; }
        }

        [ScriptIgnore]
        public rsXmlNode DataXMLNode
        {
            get
            {
                rsXmlNode loMainNode = new rsXmlNode("BulletinInfoRecord", "");
                rsXmlNode loNode = null;
                loNode = new rsXmlNode(cAuditFlag, AuditFlag);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cBulletinTypeID, BulletinTypeID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(ccontent, content);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cID, ID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cMarketID, MarketID);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cTitle, Title);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cUpdateTime, UpdateTime);
                loMainNode.AddChild(loNode);
                loNode = new rsXmlNode(cUserID, UserID);
                loMainNode.AddChild(loNode);
                return loMainNode;
            }
        }
        public string InsertSql()
        {
            return " insert into " + Tn.BulletinInfo + " " +
                        " (" + cAuditFlag + "," + cBulletinTypeID + "," + ccontent + "," + cMarketID + "," + cTitle + "," + cUpdateTime + "," + cUserID + ") " +
                        " values ('" + _AuditFlag + "'," + _BulletinTypeID + ",'" + _content + "','" + _MarketID + "','" + _Title + "','" + _UpdateTime + "','" + _UserID + "') ";
        }

        public string UpdateSql()
        {
            return " update " + Tn.BulletinInfo + " " +
                    " set " + cAuditFlag + "='" + _AuditFlag + "'," + cBulletinTypeID + "=" + _BulletinTypeID + "," + ccontent + "='" + _content + "'," + cMarketID + "='" + _MarketID + "'," + cTitle + "='" + _Title + "'," + cUpdateTime + "='" + _UpdateTime + "'," + cUserID + "='" + _UserID + "' " +
                    " where  " + cID + "=" + _ID + "";
        }

        public string DeleteSql()
        {
            return "Delete " + Tn.BulletinInfo + " where " + cID + "=" + _ID + "";
        }

        public static int hasNotRead(string pcType, UserSession poSession)
        {
            string date = DateTime.Now.AddMonths(-1).ToShortDateString();
            string lcSql = "select count(*) as mscount from " + Tn.BulletinInfo + "  where " + BulletinInfo_info.cBulletinTypeID + "='" + pcType +
                "' and UpdateTime > '" + date + "' AND AuditFlag='1' and " + BulletinInfo_info.cID + " not in (select " + Sys_AttachTables_info.cSourceKey + " from " + Tn.Sys_AttachTables + " where " + Sys_AttachTables_info.cTableId + "='" + Tn.BulletinInfo + "' and " + Sys_AttachTables_info.cUserID + "='" + poSession.UserInfo.UserID + "')";
            rsQuery loQuery = poSession.DBConn.OpenQuery(lcSql);
            if (loQuery != null && loQuery.IsOpened)
            {
                return loQuery.GetInt("mscount");
            }
            return 0;
        }

        public static void PrintBulletinInfo(HtmlTable poTable, string pcType, UserSession poSession, string pcId)
        {
            if (poTable != null && pcType.Trim().Length > 0 && poSession != null && poSession.DBConn != null)
            {
              //  string datetime = DateTime.Now.Year + "-01-01";
                
                //string datetime = DateTime.Now.AddMonths(-3).ToShortDateString();
                string datetime = DateTime.Now.AddMonths(SysDataLibs.AppEnv.SysSetObj.GetInt("BulletinShowTimeSpan")).ToShortDateString();
                string lcSql = "SELECT TOP 150 * FROM BulletinInfo WHERE BulletinTypeID='" + pcType + "' AND AuditFlag='1' AND UpdateTime >='" + datetime + "' ";
                rsQuery loQuery = poSession.DBConn.OpenQuery(lcSql);
                if (loQuery != null && loQuery.IsOpened && loQuery.RecCount > 0)
                {
                    loQuery.SortBy("UpdateTime", false);
                    loQuery.MoveFirst();
                    for (int i = 0; i < loQuery.RecCount; i++)
                    {
                        string lcColor = "#C6DBFF";

                        bool lbIsCurLine = pcId == loQuery.GetString("ID");
                        if (lbIsCurLine)
                            lcColor = "#8CAAE7";

                        HtmlTableRow loRow = new HtmlTableRow();
                        HtmlTableCell loCell = new HtmlTableCell();
                        loCell.Attributes.Add("bgcolor", lcColor);
                        loCell.InnerText = (i + 1) + "";
                        loRow.Cells.Add(loCell);

                        loCell = new HtmlTableCell();
                        string lcTitle = loQuery.GetString("Title");
                        if (lcTitle.Length < 60)
                        {
                            lcTitle += UtilStr.Replicate("&nbsp;", 60 - lcTitle.Length);
                        }
                        if (lbIsCurLine)
                        {
                            loCell.InnerHtml = string.Format("<div id='row{0}'>{1}</div>\n", loQuery.GetString("ID"), lcTitle);
                        }
                        else
                        {
                            loCell.InnerHtml = string.Format("<div  style='CURSOR:hand'  onclick=\"javascript:ShowContextById({0})\"  id='row{0}'>{1}</div>\n", loQuery.GetString("ID"), lcTitle);
                        }
                        loCell.Attributes.Add("bgcolor", lcColor);
                        loRow.Cells.Add(loCell);

                        loCell = new HtmlTableCell();
                        loCell.InnerText = loQuery.GetString("UserID");
                        string lcUserSql = "select * from " + Tn.Sys_Users + " where " + Sys_Users_info.cUserID + "='" + loQuery.GetString("UserID") + "'";
                        rsQuery loUser = poSession.DBConn.OpenQuery(lcUserSql);
                        if (loUser != null && loUser.IsOpened && loUser.RecCount == 1)
                        {
                            loUser.MoveFirst();
                            loCell.InnerText = loUser.GetString("Names");
                        }
                        loCell.Attributes.Add("bgcolor", lcColor);
                        loRow.Cells.Add(loCell);

                        loCell = new HtmlTableCell();
                        loCell.InnerHtml = string.Format("{0:d}", loQuery.GetDateTime("UpdateTime"));
                        loCell.Attributes.Add("bgcolor", lcColor);
                        loRow.Cells.Add(loCell);

                        loCell = new HtmlTableCell();
                        string lcID = loQuery.GetString("ID");
                        Sys_AttachFiles_info loAttachFile = new Sys_AttachFiles_info("BulletinInfo", "ID", lcID, poSession.DBConn);

                        string lcImg = "RICON100.GIF";
                        string ext = UtilStr.UAndT(loAttachFile.FileExt);
                        if (loAttachFile.FileExt.Trim().Length > 0)
                        {

                            if (ext == "DOC" || ext == "DOCS" || ext == "DOCX")
                            {
                                lcImg = "ICON-WORD.GIF";
                            }
                            else if (ext == "XLS" || ext == "XLSX")
                            {
                                lcImg = "ICON-EXCEL.GIF";
                            }
                            else if (ext == "TXT")
                            {
                                lcImg = "ftv2doc_3.gif";
                            }
                            loCell.InnerHtml = string.Format(" <a href =\"{0}\"> <IMG  style=\"CURSOR: hand\" title=\"下载\"  src=\"../Images/{1}\"></a>", loAttachFile.DownPath(), lcImg);
                        }
                        else
                        {
                            loCell.InnerHtml = "无";
                        }
                        
                        //loCell.InnerHtml = "";//string.Format("{0:d}", loQuery.GetDateTime("UpdateTime"));
                        loCell.Attributes.Add("bgcolor", lcColor);

                        loRow.Cells.Add(loCell);
                        poTable.Rows.Add(loRow);


                        if (lbIsCurLine)
                        {
                            loRow = new HtmlTableRow();
                            loCell = new HtmlTableCell();
                            loCell.Attributes.Add("bgcolor", lcColor);
                            loCell.Attributes.Add("colspan", "5");
                            loCell.InnerHtml = loQuery.GetString("content");
                            loCell.Attributes.Add("bgcolor", "#FFFBF7");
                            loRow.Cells.Add(loCell);
                            poTable.Rows.Add(loRow);

                            Sys_AttachTables_info loAttachTables = new Sys_AttachTables_info();
                            loAttachTables.TableId = Tn.BulletinInfo;
                            loAttachTables.ColumnId = BulletinInfo_info.cID;
                            loAttachTables.SourceKey = pcId;
                            loAttachTables.UserID = poSession.UserInfo.UserID;
                            loAttachTables.Actiion = "已读";

                            if (loAttachTables.Update(poSession))
                            {
                                Sys_Log_info.LogMsg(LogType.Normal, "阅读消息", "公告信息" + lcTitle + "已被" + poSession.UserInfo.Names + "阅读", "");
                            }
                        }
                        loQuery.MoveNext();
                    }
                }
            }
        }
    }

    #endregion

    #region

    public class BulletinInfo_Qry : rsQuery
    {
        public Int64 AuditFlag
        {
            get { return GetInt(BulletinInfo_info.cAuditFlag); }
            //    set { SetField(BulletinInfo_info.cAuditFlag, value); } 
        }

        public Int64 BulletinTypeID
        {
            get { return GetInt(BulletinInfo_info.cBulletinTypeID); }
            //    set { SetField(BulletinInfo_info.cBulletinTypeID, value); } 
        }

        public String content
        {
            get { return GetString(BulletinInfo_info.ccontent); }
            //    set { SetField(BulletinInfo_info.ccontent, value); } 
        }

        public Int64 ID
        {
            get { return GetInt(BulletinInfo_info.cID); }
            //    set { SetField(BulletinInfo_info.cID, value); } 
        }

        public String MarketID
        {
            get { return GetString(BulletinInfo_info.cMarketID); }
            //    set { SetField(BulletinInfo_info.cMarketID, value); } 
        }

        public String Title
        {
            get { return GetString(BulletinInfo_info.cTitle); }
            //    set { SetField(BulletinInfo_info.cTitle, value); } 
        }

        public DateTime UpdateTime
        {
            get { return GetDateTime(BulletinInfo_info.cUpdateTime); }
            //    set { SetField(BulletinInfo_info.cUpdateTime, value); } 
        }

        public String UserID
        {
            get { return GetString(BulletinInfo_info.cUserID); }
            //    set { SetField(BulletinInfo_info.cUserID, value); } 
        }

    }
    #endregion

}