//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)); }