/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(EtNet_Models.InitializeSet model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update InitializeSet set ");
strSql.Append("cname=@cname,");
strSql.Append("siftopen=@siftopen,");
strSql.Append("pagecount=@pagecount,");
strSql.Append("pageitem=@pageitem,");
strSql.Append("infocycle=@infocycle,");
strSql.Append("createtime=@createtime,");
strSql.Append("inforemind=@inforemind,");
strSql.Append("newinforemind=@newinforemind,");
strSql.Append("panellistall=@panellistall,");
strSql.Append("panellist=@panellist,");
strSql.Append("panelcount=@panelcount,");
strSql.Append("panelcols=@panelcols");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@cname", SqlDbType.VarChar, 50),
new SqlParameter("@siftopen", SqlDbType.Int, 4),
new SqlParameter("@pagecount", SqlDbType.Int, 4),
new SqlParameter("@pageitem", SqlDbType.Int, 4),
new SqlParameter("@infocycle", SqlDbType.Int, 4),
new SqlParameter("@createtime", SqlDbType.DateTime),
new SqlParameter("@inforemind", SqlDbType.Int, 4),
new SqlParameter("@newinforemind", SqlDbType.Int, 4),
new SqlParameter("@panellistall", SqlDbType.VarChar, 100),
new SqlParameter("@panellist", SqlDbType.VarChar, 100),
new SqlParameter("@panelcount", SqlDbType.VarChar, 100),
new SqlParameter("@panelcols", SqlDbType.Int, 4),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.cname;
parameters[1].Value = model.siftopen;
parameters[2].Value = model.pagecount;
parameters[3].Value = model.pageitem;
parameters[4].Value = model.infocycle;
parameters[5].Value = model.createtime;
parameters[6].Value = model.inforemind;
parameters[7].Value = model.newinforemind;
parameters[8].Value = model.panellistall;
parameters[9].Value = model.panellist;
parameters[10].Value = model.panelcount;
parameters[11].Value = model.panelcols;
parameters[12].Value = model.id;
int result = EtNet_DAL.DBHelper.ExecuteCommand(strSql.ToString(), parameters);
if (result >= 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改用户参数设置
/// </summary>
private void ResetUserSet()
{
SaveInitializeSet(); //保存参数设置
int id = int.Parse(this.hidval.Value);
EtNet_Models.InitializeSet model = EtNet_BLL.InitializeSetManager.GetModel(id);
string[] list = null; //用户的id值列表
if (this.hiduserlist.Value.IndexOf(',') != -1)
{
list = this.hiduserlist.Value.Split(',');
}
else
{
list = new string[1] {
this.hiduserlist.Value
};
}
int founderid = 0; //用户的id值
for (int i = 0; i < list.Length; i++)
{
founderid = int.Parse(list[i]);
string strdel = " createrid=" + founderid;
EtNet_BLL.InitializeUserSetManager.Del(strdel); //删除用户参数设置
EtNet_Models.InitializeUserSet user = new EtNet_Models.InitializeUserSet();
user.cname = model.cname;
user.createrid = founderid;
user.createtime = DateTime.Now;
user.infocycle = model.infocycle;
user.inforemind = model.inforemind;
user.newinforemind = model.newinforemind;
user.pagecount = model.pagecount;
user.pageitem = model.pageitem;
user.panelcols = model.panelcols;
user.panelcount = model.panelcount;
user.panellist = model.panellist;
user.panellistall = model.panellistall;
user.siftopen = model.siftopen;
EtNet_BLL.InitializeUserSetManager.Add(user);
ModifyDataList(founderid, model.siftopen, model.pagecount, model.pageitem);
ModifyPanelMenuRecord(founderid, model.panelcols);
ModifyPanelItem(founderid, model.panellist);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int Add(EtNet_Models.InitializeSet model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into InitializeSet(");
strSql.Append("cname,siftopen,pagecount,pageitem,infocycle,createtime,inforemind,newinforemind,panellistall,panellist,panelcount,panelcols)");
strSql.Append(" values (");
strSql.Append("@cname,@siftopen,@pagecount,@pageitem,@infocycle,@createtime,@inforemind,@newinforemind,@panellistall@panellist,@panelcount,@panelcols)");
strSql.Append(";select SCOPE_IDENTITY() ");
SqlParameter[] parameters =
{
new SqlParameter("@cname", SqlDbType.VarChar, 50),
new SqlParameter("@siftopen", SqlDbType.Int, 4),
new SqlParameter("@pagecount", SqlDbType.Int, 4),
new SqlParameter("@pageitem", SqlDbType.Int, 4),
new SqlParameter("@infocycle", SqlDbType.Int, 4),
new SqlParameter("@createtime", SqlDbType.DateTime),
new SqlParameter("@inforemind", SqlDbType.Int, 4),
new SqlParameter("@newinforemind", SqlDbType.Int, 4),
new SqlParameter("@panellistall", SqlDbType.VarChar, 100),
new SqlParameter("@panellist", SqlDbType.VarChar, 100),
new SqlParameter("@panelcount", SqlDbType.VarChar, 100),
new SqlParameter("@panelcols", SqlDbType.Int, 4)
};
parameters[0].Value = model.cname;
parameters[1].Value = model.siftopen;
parameters[2].Value = model.pagecount;
parameters[3].Value = model.pageitem;
parameters[4].Value = model.infocycle;
parameters[5].Value = model.createtime;
parameters[6].Value = model.inforemind;
parameters[7].Value = model.newinforemind;
parameters[8].Value = model.panellistall;
parameters[9].Value = model.panellist;
parameters[10].Value = model.panelcount;
parameters[11].Value = model.panelcols;
int result = 0;
SqlDataReader rad = EtNet_DAL.DBHelper.ExecuteReader(strSql.ToString(), parameters);
if (rad.Read())
{
result = Convert.ToInt32(rad[0]);
rad.Close();
}
return(result);
}
//保存参数配置
private bool SaveInitializeSet()
{
int id = int.Parse(this.hidval.Value);
EtNet_Models.InitializeSet model = EtNet_BLL.InitializeSetManager.GetModel(id);
model.infocycle = int.Parse(this.iptinfocycle.Value);
model.newinforemind = int.Parse(this.ddlnewinforemind.SelectedValue);
model.pagecount = int.Parse(this.ddlpagecount.SelectedValue);
model.pageitem = int.Parse(this.ddlpageitem.SelectedValue);
model.panelcols = int.Parse(this.ddlpanelcols.SelectedValue);
model.panelcount = this.ddlpanelcount.SelectedValue;
model.panellist = this.hidpanellist.Value;
model.panellistall = this.hidupanellist.Value;
if (EtNet_BLL.InitializeSetManager.Update(model))
{
LoadInitializeData();
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static EtNet_Models.InitializeSet GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from InitializeSet ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
EtNet_Models.InitializeSet model = new EtNet_Models.InitializeSet();
DataTable tbl = EtNet_DAL.DBHelper.GetDataSet(strSql.ToString(), parameters);
if (tbl.Rows.Count > 0)
{
model.id = int.Parse(tbl.Rows[0]["id"].ToString());
model.cname = tbl.Rows[0]["cname"].ToString();
model.siftopen = int.Parse(tbl.Rows[0]["siftopen"].ToString());
model.pagecount = int.Parse(tbl.Rows[0]["pagecount"].ToString());
model.pageitem = int.Parse(tbl.Rows[0]["pageitem"].ToString());
model.infocycle = int.Parse(tbl.Rows[0]["infocycle"].ToString());
model.createtime = DateTime.Parse(tbl.Rows[0]["createtime"].ToString());
model.inforemind = int.Parse(tbl.Rows[0]["inforemind"].ToString());
model.newinforemind = int.Parse(tbl.Rows[0]["newinforemind"].ToString());
model.panellistall = tbl.Rows[0]["panellistall"].ToString();
model.panellist = tbl.Rows[0]["panellist"].ToString();
model.panelcount = tbl.Rows[0]["panelcount"].ToString();
model.panelcols = int.Parse(tbl.Rows[0]["panelcols"].ToString());
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(EtNet_Models.InitializeSet model)
{
return(EtNet_DAL.InitializeSetService.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int Add(EtNet_Models.InitializeSet model)
{
return(EtNet_DAL.InitializeSetService.Add(model));
}
