/// <summary>
/// 更新一条数据
/// </summary>
public bool BasModuleUpdate(BasModule model)
{
StringBuilder strb = new StringBuilder();
strb.Append(" Update Bas_Module ");
strb.Append(" Set ");
//strb.Append("module_id = " + model.ModuleId + ",");
strb.Append("module_father = " + model.ModuleFather + ",");
strb.Append("module_code = '" + model.ModuleCode + "',");
strb.Append("module_name = '" + model.ModuleName + "',");
strb.Append("module_icon = '" + model.ModuleIcon + "',");
strb.Append("module_width = " + model.ModuleWidth + ",");
strb.Append("module_height = " + model.ModuleHeight + ",");
strb.Append("module_url = '" + model.ModuleUrl + "',");
strb.Append("module_sort = '" + model.ModuleSort + "',");
strb.Append("enable_flag = '" + model.EnableFlag + "',");
strb.Append("toolbar_flag = '" + model.ToolbarFlag + "',");
strb.Append("module_purview = '" + model.ModulePurview + "'");
strb.Append(" where module_id = " + model.ModuleId);
return(DataBase.ExecuteNonQuery(strb.ToString()) > 0 ? true : false);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool BasModuleAdd(BasModule model)
{
StringBuilder strb = new StringBuilder();
strb.Append(" Insert Into Bas_Module ");
strb.Append(" ( ");
//strb.Append("module_id, ");
strb.Append("module_father, ");
strb.Append("module_code, ");
strb.Append("module_name, ");
strb.Append("module_icon, ");
strb.Append("module_width, ");
strb.Append("module_height, ");
strb.Append("module_url, ");
strb.Append("module_sort, ");
strb.Append("enable_flag, ");
strb.Append("toolbar_flag, ");
strb.Append("module_purview ");
strb.Append(" )");
strb.Append(" Values( ");
//strb.Append("" + model.ModuleId + ", ");
strb.Append("" + model.ModuleFather + ", ");
strb.Append("'" + model.ModuleCode + "', ");
strb.Append("'" + model.ModuleName + "', ");
strb.Append("'" + model.ModuleIcon + "', ");
strb.Append("" + model.ModuleWidth + ", ");
strb.Append("" + model.ModuleHeight + ", ");
strb.Append("'" + model.ModuleUrl + "', ");
strb.Append("'" + model.ModuleSort + "', ");
strb.Append("'" + model.EnableFlag + "', ");
strb.Append("'" + model.ToolbarFlag + "', ");
strb.Append("'" + model.ModulePurview + "' ");
strb.Append(" )");
return(DataBase.ExecuteNonQuery(strb.ToString()) > 0 ? true : false);
}
/// <summary>
/// 获得数据详细信息
/// </summary>
#region 获得数据详细信息
public BasModule BasModuleDetail(string id)
{
BasModule model = new BasModule();
string strSql = " select * from Bas_Module where module_id=" + id;
DataRow dr = DataBase.ExecuteDataRow(strSql);
model.ModuleId = dr["module_id"].ToString().Trim();
model.ModuleFather = dr["module_father"].ToString().Trim();
model.ModuleCode = dr["module_code"].ToString().Trim();
model.ModuleName = dr["module_name"].ToString().Trim();
model.ModuleIcon = dr["module_icon"].ToString().Trim();
model.ModuleWidth = dr["module_width"].ToString().Trim();
model.ModuleHeight = dr["module_height"].ToString().Trim();
model.ModuleUrl = dr["module_url"].ToString().Trim();
model.ModuleSort = dr["module_sort"].ToString().Trim();
model.EnableFlag = dr["enable_flag"].ToString().Trim();
model.ToolbarFlag = dr["toolbar_flag"].ToString().Trim();
model.ModulePurview = dr["module_purview"].ToString().Trim();
return(model);
}
public bool BasModuleAdd(BasModule model)
{
return(dal.BasModuleAdd(model));
}
public bool BasModuleUpdate(BasModule model)
{
return(dal.BasModuleUpdate(model));
}
