public List <PEIS.Model.SysMenu> DataTableToList(DataTable dt)
{
List <PEIS.Model.SysMenu> list = new List <PEIS.Model.SysMenu>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
PEIS.Model.SysMenu sysMenu = new PEIS.Model.SysMenu();
if (dt.Rows[i]["MenuID"].ToString() != "")
{
sysMenu.MenuID = int.Parse(dt.Rows[i]["MenuID"].ToString());
}
sysMenu.MenuName = dt.Rows[i]["MenuName"].ToString();
if (dt.Rows[i]["ID_ParentMenu"].ToString() != "")
{
sysMenu.ParentID = new int?(int.Parse(dt.Rows[i]["ParentID"].ToString()));
}
sysMenu.Url = dt.Rows[i]["Url"].ToString();
//if (dt.Rows[i]["CreateDate"].ToString() != "")
//{
// sysMenu.CreateDate = new DateTime?(DateTime.Parse(dt.Rows[i]["CreateDate"].ToString()));
//}
//if (dt.Rows[i]["UpdateDate"].ToString() != "")
//{
// sysMenu.UpdateDate = new DateTime?(DateTime.Parse(dt.Rows[i]["UpdateDate"].ToString()));
//}
if (dt.Rows[i]["DispOrder"].ToString() != "")
{
sysMenu.DispOrder = new int?(int.Parse(dt.Rows[i]["DispOrder"].ToString()));
}
sysMenu.RightCode = dt.Rows[i]["RightCode"].ToString();
//if (dt.Rows[i]["ID_Operator"].ToString() != "")
//{
// sysMenu.ID_Operator = new int?(int.Parse(dt.Rows[i]["ID_Operator"].ToString()));
//}
if (dt.Rows[i]["Is_CombineWithSection"].ToString() != "")
{
if (dt.Rows[i]["Is_CombineWithSection"].ToString() == "1" || dt.Rows[i]["Is_CombineWithSection"].ToString().ToLower() == "true")
{
sysMenu.Is_CombineWithSection = true;
}
else
{
sysMenu.Is_CombineWithSection = false;
}
}
list.Add(sysMenu);
}
}
return(list);
}
public PEIS.Model.SysMenu DataRowToModel(DataRow row)
{
PEIS.Model.SysMenu model = new PEIS.Model.SysMenu();
if (row != null)
{
if (row["MenuID"] != null && row["MenuID"].ToString() != "")
{
model.MenuID = int.Parse(row["MenuID"].ToString());
}
if (row["MenuName"] != null)
{
model.MenuName = row["MenuName"].ToString();
}
if (row["ParentID"] != null && row["ParentID"].ToString() != "")
{
model.ParentID = int.Parse(row["ParentID"].ToString());
}
if (row["Url"] != null)
{
model.Url = row["Url"].ToString();
}
if (row["DispOrder"] != null && row["DispOrder"].ToString() != "")
{
model.DispOrder = int.Parse(row["DispOrder"].ToString());
}
if (row["MenuLevel"] != null && row["MenuLevel"].ToString() != "")
{
model.MenuLevel = int.Parse(row["MenuLevel"].ToString());
}
if (row["RightCode"] != null)
{
model.RightCode = row["RightCode"].ToString();
}
if (row["Is_CombineWithSection"] != null && row["Is_CombineWithSection"].ToString() != "")
{
if ((row["Is_CombineWithSection"].ToString() == "1") || (row["Is_CombineWithSection"].ToString().ToLower() == "true"))
{
model.Is_CombineWithSection = true;
}
else
{
model.Is_CombineWithSection = false;
}
}
}
return(model);
}
public bool Update(PEIS.Model.SysMenu model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SysMenu set ");
strSql.Append("MenuName=@MenuName,");
strSql.Append("ParentID=@ParentID,");
strSql.Append("Url=@Url,");
strSql.Append("DispOrder=@DispOrder,");
strSql.Append("MenuLevel=@MenuLevel,");
strSql.Append("RightCode=@RightCode,");
strSql.Append("Is_CombineWithSection=@Is_CombineWithSection");
strSql.Append(" where MenuID=@MenuID ");
SqlParameter[] parameters =
{
new SqlParameter("@MenuName", SqlDbType.VarChar, 60),
new SqlParameter("@ParentID", SqlDbType.Int, 4),
new SqlParameter("@Url", SqlDbType.VarChar, 200),
new SqlParameter("@DispOrder", SqlDbType.Int, 4),
new SqlParameter("@MenuLevel", SqlDbType.Int, 4),
new SqlParameter("@RightCode", SqlDbType.VarChar, 80),
new SqlParameter("@Is_CombineWithSection", SqlDbType.Bit, 1),
new SqlParameter("@MenuID", SqlDbType.Int, 4)
};
parameters[0].Value = model.MenuName;
parameters[1].Value = model.ParentID;
parameters[2].Value = model.Url;
parameters[3].Value = model.DispOrder;
parameters[4].Value = model.MenuLevel;
parameters[5].Value = model.RightCode;
parameters[6].Value = model.Is_CombineWithSection;
parameters[7].Value = model.MenuID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public int Add(PEIS.Model.SysMenu model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SysMenu(");
strSql.Append("MenuID,MenuName,ParentID,Url,DispOrder,MenuLevel,RightCode,Is_CombineWithSection)");
strSql.Append(" values (");
strSql.Append("@MenuID,@MenuName,@ParentID,@Url,@DispOrder,@MenuLevel,@RightCode,@Is_CombineWithSection)");
SqlParameter[] parameters =
{
new SqlParameter("@MenuID", SqlDbType.Int, 4),
new SqlParameter("@MenuName", SqlDbType.VarChar, 60),
new SqlParameter("@ParentID", SqlDbType.Int, 4),
new SqlParameter("@Url", SqlDbType.VarChar, 200),
new SqlParameter("@DispOrder", SqlDbType.Int, 4),
new SqlParameter("@MenuLevel", SqlDbType.Int, 4),
new SqlParameter("@RightCode", SqlDbType.VarChar, 80),
new SqlParameter("@Is_CombineWithSection", SqlDbType.Bit, 1)
};
parameters[0].Value = model.MenuID;
parameters[1].Value = model.MenuName;
parameters[2].Value = model.ParentID;
parameters[3].Value = model.Url;
parameters[4].Value = model.DispOrder;
parameters[5].Value = model.MenuLevel;
parameters[6].Value = model.RightCode;
parameters[7].Value = model.Is_CombineWithSection;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(0);
}
else
{
return(1);
}
}
public PEIS.Model.SysMenu GetModel(int MenuID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 MenuID,MenuName,ParentID,Url,DispOrder,MenuLevel,RightCode,Is_CombineWithSection from SysMenu ");
strSql.Append(" where MenuID=@MenuID ");
SqlParameter[] parameters =
{
new SqlParameter("@MenuID", SqlDbType.Int, 4)
};
parameters[0].Value = MenuID;
PEIS.Model.SysMenu model = new PEIS.Model.SysMenu();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public bool Update(PEIS.Model.SysMenu model)
{
return(this.dal.Update(model));
}
public int Add(PEIS.Model.SysMenu model)
{
return(this.dal.Add(model));
}
