//工作总结的绑定
void BindSummarize(int suid)
{
Entity.SummarizeEntity model = new Entity.SummarizeEntity();
model = new Daiv_OA.BLL.SummarizeBLL().GetEntity(suid);
this.lblTitle.Text = model.Sutitle;
text = model.Sutext;
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<Entity.SummarizeEntity> DataTableToList(DataTable dt)
{
List<Entity.SummarizeEntity> modelList = new List<Entity.SummarizeEntity>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Entity.SummarizeEntity model;
for (int n = 0; n < rowsCount; n++)
{
model = new Entity.SummarizeEntity();
if (dt.Rows[n]["Suid"].ToString() != "")
{
model.Suid = int.Parse(dt.Rows[n]["Suid"].ToString());
}
model.Sutitle = dt.Rows[n]["Sutitle"].ToString();
if (dt.Rows[n]["Uid"].ToString() != "")
{
model.Uid = int.Parse(dt.Rows[n]["Uid"].ToString());
}
model.Sutext = dt.Rows[n]["Sutext"].ToString();
if (dt.Rows[n]["Sutime"].ToString() != "")
{
model.Sutime = DateTime.Parse(dt.Rows[n]["Sutime"].ToString());
}
modelList.Add(model);
}
}
return modelList;
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Entity.SummarizeEntity model = new Entity.SummarizeEntity();
model = new JumbotOA.BLL.SummarizeBLL().GetModelbyuid(UserId);
if (this.hidRecordID.Value == "update")
{
//不为空则，修改
model.Sutitle = this.txtTitle.Text;
model.Sutime = DateTime.Today;
model.Sutext = this.FCKeditor1.Value;
new JumbotOA.BLL.SummarizeBLL().Update(model);
FinalMessage("操作成功", "My_Summarize_List.aspx", 0);
}
else
{
//插入
model = new Entity.SummarizeEntity();
model.Uid = UserId;
model.Sutime = DateTime.Now;
model.Sutitle = this.txtTitle.Text;
model.Sutext = this.FCKeditor1.Value;
int i = new JumbotOA.BLL.SummarizeBLL().Add(model);
if (i > 0)
{
FinalMessage("操作成功", "My_Summarize_List.aspx", 0);
}
else
{
System.Web.UI.Page page = (System.Web.UI.Page)System.Web.HttpContext.Current.Handler;
page.ClientScript.RegisterStartupScript(page.GetType(), "clientScript", "<script language='javascript'>alert('操作失败！');</script>");
}
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Entity.SummarizeEntity model = new Entity.SummarizeEntity();
model = new JumbotOA.BLL.SummarizeBLL().GetThisWeekModelbByUid(UserId);
int id = Str2Int(q("id"), 0);
if (model != null)
{
if (model.Suid == id)
{
//修改
model.Sutitle = this.txtTitle.Text;
model.Sutime = DateTime.Now;
model.Sutext = this.FCKeditor1.Value;
new JumbotOA.BLL.SummarizeBLL().Update(model);
FinalMessage("操作成功", "My_Summarize_List.aspx", 0);
}
else
{
FinalMessage("操作失败", "My_Summarize_List.aspx", 0);
}
}
else
{
FinalMessage("操作失败", "My_Summarize_List.aspx", 0);
}
}
//工作总结的绑定
void BindSummarize(int suid)
{
Entity.SummarizeEntity model = new Entity.SummarizeEntity();
model = new JumbotOA.BLL.SummarizeBLL().GetEntity(suid);
this.lblTitle.Text = model.Sutitle;
text = model.Sutext;
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <Entity.SummarizeEntity> DataTableToList(DataTable dt)
{
List <Entity.SummarizeEntity> modelList = new List <Entity.SummarizeEntity>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Entity.SummarizeEntity model;
for (int n = 0; n < rowsCount; n++)
{
model = new Entity.SummarizeEntity();
if (dt.Rows[n]["Suid"].ToString() != "")
{
model.Suid = int.Parse(dt.Rows[n]["Suid"].ToString());
}
model.Sutitle = dt.Rows[n]["Sutitle"].ToString();
if (dt.Rows[n]["Uid"].ToString() != "")
{
model.Uid = int.Parse(dt.Rows[n]["Uid"].ToString());
}
model.Sutext = dt.Rows[n]["Sutext"].ToString();
if (dt.Rows[n]["Sutime"].ToString() != "")
{
model.Sutime = DateTime.Parse(dt.Rows[n]["Sutime"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Entity.SummarizeEntity model = new Entity.SummarizeEntity();
model = new Daiv_OA.BLL.SummarizeBLL().GetModelbyuid(UserId);
if (this.hidRecordID.Value == "update")
{
//不为空则，修改
model.Sutitle = this.txtTitle.Text;
model.Sutime = DateTime.Today;
model.Sutext = this.kindeditor.Value;
new Daiv_OA.BLL.SummarizeBLL().Update(model);
FinalMessage("操作成功", "My_Summarize_List.aspx", 0);
}
else
{
//插入
model = new Entity.SummarizeEntity();
model.Uid = UserId;
model.Sutime = DateTime.Now;
model.Sutitle = this.txtTitle.Text;
model.Sutext = this.kindeditor.Value;
int i = new Daiv_OA.BLL.SummarizeBLL().Add(model);
if (i > 0)
{
FinalMessage("操作成功", "My_Summarize_List.aspx", 0);
}
else
{
System.Web.UI.Page page = (System.Web.UI.Page)System.Web.HttpContext.Current.Handler;
page.ClientScript.RegisterStartupScript(page.GetType(), "clientScript", "<script language='javascript'>alert('操作失败！');</script>");
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Entity.SummarizeEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [OA_Summarize](");
strSql.Append("Sutitle,Uid,Sutext,Sutime)");
strSql.Append(" values (");
strSql.Append("@Sutitle,@Uid,@Sutext,@Sutime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Sutitle", SqlDbType.NVarChar, 30),
new SqlParameter("@Uid", SqlDbType.Int, 4),
new SqlParameter("@Sutext", SqlDbType.NText),
new SqlParameter("@Sutime", SqlDbType.DateTime)
};
parameters[0].Value = model.Sutitle;
parameters[1].Value = model.Uid;
parameters[2].Value = model.Sutext;
parameters[3].Value = model.Sutime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Entity.SummarizeEntity model = new Entity.SummarizeEntity();
model = new JumbotOA.BLL.SummarizeBLL().GetThisWeekModelbByUid(UserId);
int id = Str2Int(q("id"), 0);
if (model != null)
{
if (model.Suid == id)
{
//修改
model.Sutitle = this.txtTitle.Text;
model.Sutime = DateTime.Now;
model.Sutext = this.FCKeditor1.Value;
new JumbotOA.BLL.SummarizeBLL().Update(model);
FinalMessage("操作成功", "My_Summarize_List.aspx", 0);
}
else
{
FinalMessage("操作失败", "My_Summarize_List.aspx", 0);
}
}
else
{
FinalMessage("操作失败", "My_Summarize_List.aspx", 0);
}
}
public List <Entity.SummarizeEntity> getpage(int pageSize, int pageNum, out int count, string str)
{
string select, table, where, order;
select = " * ";
table = "OA_Summarize ";
StringBuilder sb = new StringBuilder();
sb.Append(" ( 1 = 1 ) " + str);
where = sb.ToString();
order = "Suid";
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.SummarizeEntity> list = new List <Entity.SummarizeEntity>();
Entity.SummarizeEntity model;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
model = new Entity.SummarizeEntity();
if (ds.Tables[0].Rows[i]["Suid"].ToString() != "")
{
model.Suid = int.Parse(ds.Tables[0].Rows[i]["Suid"].ToString());
}
if (ds.Tables[0].Rows[i]["Uid"].ToString() != "")
{
model.Uid = int.Parse(ds.Tables[0].Rows[i]["Uid"].ToString());
}
model.Sutext = ds.Tables[0].Rows[i]["Sutext"].ToString();
model.Sutitle = ds.Tables[0].Rows[i]["Sutitle"].ToString();
model.Sutime = Convert.ToDateTime(ds.Tables[0].Rows[i]["Sutime"].ToString());
model.Locked = int.Parse(ds.Tables[0].Rows[i]["Locked"].ToString());
list.Add(model);
}
return(list);
}
//加载时判断本周是否插入过工作总结
void Isfirst()
{
Entity.SummarizeEntity model = new Entity.SummarizeEntity();
model = new BLL.SummarizeBLL().GetThisWeekModelbByUid(UserId);
if (model != null)
{
this.txtTitle.Text = model.Sutitle;
this.kindeditor.Value = model.Sutext;
this.hidRecordID.Value = "update";
}
}
//工作总结的绑定
void BindSummarize(int suid)
{
Entity.SummarizeEntity model = new Entity.SummarizeEntity();
model = new JumbotOA.BLL.SummarizeBLL().GetEntity(suid);
if (model.Uid != UserId)
{
FinalMessage("请勿违规操作", "", 100);
}
this.lblTitle.Text = model.Sutitle;
text = model.Sutext;
}
//加载时判断本周是否插入过工作总结
void Isfirst()
{
Entity.SummarizeEntity model = new Entity.SummarizeEntity();
model = new BLL.SummarizeBLL().GetThisWeekModelbByUid(UserId);
if (model != null)
{
this.txtTitle.Text = model.Sutitle;
this.FCKeditor1.Value = model.Sutext;
this.hidRecordID.Value = "update";
}
}
//工作总结的绑定
void BindSummarize(int suid)
{
Entity.SummarizeEntity model = new Entity.SummarizeEntity();
model = new Daiv_OA.BLL.SummarizeBLL().GetEntity(suid);
if (model.Uid != UserId)
{
FinalMessage("请勿违规操作", "", 100);
}
this.lblTitle.Text = model.Sutitle;
text = model.Sutext;
}
//工作总结绑定
void Sumbind()
{
Entity.SummarizeEntity model = new Entity.SummarizeEntity();
int id = Str2Int(q("id"), 0);
model = new JumbotOA.BLL.SummarizeBLL().GetThisWeekModelbByUid(UserId);
if (model != null)
{
if (model.Suid == id)
{
this.txtTitle.Text = model.Sutitle;
this.FCKeditor1.Value = model.Sutext;
}
else
{
FinalMessage("绑定失败", "My_Summarize_List.aspx", 0);
}
}
else
{
FinalMessage("绑定失败", "My_Summarize_List.aspx", 0);
}
}
/// <summary>
/// 获得某人本周的工作总结
/// </summary>
public Entity.SummarizeEntity GetThisWeekModelbByUid(int uid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Suid,Sutitle,Uid,Sutext,Sutime,Locked from [OA_Summarize] ");
strSql.Append(" where Uid=@Uid and (DATEDIFF(w, Sutime, GETDATE()) = 0) order by Suid desc");
SqlParameter[] parameters =
{
new SqlParameter("@Uid", SqlDbType.Int, 4)
};
parameters[0].Value = uid;
Entity.SummarizeEntity model = new Entity.SummarizeEntity();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Suid"].ToString() != "")
{
model.Suid = int.Parse(ds.Tables[0].Rows[0]["Suid"].ToString());
}
model.Sutitle = ds.Tables[0].Rows[0]["Sutitle"].ToString();
if (ds.Tables[0].Rows[0]["Uid"].ToString() != "")
{
model.Uid = int.Parse(ds.Tables[0].Rows[0]["Uid"].ToString());
}
model.Sutext = ds.Tables[0].Rows[0]["Sutext"].ToString();
if (ds.Tables[0].Rows[0]["Sutime"].ToString() != "")
{
model.Sutime = DateTime.Parse(ds.Tables[0].Rows[0]["Sutime"].ToString());
}
model.Locked = int.Parse(ds.Tables[0].Rows[0]["Locked"].ToString());
return(model);
}
else
{
return(null);
}
}
//工作总结绑定
void Sumbind()
{
Entity.SummarizeEntity model = new Entity.SummarizeEntity();
int id = Str2Int(q("id"), 0);
model = new JumbotOA.BLL.SummarizeBLL().GetThisWeekModelbByUid(UserId);
if (model != null)
{
if (model.Suid == id)
{
this.txtTitle.Text = model.Sutitle;
this.FCKeditor1.Value = model.Sutext;
}
else
{
FinalMessage("绑定失败", "My_Summarize_List.aspx", 0);
}
}
else
{
FinalMessage("绑定失败", "My_Summarize_List.aspx", 0);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Entity.SummarizeEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [OA_Summarize] set ");
strSql.Append("Sutitle=@Sutitle,");
strSql.Append("Sutext=@Sutext,");
strSql.Append("Sutime=@Sutime");
strSql.Append(" where Suid=@Suid ");
SqlParameter[] parameters =
{
new SqlParameter("@Suid", SqlDbType.Int, 4),
new SqlParameter("@Sutitle", SqlDbType.NVarChar, 30),
new SqlParameter("@Sutext", SqlDbType.NText),
new SqlParameter("@Sutime", SqlDbType.DateTime)
};
parameters[0].Value = model.Suid;
parameters[1].Value = model.Sutitle;
parameters[2].Value = model.Sutext;
parameters[3].Value = model.Sutime;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 获得某人本周的工作总结
/// </summary>
public Entity.SummarizeEntity GetThisWeekModelbByUid(int uid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Suid,Sutitle,Uid,Sutext,Sutime,Locked from [OA_Summarize] ");
strSql.Append(" where Uid=@Uid and (DATEDIFF(w, Sutime, GETDATE()) = 0) order by Suid desc");
SqlParameter[] parameters = {
new SqlParameter("@Uid", SqlDbType.Int,4)};
parameters[0].Value = uid;
Entity.SummarizeEntity model = new Entity.SummarizeEntity();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Suid"].ToString() != "")
{
model.Suid = int.Parse(ds.Tables[0].Rows[0]["Suid"].ToString());
}
model.Sutitle = ds.Tables[0].Rows[0]["Sutitle"].ToString();
if (ds.Tables[0].Rows[0]["Uid"].ToString() != "")
{
model.Uid = int.Parse(ds.Tables[0].Rows[0]["Uid"].ToString());
}
model.Sutext = ds.Tables[0].Rows[0]["Sutext"].ToString();
if (ds.Tables[0].Rows[0]["Sutime"].ToString() != "")
{
model.Sutime = DateTime.Parse(ds.Tables[0].Rows[0]["Sutime"].ToString());
}
model.Locked = int.Parse(ds.Tables[0].Rows[0]["Locked"].ToString());
return model;
}
else
{
return null;
}
}
public List<Entity.SummarizeEntity> getpage(int pageSize, int pageNum, out int count, string str)
{
string select, table, where, order;
select = " * ";
table = "OA_Summarize ";
StringBuilder sb = new StringBuilder();
sb.Append(" ( 1 = 1 ) " + str);
where = sb.ToString();
order = "Suid";
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.SummarizeEntity> list = new List<Entity.SummarizeEntity>();
Entity.SummarizeEntity model;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
model = new Entity.SummarizeEntity();
if (ds.Tables[0].Rows[i]["Suid"].ToString() != "")
{
model.Suid = int.Parse(ds.Tables[0].Rows[i]["Suid"].ToString());
}
if (ds.Tables[0].Rows[i]["Uid"].ToString() != "")
{
model.Uid = int.Parse(ds.Tables[0].Rows[i]["Uid"].ToString());
}
model.Sutext = ds.Tables[0].Rows[i]["Sutext"].ToString();
model.Sutitle = ds.Tables[0].Rows[i]["Sutitle"].ToString();
model.Sutime = Convert.ToDateTime(ds.Tables[0].Rows[i]["Sutime"].ToString());
model.Locked = int.Parse(ds.Tables[0].Rows[i]["Locked"].ToString());
list.Add(model);
}
return list;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Entity.SummarizeEntity model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Entity.SummarizeEntity model)
{
dal.Update(model);
}
