/// <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));
}
