/// <summary>
/// 获得数据列表
/// </summary>
public List <Entity.LearningEntity> DataTableToList(DataTable dt)
{
List <Entity.LearningEntity> modelList = new List <Entity.LearningEntity>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Entity.LearningEntity model;
for (int n = 0; n < rowsCount; n++)
{
model = new Entity.LearningEntity();
if (dt.Rows[n]["Sid"].ToString() != "")
{
model.Sid = int.Parse(dt.Rows[n]["Sid"].ToString());
}
model.Stitle = dt.Rows[n]["Stitle"].ToString();
model.Sauthor = dt.Rows[n]["Sauthor"].ToString();
if (dt.Rows[n]["Sdate"].ToString() != "")
{
model.Sdate = DateTime.Parse(dt.Rows[n]["Sdate"].ToString());
}
model.Spath = dt.Rows[n]["Spath"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Entity.LearningEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [OA_Learning](");
strSql.Append("Stitle,Sauthor,Sdate,Spath,Did)");
strSql.Append(" values (");
strSql.Append("@Stitle,@Sauthor,@Sdate,@Spath,@Did)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Stitle", SqlDbType.VarChar, 30),
new SqlParameter("@Sauthor", SqlDbType.VarChar, 10),
new SqlParameter("@Sdate", SqlDbType.DateTime),
new SqlParameter("@Spath", SqlDbType.NText),
new SqlParameter("@Did", SqlDbType.Int, 4)
};
parameters[0].Value = model.Stitle;
parameters[1].Value = model.Sauthor;
parameters[2].Value = model.Sdate;
parameters[3].Value = model.Spath;
parameters[4].Value = model.Did;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Entity.LearningEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [OA_Learning] set ");
strSql.Append("Stitle=@Stitle,");
strSql.Append("Sauthor=@Sauthor,");
strSql.Append("Sdate=@Sdate,");
strSql.Append("Spath=@Spath,");
strSql.Append("Did=@Did");
strSql.Append(" where Sid=@Sid ");
SqlParameter[] parameters =
{
new SqlParameter("@Sid", SqlDbType.Int, 4),
new SqlParameter("@Stitle", SqlDbType.VarChar, 30),
new SqlParameter("@Sauthor", SqlDbType.VarChar, 10),
new SqlParameter("@Sdate", SqlDbType.DateTime),
new SqlParameter("@Spath", SqlDbType.NText),
new SqlParameter("@Did", SqlDbType.Int, 4)
};
parameters[0].Value = model.Sid;
parameters[1].Value = model.Stitle;
parameters[2].Value = model.Sauthor;
parameters[3].Value = model.Sdate;
parameters[4].Value = model.Spath;
parameters[5].Value = model.Did;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
//添加信息
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Entity.LearningEntity model = new Entity.LearningEntity();
model.Sauthor = UserName;
model.Stitle = this.txtTitle.Text;
model.Sdate = DateTime.Now;
model.Spath = this.FCKeditor1.Value;
model.Did = UserDepartmentId;
int i = new JumbotOA.BLL.LearningBLL().Add(model);
if (i > 0)
{
JumbotOA.BLL.UserBLL user = new JumbotOA.BLL.UserBLL();
DataTable dt = new DataTable();
string aa = "";
if (UserPowerId <= 3)
{
dt = user.GetList("").Tables[0];
}
else
{
dt = user.GetList("Did=" + UserDepartmentId).Tables[0];
}
for (int j = 0; j < dt.Rows.Count; j++)
{
aa += dt.Rows[j]["Uid"].ToString() + ",";
}
JumbotOA.BLL.OA_SysMessageIn.ADDsysMessage(2, "," + aa, "[新资料]" + txtTitle.Text, JumbotOA.Utils.Strings.Left(JumbotOA.Utils.Strings.delhtml(FCKeditor1.Value.ToString()), 53), "My_Learning_Show.aspx?id=" + i.ToString());
string addtype = "添加学习资料";
Addlog(addtype);
aa = "";
}
}
//添加信息
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Entity.LearningEntity model = new Entity.LearningEntity();
model.Sauthor = UserName;
model.Stitle = this.txtTitle.Text;
model.Sdate = DateTime.Now;
model.Spath = this.FCKeditor1.Value;
model.Did = UserDepartmentId;
int i = new JumbotOA.BLL.LearningBLL().Add(model);
if (i > 0)
{
JumbotOA.BLL.UserBLL user = new JumbotOA.BLL.UserBLL();
DataTable dt=new DataTable ();
string aa = "";
if(UserPowerId<=3)
dt=user.GetList("").Tables[0];
else
dt= user.GetList("Did=" + UserDepartmentId).Tables[0];
for(int j=0;j<dt.Rows.Count;j++)
{
aa +=dt.Rows[j]["Uid"].ToString()+",";
}
JumbotOA.BLL.OA_SysMessageIn.ADDsysMessage(2, "," + aa, "[新资料]" + txtTitle.Text, JumbotOA.Utils.Strings.Left(JumbotOA.Utils.Strings.delhtml(FCKeditor1.Value.ToString()),53), "My_Learning_Show.aspx?id=" + i.ToString());
string addtype = "添加学习资料";
Addlog(addtype);
aa = "";
}
}
/// <summary>
/// ��������б�
/// </summary>
public List<Entity.LearningEntity> DataTableToList(DataTable dt)
{
List<Entity.LearningEntity> modelList = new List<Entity.LearningEntity>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Entity.LearningEntity model;
for (int n = 0; n < rowsCount; n++)
{
model = new Entity.LearningEntity();
if(dt.Rows[n]["Sid"].ToString()!="")
{
model.Sid=int.Parse(dt.Rows[n]["Sid"].ToString());
}
model.Stitle=dt.Rows[n]["Stitle"].ToString();
model.Sauthor=dt.Rows[n]["Sauthor"].ToString();
if(dt.Rows[n]["Sdate"].ToString()!="")
{
model.Sdate=DateTime.Parse(dt.Rows[n]["Sdate"].ToString());
}
model.Spath=dt.Rows[n]["Spath"].ToString();
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 分页获取数据列表
/// </summary>
public List <Entity.LearningEntity> getpage(int pageSize, int pageNum, out int count, string str)
{
string select, table, where, order;
select = " * ";
table = "[OA_Learning] ";
StringBuilder sb = new StringBuilder();
sb.Append(" ( 1 = 1 ) " + str);
where = sb.ToString();
order = "Sid";
string sql = "exec Pagination @select, @table, @where, @orderField, @orderType, @pageSize, @pageNum ";
SqlParameter[] paras =
{
new SqlParameter("@select", select),
new SqlParameter("@table", table),
new SqlParameter("@where", where),
new SqlParameter("@orderField", order),
new SqlParameter("@orderType", '1'),
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@pageNum", pageNum)
};
DataSet ds = DbHelperSQL.Query(sql, paras);
count = Convert.ToInt32(ds.Tables[1].Rows[0][0]);
List <Entity.LearningEntity> list = new List <Entity.LearningEntity>();
Entity.LearningEntity model;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
model = new Entity.LearningEntity();
if (ds.Tables[0].Rows[i]["Sid"].ToString() != "")
{
model.Sid = int.Parse(ds.Tables[0].Rows[i]["Sid"].ToString());
}
model.Sauthor = ds.Tables[0].Rows[i]["Sauthor"].ToString();
model.Sdate = Convert.ToDateTime(ds.Tables[0].Rows[i]["Sdate"].ToString());
model.Stitle = ds.Tables[0].Rows[i]["Stitle"].ToString();
model.Spath = ds.Tables[0].Rows[i]["Spath"].ToString();
model.Did = int.Parse(ds.Tables[0].Rows[i]["Did"].ToString());
list.Add(model);
}
return(list);
}
//修改信息
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Entity.LearningEntity model = new Entity.LearningEntity();
model.Sid = Str2Int(q("id"));
model.Sauthor = UserName;
model.Stitle = this.txtTitle.Text;
model.Sdate = DateTime.Now;
model.Spath = this.FCKeditor1.Value;
model.Did = UserDepartmentId;
new JumbotOA.BLL.LearningBLL().Update(model);
string addtype = "修改学习资料";
Addlog(addtype);
}
//修改信息
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Entity.LearningEntity model = new Entity.LearningEntity();
model.Sid = Str2Int(q("id"));
model.Sauthor = UserName;
model.Stitle = this.txtTitle.Text;
model.Sdate = DateTime.Now;
model.Spath = this.kindeditor.Value;
model.Did = UserDepartmentId;
new Daiv_OA.BLL.LearningBLL().Update(model);
string addtype = "修改学习资料";
Addlog(addtype);
}
void Bind()
{
int id = Str2Int(q("id"), 0);
Entity.LearningEntity model = new Entity.LearningEntity();
model = new JumbotOA.BLL.LearningBLL().GetEntity(id);
if (UserPowerId > 2)
{
if (UserDepartmentId != model.Did && model.Did > 0)
{
FinalMessage("请勿越权", "Learning_List.aspx", 0);
}
}
this.lblTitle.Text = model.Stitle;
text = model.Spath;
}
void Bind()
{
int id = Str2Int(q("id"), 0);
Entity.LearningEntity model = new Entity.LearningEntity();
model = new JumbotOA.BLL.LearningBLL().GetEntity(id);
if (UserPowerId > 2)
{
if (UserDepartmentId != model.Did && model.Did > 0)
{
FinalMessage("请勿越权", "Learning_List.aspx", 0);
}
}
this.lblTitle.Text = model.Stitle;
text = model.Spath;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.LearningEntity GetEntity(int Sid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Sid,Stitle,Sauthor,Sdate,Spath,Did from [OA_Learning] ");
strSql.Append(" where Sid=@Sid ");
SqlParameter[] parameters =
{
new SqlParameter("@Sid", SqlDbType.Int, 4)
};
parameters[0].Value = Sid;
Entity.LearningEntity model = new Entity.LearningEntity();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Sid"].ToString() != "")
{
model.Sid = int.Parse(ds.Tables[0].Rows[0]["Sid"].ToString());
}
model.Stitle = ds.Tables[0].Rows[0]["Stitle"].ToString();
model.Sauthor = ds.Tables[0].Rows[0]["Sauthor"].ToString();
if (ds.Tables[0].Rows[0]["Sdate"].ToString() != "")
{
model.Sdate = DateTime.Parse(ds.Tables[0].Rows[0]["Sdate"].ToString());
}
model.Spath = ds.Tables[0].Rows[0]["Spath"].ToString();
model.Did = int.Parse(ds.Tables[0].Rows[0]["Did"].ToString());
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Entity.LearningEntity model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Entity.LearningEntity model)
{
return(dal.Add(model));
}
/// <summary>
/// ��ҳ��ȡ�����б�
/// </summary>
public List<Entity.LearningEntity> getpage(int pageSize, int pageNum, out int count, string str)
{
string select, table, where, order;
select = " * ";
table = "[OA_Learning] ";
StringBuilder sb = new StringBuilder();
sb.Append(" ( 1 = 1 ) " + str);
where = sb.ToString();
order = "Sid";
string sql = "exec Pagination @select, @table, @where, @orderField, @orderType, @pageSize, @pageNum ";
SqlParameter[] paras ={
new SqlParameter("@select", select),
new SqlParameter("@table", table),
new SqlParameter("@where", where),
new SqlParameter("@orderField", order),
new SqlParameter("@orderType", '1'),
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@pageNum", pageNum)
};
DataSet ds = DbHelperSQL.Query(sql, paras);
count = Convert.ToInt32(ds.Tables[1].Rows[0][0]);
List<Entity.LearningEntity> list = new List<Entity.LearningEntity>();
Entity.LearningEntity model;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
model = new Entity.LearningEntity();
if (ds.Tables[0].Rows[i]["Sid"].ToString() != "")
{
model.Sid = int.Parse(ds.Tables[0].Rows[i]["Sid"].ToString());
}
model.Sauthor = ds.Tables[0].Rows[i]["Sauthor"].ToString();
model.Sdate = Convert.ToDateTime(ds.Tables[0].Rows[i]["Sdate"].ToString());
model.Stitle = ds.Tables[0].Rows[i]["Stitle"].ToString();
model.Spath = ds.Tables[0].Rows[i]["Spath"].ToString();
model.Did = int.Parse(ds.Tables[0].Rows[i]["Did"].ToString());
list.Add(model);
}
return list;
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public Entity.LearningEntity GetEntity(int Sid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Sid,Stitle,Sauthor,Sdate,Spath,Did from [OA_Learning] ");
strSql.Append(" where Sid=@Sid ");
SqlParameter[] parameters = {
new SqlParameter("@Sid", SqlDbType.Int,4)};
parameters[0].Value = Sid;
Entity.LearningEntity model = new Entity.LearningEntity();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Sid"].ToString() != "")
{
model.Sid = int.Parse(ds.Tables[0].Rows[0]["Sid"].ToString());
}
model.Stitle = ds.Tables[0].Rows[0]["Stitle"].ToString();
model.Sauthor = ds.Tables[0].Rows[0]["Sauthor"].ToString();
if (ds.Tables[0].Rows[0]["Sdate"].ToString() != "")
{
model.Sdate = DateTime.Parse(ds.Tables[0].Rows[0]["Sdate"].ToString());
}
model.Spath = ds.Tables[0].Rows[0]["Spath"].ToString();
model.Did = int.Parse(ds.Tables[0].Rows[0]["Did"].ToString());
return model;
}
else
{
return null;
}
}
