public List<Maticsoft.Model.CMS.VideoClass> DataTableToList(DataTable dt)
{
List<Maticsoft.Model.CMS.VideoClass> list = new List<Maticsoft.Model.CMS.VideoClass>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Maticsoft.Model.CMS.VideoClass item = new Maticsoft.Model.CMS.VideoClass();
if ((dt.Rows[i]["VideoClassID"] != null) && (dt.Rows[i]["VideoClassID"].ToString() != ""))
{
item.VideoClassID = int.Parse(dt.Rows[i]["VideoClassID"].ToString());
}
if ((dt.Rows[i]["VideoClassName"] != null) && (dt.Rows[i]["VideoClassName"].ToString() != ""))
{
item.VideoClassName = dt.Rows[i]["VideoClassName"].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 = 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 = int.Parse(dt.Rows[i]["Depth"].ToString());
}
list.Add(item);
}
}
return list;
}
protected void btnSave_Click(object sender, EventArgs e)
{
string str = this.txtVideoClassName.Text.Trim();
string msg = "";
if (this.txtVideoClassName.Text.Trim().Length == 0)
{
msg = msg + CMSVideo.ErrorClassNameNull + @"\n";
}
if (msg != "")
{
MessageBox.Show(this, msg);
}
else
{
Maticsoft.Model.CMS.VideoClass model = new Maticsoft.Model.CMS.VideoClass {
VideoClassName = str,
ParentID = new int?(Globals.SafeInt(this.VideoClassDropList1.SelectedValue, 0))
};
if (this.bll.AddEx(model) > 0)
{
if (this.chkAddContinue.Checked)
{
this.txtVideoClassName.Text = "";
MessageBox.ShowSuccessTip(this, Site.TooltipSaveOK);
}
else
{
MessageBox.ResponseScript(this, "parent.location.href='List.aspx'");
}
}
else
{
MessageBox.ShowFailTip(this, Site.TooltipSaveError);
}
}
}
public Maticsoft.Model.CMS.VideoClass GetModelByParentID(int ParentID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select top 1 VideoClassID,VideoClassName,ParentID,Sequence,Path,Depth from CMS_VideoClass ");
builder.Append(" where VideoClassID=@ParentID");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ParentID", SqlDbType.Int, 4) };
cmdParms[0].Value = ParentID;
Maticsoft.Model.CMS.VideoClass class2 = new Maticsoft.Model.CMS.VideoClass();
DataSet ds = DbHelperSQL.Query(builder.ToString(), cmdParms);
if (DataSetTools.DataSetIsNull(ds))
{
return null;
}
if (ds.Tables[0].Rows.Count <= 0)
{
return null;
}
if ((ds.Tables[0].Rows[0]["VideoClassID"] != null) && (ds.Tables[0].Rows[0]["VideoClassID"].ToString() != ""))
{
class2.VideoClassID = int.Parse(ds.Tables[0].Rows[0]["VideoClassID"].ToString());
}
if ((ds.Tables[0].Rows[0]["VideoClassName"] != null) && (ds.Tables[0].Rows[0]["VideoClassName"].ToString() != ""))
{
class2.VideoClassName = ds.Tables[0].Rows[0]["VideoClassName"].ToString();
}
if ((ds.Tables[0].Rows[0]["ParentID"] != null) && (ds.Tables[0].Rows[0]["ParentID"].ToString() != ""))
{
class2.ParentID = new int?(int.Parse(ds.Tables[0].Rows[0]["ParentID"].ToString()));
}
if ((ds.Tables[0].Rows[0]["Sequence"] != null) && (ds.Tables[0].Rows[0]["Sequence"].ToString() != ""))
{
class2.Sequence = int.Parse(ds.Tables[0].Rows[0]["Sequence"].ToString());
}
if ((ds.Tables[0].Rows[0]["Path"] != null) && (ds.Tables[0].Rows[0]["Path"].ToString() != ""))
{
class2.Path = ds.Tables[0].Rows[0]["Path"].ToString();
}
if ((ds.Tables[0].Rows[0]["Depth"] != null) && (ds.Tables[0].Rows[0]["Depth"].ToString() != ""))
{
class2.Depth = int.Parse(ds.Tables[0].Rows[0]["Depth"].ToString());
}
return class2;
}
