protected void btnSave_Click(object sender, EventArgs e) { Maticsoft.BLL.CMS.PhotoClass class2 = new Maticsoft.BLL.CMS.PhotoClass(); if (string.IsNullOrWhiteSpace(this.txtClassName.Text)) { MessageBox.ShowFailTip(this, CMSPhoto.ErrorClassNameNull); } else if (string.IsNullOrWhiteSpace(this.txtClassName.Text)) { MessageBox.ShowFailTip(this, CMSPhoto.ErrorClassNameNull); } else if (class2.ExistsByClassName(this.txtClassName.Text)) { MessageBox.ShowFailTip(this, CMSPhoto.ErrorClassRepeat); } else if (!PageValidate.IsNumber(this.txtSequence.Text)) { MessageBox.ShowFailTip(this, CMSPhoto.ErrorOrderFormat); } else { int num3; string text = this.txtClassName.Text; int classID = 0; if (!string.IsNullOrWhiteSpace(this.ddlPhotoClass.SelectedValue)) { classID = int.Parse(this.ddlPhotoClass.SelectedValue); } int num2 = int.Parse(this.txtSequence.Text); Maticsoft.Model.CMS.PhotoClass model = class2.GetModel(classID); string str2 = string.Empty; if (model != null) { str2 = model.Path + classID + "|"; num3 = model.Depth.Value + 1; } else { str2 = "0|"; num3 = 1; } Maticsoft.Model.CMS.PhotoClass class6 = new Maticsoft.Model.CMS.PhotoClass { ClassName = text, ParentId = new int?(classID), Sequence = new int?(num2), Path = str2, Depth = new int?(num3) }; Maticsoft.Model.CMS.PhotoClass class4 = class6; new Maticsoft.BLL.CMS.PhotoClass().Add(class4); MessageBox.ResponseScript(this, "parent.location.href='List.aspx'"); } }
public List<Maticsoft.Model.CMS.PhotoClass> DataTableToList(DataTable dt) { List<Maticsoft.Model.CMS.PhotoClass> list = new List<Maticsoft.Model.CMS.PhotoClass>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Maticsoft.Model.CMS.PhotoClass item = new Maticsoft.Model.CMS.PhotoClass(); if ((dt.Rows[i]["ClassID"] != null) && (dt.Rows[i]["ClassID"].ToString() != "")) { item.ClassID = int.Parse(dt.Rows[i]["ClassID"].ToString()); } if ((dt.Rows[i]["ClassName"] != null) && (dt.Rows[i]["ClassName"].ToString() != "")) { item.ClassName = dt.Rows[i]["ClassName"].ToString(); } if ((dt.Rows[i]["ParentId"] != null) && (dt.Rows[i]["ParentId"].ToString() != "")) { item.ParentId = new int?(int.Parse(dt.Rows[i]["ParentId"].ToString())); } if ((dt.Rows[i]["Sequence"] != null) && (dt.Rows[i]["Sequence"].ToString() != "")) { item.Sequence = new int?(int.Parse(dt.Rows[i]["Sequence"].ToString())); } if ((dt.Rows[i]["Path"] != null) && (dt.Rows[i]["Path"].ToString() != "")) { item.Path = dt.Rows[i]["Path"].ToString(); } if ((dt.Rows[i]["Depth"] != null) && (dt.Rows[i]["Depth"].ToString() != "")) { item.Depth = new int?(int.Parse(dt.Rows[i]["Depth"].ToString())); } list.Add(item); } } return list; }
public Maticsoft.Model.CMS.PhotoClass GetModel(int ClassID) { StringBuilder builder = new StringBuilder(); builder.Append("select top 1 ClassID,ClassName,ParentId,Sequence,Path,Depth from CMS_PhotoClass "); builder.Append(" where ClassID=@ClassID "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ClassID", SqlDbType.Int, 4) }; cmdParms[0].Value = ClassID; Maticsoft.Model.CMS.PhotoClass class2 = new Maticsoft.Model.CMS.PhotoClass(); DataSet set = DbHelperSQL.Query(builder.ToString(), cmdParms); if (set.Tables[0].Rows.Count <= 0) { return null; } if ((set.Tables[0].Rows[0]["ClassID"] != null) && (set.Tables[0].Rows[0]["ClassID"].ToString() != "")) { class2.ClassID = int.Parse(set.Tables[0].Rows[0]["ClassID"].ToString()); } if ((set.Tables[0].Rows[0]["ClassName"] != null) && (set.Tables[0].Rows[0]["ClassName"].ToString() != "")) { class2.ClassName = set.Tables[0].Rows[0]["ClassName"].ToString(); } if ((set.Tables[0].Rows[0]["ParentId"] != null) && (set.Tables[0].Rows[0]["ParentId"].ToString() != "")) { class2.ParentId = new int?(int.Parse(set.Tables[0].Rows[0]["ParentId"].ToString())); } if ((set.Tables[0].Rows[0]["Sequence"] != null) && (set.Tables[0].Rows[0]["Sequence"].ToString() != "")) { class2.Sequence = new int?(int.Parse(set.Tables[0].Rows[0]["Sequence"].ToString())); } if ((set.Tables[0].Rows[0]["Path"] != null) && (set.Tables[0].Rows[0]["Path"].ToString() != "")) { class2.Path = set.Tables[0].Rows[0]["Path"].ToString(); } if ((set.Tables[0].Rows[0]["Depth"] != null) && (set.Tables[0].Rows[0]["Depth"].ToString() != "")) { class2.Depth = new int?(int.Parse(set.Tables[0].Rows[0]["Depth"].ToString())); } return class2; }