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