/// <summary> /// 合并或是拆分列 /// </summary> private void SplitOrMerger(int targenum) { int original = 0; string str = " founderid=" + ((EtNet_Models.LoginInfo)Session["login"]).Id; DataTable tbl = EtNet_BLL.PanelMenuRecordManager.GetList(str); if (tbl.Rows.Count == 1) { original = int.Parse(tbl.Rows[0]["totalcols"].ToString()); if (JudgeIsMerger(original, targenum)) { MergerDataList(targenum); } else { } //更改面板菜单记录数据 EtNet_Models.PanelMenuRecord model = new EtNet_Models.PanelMenuRecord(); model.id = int.Parse(tbl.Rows[0]["id"].ToString()); model.founderid = int.Parse(tbl.Rows[0]["founderid"].ToString()); model.totalcols = targenum; model.userempty = tbl.Rows[0]["userempty"].ToString(); EtNet_BLL.PanelMenuRecordManager.Update(model); LoadPanelMenuData(); } else { string msg = "<script>jNotify('无法更改!',{ ShowOverlay: true, AutoHide: true,"; msg += "VerticalPosition: 'center', HorizontalPosition:'center'});</script>"; Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), " spinoffs", msg, false); } }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(EtNet_Models.PanelMenuRecord model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PanelMenuRecord set "); strSql.Append("founderid=@founderid,"); strSql.Append("totalcols=@totalcols,"); strSql.Append("userempty=@userempty"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@founderid", SqlDbType.Int, 4), new SqlParameter("@totalcols", SqlDbType.Int, 4), new SqlParameter("@userempty", SqlDbType.VarChar, 10), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.founderid; parameters[1].Value = model.totalcols; parameters[2].Value = model.userempty; parameters[3].Value = model.id; int result = EtNet_DAL.DBHelper.ExecuteCommand(strSql.ToString(), parameters); if (result >= 1) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public static bool Add(EtNet_Models.PanelMenuRecord model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PanelMenuRecord("); strSql.Append("founderid,totalcols,userempty)"); strSql.Append(" values ("); strSql.Append("@founderid,@totalcols,@userempty)"); SqlParameter[] parameters = { new SqlParameter("@founderid", SqlDbType.Int, 4), new SqlParameter("@totalcols", SqlDbType.Int, 4), new SqlParameter("@userempty", SqlDbType.VarChar, 10) }; parameters[0].Value = model.founderid; parameters[1].Value = model.totalcols; parameters[2].Value = model.userempty; int result = EtNet_DAL.DBHelper.ExecuteCommand(strSql.ToString(), parameters); if (result >= 1) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public static EtNet_Models.PanelMenuRecord GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,founderid,totalcols,userempty from PanelMenuRecord "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; EtNet_Models.PanelMenuRecord model = new EtNet_Models.PanelMenuRecord(); DataTable tbl = EtNet_DAL.DBHelper.GetDataSet(strSql.ToString(), parameters); if (tbl.Rows.Count > 0) { model.id = int.Parse(tbl.Rows[0]["id"].ToString()); model.founderid = int.Parse(tbl.Rows[0]["founderid"].ToString()); model.totalcols = int.Parse(tbl.Rows[0]["totalcols"].ToString()); model.userempty = tbl.Rows[0]["userempty"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 创建面板菜单的列数的记录 /// </summary> private void PanelMenuRecord(int founderid, int totalcols) { EtNet_Models.PanelMenuRecord model = new EtNet_Models.PanelMenuRecord(); model.founderid = founderid; model.totalcols = totalcols; model.userempty = "F";//面板条目不设置为 EtNet_BLL.PanelMenuRecordManager.Add(model); }
/// <summary> /// 修改面板菜单的列数的记录 /// </summary> private void ModifyPanelMenuRecord(int founderid, int totalcols) { string strsql = " founderid=" + founderid; DataTable tbl = EtNet_BLL.PanelMenuRecordManager.GetList(strsql); EtNet_Models.PanelMenuRecord model = new EtNet_Models.PanelMenuRecord(); model.founderid = founderid; model.totalcols = totalcols; model.userempty = "F";//面板条目不设置为 model.id = int.Parse(tbl.Rows[0]["id"].ToString()); EtNet_BLL.PanelMenuRecordManager.Update(model); }
/// <summary> /// 返回关于面板菜单的列数的记录 /// </summary> private int PanelMenuRecord() { string str = " founderid=" + ((EtNet_Models.LoginInfo)Session["login"]).Id; DataTable tbl = EtNet_BLL.PanelMenuRecordManager.GetList(str); if (tbl.Rows.Count == 0) { EtNet_Models.PanelMenuRecord model = new EtNet_Models.PanelMenuRecord(); model.founderid = ((EtNet_Models.LoginInfo)Session["login"]).Id; model.totalcols = 1; model.userempty = "F";//面板条目不设置为空 if (EtNet_BLL.PanelMenuRecordManager.Add(model)) { FirstFourLItem(); } return(model.totalcols); } else { return(int.Parse(tbl.Rows[0]["totalcols"].ToString())); } }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(EtNet_Models.PanelMenuRecord model) { return(EtNet_DAL.PanelMenuRecordService.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public static bool Add(EtNet_Models.PanelMenuRecord model) { return(EtNet_DAL.PanelMenuRecordService.Add(model)); }