/// <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> 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; }
public bool BasModuleUpdate(BasModule model) { return dal.BasModuleUpdate(model); }
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); }