Exemplo n.º 1
0
        //public Model.ProjectModel GetProject(Model.ProjectModel project)
        //{
        //    StringBuilder sbQueryProjectSQL = new StringBuilder("select id,name,saveinterval,savepath from project where id=" + project.ID);
        //    System.Data.DataTable dt = _databaseService.GetDataTableBySQL(sbQueryProjectSQL);
        //    Model.ProjectModel model = new Model.ProjectModel();
        //    model.ID = Convert.ToInt16(dt.Rows[0]["id"]);
        //    model.Name = dt.Rows[0]["name"].ToString();
        //    model.SavePath = dt.Rows[0]["savepath"] is System.DBNull ? null : dt.Rows[0]["savepath"].ToString();
        //    model.SaveInterval = dt.Rows[0]["saveinterval"] is System.DBNull ? 0 : Convert.ToInt16(dt.Rows[0]["saveinterval"]);
        //    return model;
        //}

        public int AddProject(Model.ProjectModel project)
        {
            //StringBuilder sbProjectSQL;
            //if (project.ID == 0) //在目前软件中,一次仅可管理一个项目信息,后续如有扩展,可将此逻辑拆分至UpdateProject中
            //{
            //    sbProjectSQL = new StringBuilder("Insert into Project(Name,savepath,saveinterval) values(\"");
            //    sbProjectSQL.Append(project.Name + "\",\"");
            //    sbProjectSQL.Append(project.SavePath + "\",");
            //    sbProjectSQL.Append(project.SaveInterval + ");");
            //}
            //else
            //{
            //    sbProjectSQL = new StringBuilder("Replace into Project(ID,Name,savepath,saveinterval) values(\"");
            //    sbProjectSQL.Append(project.ID + "\",\"");
            //    sbProjectSQL.Append(project.Name + "\",\"");
            //    sbProjectSQL.Append(project.SavePath + "\",");
            //    sbProjectSQL.Append(project.SaveInterval + ");");
            //}
            //return _databaseService.ExecuteBySql(sbProjectSQL);
            return(_dbFileVersionService.AddProject(project));
        }