//工作总结的绑定 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)); } }
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); } }
/// <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); }