/// <summary> /// 添加项目类目 /// </summary> /// <param name="category"></param> public void addProjectCategory(ProjectCategory category) { try { string commandString = "INSERT INTO usta_ProjectCategory (name, categoryLevel, parendId, memo, createdTime) VALUES(@name, @categoryLevel, @parendId, @memo, @createdTime)"; SqlParameter[] parameters = new SqlParameter[]{ new SqlParameter("@name", category.name), new SqlParameter("@categoryLevel", category.categoryLevel), new SqlParameter("@parendId", category.parentId), new SqlParameter("@memo", category.memo), new SqlParameter("@createdTime", DateTime.Now) }; SqlHelper.ExecuteNonQuery(conn, CommandType.Text, commandString, parameters); } catch (Exception ex) { MongoDBLog.LogRecord(ex); CommonUtility.RedirectUrl(); } finally { conn.Close(); } }
protected void btn_AddProjectCategory_Click(object sender, EventArgs e) { string categoryName = this.CatagoryName.Text.Trim(); string categoryDesc = this.CategoryDesc.Text.Trim(); if ("修改" == this.btn_AddProjectCategory.Text.Trim()) { int cid = int.Parse(this.hf_CategoryId.Value.Trim()); ProjectCategory projectCategory = dalpc.GetProjectCategoryById(cid); projectCategory.name = categoryName; projectCategory.memo = categoryDesc; dalpc.UpdateProjectCategory(projectCategory); } else { string parendId; int categoryLevel; if (this.RootCategoryList.SelectedValue == "0") { parendId = "0"; categoryLevel = 1; } else { if (this.SubCategoryList.SelectedValue == "0") { parendId = this.RootCategoryList.SelectedValue; categoryLevel = 2; } else { parendId = this.SubCategoryList.SelectedValue; categoryLevel = 3; } } ProjectCategory projectCategory = new ProjectCategory(); projectCategory.name = categoryName; projectCategory.memo = categoryDesc; projectCategory.parentId = int.Parse(parendId); projectCategory.categoryLevel = categoryLevel; dalpc.addProjectCategory(projectCategory); } Javascript.Alert("操作成功", Page); Javascript.RefreshParentWindowReload(Page); }
private void BuildProjects(IDataReader reader, List<Project> projects) { Project project; while (reader.Read()) { project = new Project(); project.id = int.Parse(reader["id"].ToString().Trim()); project.name = reader["name"].ToString().Trim(); ProjectCategory category = new ProjectCategory(); category.id = int.Parse(reader["categoryId"].ToString().Trim()); category.name = reader["categoryName"].ToString().Trim(); project.category = category; project.userName = reader["userName"].ToString().Trim(); project.userNo = reader["userNo"].ToString().Trim(); project.memo = reader["memo"].ToString().Trim(); project.createdTime = DateTime.Parse(reader["createdTime"].ToString().Trim()); projects.Add(project); } }
private void GetAllLastProjceCategoryByParendCategory(ProjectCategory projectCategory, List<ProjectCategory> resultList) { List<ProjectCategory> categoryList = GetProjectCategoryByParendId(projectCategory.id); if (categoryList.Count == 0) { resultList.Add(projectCategory); } else { foreach (ProjectCategory category in categoryList) { GetAllLastProjceCategoryByParendCategory(category, resultList); } } }
private void BuildProjectCategory(IDataReader reader, List<ProjectCategory> categoryList) { ProjectCategory category; while (reader.Read()) { category = new ProjectCategory(); category.id = int.Parse(reader["id"].ToString().Trim()); category.name = reader["name"].ToString().Trim(); category.categoryLevel = int.Parse(reader["categoryLevel"].ToString().Trim()); category.parentId = int.Parse(reader["parendId"].ToString().Trim()); category.memo = reader["memo"].ToString().Trim(); category.createdTime = DateTime.Parse(reader["createdTime"].ToString().Trim()); categoryList.Add(category); } }
/// <summary> /// /// </summary> /// <param name="projectCategory"></param> public void UpdateProjectCategory(ProjectCategory projectCategory) { try { string commandString = "UPDATE usta_ProjectCategory SET name = @name, categoryLevel = @categoryLevel, parendId = @parendId, memo = @memo WHERE id = @id"; SqlParameter[] parameters = new SqlParameter[]{ new SqlParameter("@name", projectCategory.name), new SqlParameter("@categoryLevel", projectCategory.categoryLevel), new SqlParameter("@parendId", projectCategory.parentId), new SqlParameter("@memo", projectCategory.memo), new SqlParameter("@id", projectCategory.id) }; SqlHelper.ExecuteNonQuery(conn, CommandType.Text, commandString, parameters); } catch (Exception ex) { MongoDBLog.LogRecord(ex); CommonUtility.RedirectUrl(); } finally { conn.Close(); } }