public static bool SaveCompanyModule(Foresight.DataAccess.Company company, out string errormsg)
{
errormsg = string.Empty;
try
{
var sys_menus = Foresight.DataAccess.SysMenu.GetSysModulesByCompany(company.CompanyID);
List <CompanyModuleModel> modellist = new List <CompanyModuleModel>();
foreach (var item in sys_menus)
{
Encript.CompanyModuleModel model = new CompanyModuleModel();
model.CompanyID = company.CompanyID;
model.ModuleID = item.ID;
modellist.Add(model);
}
Encript.SqlLite.InsertCompanyModule(modellist.ToArray(), company.CompanyID);
errormsg = "";
return(true);
}
catch (Exception ex)
{
LogHelper.WriteError("SqlLiteHelper", "SaveCompanyModule", ex);
errormsg = "内部异常";
return(false);
}
}
/// <summary>
/// 删除企业的功能模块
/// </summary>
/// <param name="Model"></param>
/// <returns></returns>
public static int DelCompanyModule(CompanyModuleModel Model)
{
string sql = "Delete from pubdba.CompanyModule where CompanyCD=@CompanyCD and ModuleID=@ModuleID";
SqlParameter[] parms = new SqlParameter[2];
parms[0] = SqlHelper.GetParameter("@CompanyCD", Model.CompanyCD);
parms[1] = SqlHelper.GetParameter("@ModuleID", Model.ModuleID);
return(SqlHelper.ExecuteTransSql(sql, parms));
}
/// <summary>
/// 删除企业的功能模块
/// </summary>
public static int DelCompanyModule(CompanyModuleModel Model)
{
if (Model == null)
{
return(0);
}
try
{
return(CompanyModuleDBHelper.DelCompanyModule(Model));
}
catch (System.Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
string CompanyCD = Request.QueryString["CompanyCD"];
if (CompanyCD != "")
{
CompanyModuleModel Model = new CompanyModuleModel();
Model.CompanyCD = CompanyCD;
//获取所有功能模块信息
DataTable DataTable = CompanyModBus.GetSysModuleInfo();
//生成tree
string ScriptShow = "<script type=\"text/javascript\">";
ScriptShow += "var rows = new Object;";
ScriptShow += "var rowsPidIndex = new Object;";
ScriptShow += "rows={";
ArrayList rowsPidIndex = new ArrayList();
//显示所有功能模块信息
for (int i = 0; i < DataTable.Rows.Count; i++)
{
DataRow row = DataTable.Rows[i];
ScriptShow += "'" + row["ModuleID"].ToString() + "' : {'id':'" + row["ModuleID"].ToString() + "', 'pid':'" + row["ParentID"].ToString() + "', 'title':'" + row["ModuleName"].ToString() + "' }";
if (i < DataTable.Rows.Count - 1)
{
ScriptShow += ",";
}
//父节点
if (row["ModuleType"].ToString() == "S")
{
rowsPidIndex.Add(row["ModuleID"].ToString());
}
}
ScriptShow += "};";
//初始化顶级目录
ScriptShow += "rowsPidIndex[0] = new Array(";
ScriptShow += getChildNode("0", DataTable);
ScriptShow += ") ; ";
//初始化父节点
for (int i = 0; i < rowsPidIndex.Count; i++)
{
ScriptShow += "rowsPidIndex[" + rowsPidIndex[i].ToString() + "] = new Array(";
ScriptShow += getChildNode(rowsPidIndex[i].ToString(), DataTable);
ScriptShow += ") ; ";
}
ScriptShow += "</script>";
LblScriptShow.Text = ScriptShow;
//获取该企业的所有模块信息
DataTable CompanyModuleInfo = CompanyModBus.GetCompanyModuleInfo(CompanyCD);
//生成被选择项
string checkBoxCheckedTemp = ",";
for (int i = 0; i < CompanyModuleInfo.Rows.Count; i++)
{
DataRow row = CompanyModuleInfo.Rows[i];
checkBoxCheckedTemp += row["ModuleID"].ToString() + ",";
}
string checkBoxChecked = "";
checkBoxChecked += "<input type='hidden' id='CompanyCD' name='CompanyCD' value='" + CompanyCD + "'>";
checkBoxChecked += "<script>";
checkBoxChecked += "var ctree = new treeCheckBox( 'ctree' , rows , rowsPidIndex ); ";
checkBoxChecked += "ctree.iconPath='../../js/dtree/images/';";
checkBoxChecked += "ctree.useCheckBox=true;";
checkBoxChecked += "ctree.checkBoxName='menu[]';";
checkBoxChecked += "ctree.checkBoxChecked='" + checkBoxCheckedTemp + "';";
checkBoxChecked += "ctree.toString( Tc );";
checkBoxChecked += "</script>";
LblcheckBoxChecked.Text = checkBoxChecked;
}
}
