在线日记系统设计

前段时间为了练手，自己设计了一个仿QQ邮箱日历 的在线日记系统

前台采用CSS+HTML+Javascript实现 

后端用的 是 MVC+DBMapper 实现

Vs2010+SQLServer2008开发的

 

核心部分如下：

 

用户登录

日历查看

 

农历查看（状态栏下方显示鼠标停放 的日期的农历）

 

日记编辑（点击日期编辑日记）

 

记事标注（有日记的日期做了淡黄色标注）

 

部分代码：

   ReFill: function () {//用最后一次填充的年月再次填充
        this.Fill(this.last_Year_Month);
    },
    Fill: function (s_d) {//参数必须是2015-9-1  格式  某个月的第一天 好确定 从哪个单元格开始绑定数字 到哪个单元格结束
        var table = document.getElementById(this.id);
        var ndate1 = this.getFormatDay(s_d);
        var todayDate = this.getFormatDay();
        var curday = 1;
        var maxday = this.monthDays[ndate1.Month];
        if (ndate1.Month === 1) {
            if ((ndate1.Year % 100 != 0 && ndate1.Year % 4 === 0) || ndate1.Year % 400 === 0) {
                maxday = 29;

            }

        }
        for (var i = 1; i < table.rows.length; i++)
            for (var j = 0; j < table.rows[i].cells.length; j++) {
                table.rows[i].cells[j].className = '';
                table.rows[i].cells[j].setAttribute('data', '');
                table.rows[i].cells[j].onmouseover = null;
                table.rows[i].cells[j].onmouseout = null;
                table.rows[i].cells[j].onclick = null;//清理上次填充时 加载的事件和属性 以免影响本次

                if ((i === 1) && (j < parseInt(ndate1.Week, 10))) {
                    table.rows[i].cells[j].innerHTML = ' ';

                }
                else {
                    if (curday > maxday) {
                        table.rows[i].cells[j].innerHTML = ' ';
                    }
                    else {
                        if (todayDate.Year === ndate1.Year && todayDate.Month === ndate1.Month && todayDate.Date0 === curday) {
                            table.rows[i].cells[j].className = 'today-cell';
                        }
                        table.rows[i].cells[j].setAttribute('data', ndate1.Year + '-' + (ndate1.Month + 1) + '-' + curday);
                        table.rows[i].cells[j].innerHTML = curday + '<br/><span class="nongli-cell">'
                  + nongli.GetLunarDay(ndate1.Year, (ndate1.Month + 1), curday).CDay + '</span>';
                        curday++;
                        var b = this;
                        //显示农历鼠标移入移除事件
                        table.rows[i].cells[j].onmouseover = function () {
                            var selectDate = this.getAttribute('data');
                            var de = selectDate.split('-');
                            var nong = nongli.GetLunarDay(parseInt(de[0]), parseInt(de[1]), parseInt(de[2]));
                            document.getElementById(b.longli).innerHTML = '农历' + nong.CMonth + nong.CDay;
                        }
                        table.rows[i].cells[j].onmouseout = function () {

                            document.getElementById(b.longli).innerHTML = '';
                        }

                        table.rows[i].cells[j].onclick = function () {
                            var selectDate = this.getAttribute('data');
                            if (b.onDateCellClick instanceof Function)
                            { b.onDateCellClick(selectDate); }
                        }
                    }
                }
            }
        this.last_Year_Month = ndate1.Year + '-' + (ndate1.Month + 1) + '-1';
        this.selectNotedDates(this.last_Year_Month);
    },
    dateChange: function () {
        var IndexMonth = document.getElementById(this.selectMonth).selectedIndex;
        var month = document.getElementById(this.selectMonth).options[IndexMonth].value;


        var IndexYear = document.getElementById(this.selectYear).selectedIndex;
        var year = document.getElementById(this.selectYear).options[IndexYear].value;

        this.Fill(year + '-' + month + '-1');
    },

 

 

    public class NoteEntity:IDbTableNaming
    {
        [PrimaryKey]
        public int? Id { get; set; }
        public int? UserNameId { get; set; }
        public string Title { get; set; }
        public string NoteTime { get; set; }
        public string Content { get; set; }
        string IDbTableNaming.DBTableName//显示实现接口
        {
            get { return "Note"; }
        }
    }


        IDbMapper db = DbMapper.CreateDbMapper(DbMapper.PROVIDER_SQLSERVER, null);
        public NoteEntity GetNote(int userId, string date)
        {
            List<NoteEntity> lst = db.Query<NoteEntity>("select Id,UserNameId,Title,NoteTime,Content from Note where UserNameId=@UserNameId and CONVERT(varchar(100),NoteTime,23)=@NoteTime",
                new NoteEntity(){
                   UserNameId=userId,
                   NoteTime=Convert.ToDateTime(date).ToString("yyyy-MM-dd")//把 2015-9-4 转换为 2015-09-04
                }).ToList();
            if(lst.Count>0){return lst[0];}
            else{return null;}
        }

        public bool DeleteNote(string date,int userId) { 
            List<NoteEntity> lst = db.Query<NoteEntity>("select Id,UserNameId,Title,NoteTime,Content from Note where UserNameId=@UserNameId and CONVERT(varchar(100),NoteTime,23)=@NoteTime",
                new NoteEntity()
                {
                    UserNameId = userId,
                    NoteTime = Convert.ToDateTime(date).ToString("yyyy-MM-dd")//把 2015-9-4 转换为 2015-09-04
                }).ToList();
            if (lst.Count > 0)
            {
                db.Delete<NoteEntity>(new NoteEntity() { 
                  Id=lst[0].Id
                });
                return (db.Execute() > 0);
            }
            else {
                return false;
            }
        }