public List <Entity.WorklogEntity> getpage(int pageSize, int pageNum, out int count, string str) { string select, table, where, order; select = " * "; table = "[OA_Worklog] "; StringBuilder sb = new StringBuilder(); sb.Append(" ( 1 = 1 ) " + str); where = sb.ToString(); order = "Id"; 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.WorklogEntity> list = new List <Entity.WorklogEntity>(); Entity.WorklogEntity model; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { model = new Entity.WorklogEntity(); if (ds.Tables[0].Rows[i]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[i]["Id"].ToString()); } model.Begintime = Convert.ToDateTime(ds.Tables[0].Rows[i]["Begintime"].ToString()); model.Manager = ds.Tables[0].Rows[i]["Manager"].ToString(); model.Content = ds.Tables[0].Rows[i]["Content"].ToString(); model.Endtime = Convert.ToDateTime(ds.Tables[0].Rows[i]["Endtime"].ToString()); model.Title = ds.Tables[0].Rows[i]["Title"].ToString(); model.Uid = Convert.ToInt32(ds.Tables[0].Rows[i]["Uid"].ToString()); model.Problem = ds.Tables[0].Rows[i]["Problem"].ToString(); model.Remark = ds.Tables[0].Rows[i]["Remark"].ToString(); list.Add(model); } return(list); }
void Bind_Worklog() { int id = Str2Int(q("id"), 0); Entity.WorklogEntity model = new Entity.WorklogEntity(); model = new JumbotOA.BLL.WorklogBLL().GetEntity(id); this.lblTitle.Text = model.Title; this.lblBegintime.Text = model.Begintime.ToString(); this.lblEndtime.Text = model.Endtime.ToString(); this.lblContent.Text = model.Content; this.lblManager.Text = model.Manager; this.lblProblem.Text = model.Problem; text = model.Remark; }
void Bind_Worklog() { int id = Str2Int(q("id"), 0); Entity.WorklogEntity model = new Entity.WorklogEntity(); model = new JumbotOA.BLL.WorklogBLL().GetEntity(id); this.lblTitle.Text = model.Title; this.lblBegintime.Text = model.Begintime.ToString(); this.lblEndtime.Text = model.Endtime.ToString(); this.lblContent.Text = model.Content; this.lblManager.Text = model.Manager; this.lblProblem.Text = model.Problem; text = model.Remark; }
void Bind_Worklog() { int id = Str2Int(q("id"), 0); Entity.WorklogEntity model = new Entity.WorklogEntity(); model = new JumbotOA.BLL.WorklogBLL().GetEntity(id); if (model.Uid != UserId) { FinalMessage("请勿违规操作", "", 100); } this.lblTitle.Text = model.Title; this.lblBegintime.Text = model.Begintime.ToString(); this.lblEndtime.Text = model.Endtime.ToString(); this.lblContent.Text = model.Content; this.lblManager.Text = model.Manager; this.lblProblem.Text = model.Problem; text = model.Remark; }
void Bind_Worklog() { int id = Str2Int(q("id"), 0); Entity.WorklogEntity model = new Entity.WorklogEntity(); model = new JumbotOA.BLL.WorklogBLL().GetEntity(id); if (model.Uid != UserId) { FinalMessage("请勿违规操作", "", 100); } this.lblTitle.Text = model.Title; this.lblBegintime.Text = model.Begintime.ToString(); this.lblEndtime.Text = model.Endtime.ToString(); this.lblContent.Text = model.Content; this.lblManager.Text = model.Manager; this.lblProblem.Text = model.Problem; text = model.Remark; }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { Entity.WorklogEntity worklog = new Entity.WorklogEntity(); worklog.Uid = UserId; worklog.Begintime = Convert.ToDateTime(this.txtBegintime.Text); worklog.Endtime = Convert.ToDateTime(this.txtEndtime.Text); worklog.Title = this.txtTitle.Text; worklog.Content = this.txtContent.Text; worklog.Problem = this.txtProblem.Text; worklog.Manager = this.ddlManager.SelectedItem.Text; worklog.Remark = this.FCKeditor1.Value; int i = new JumbotOA.BLL.WorklogBLL().Add(worklog); if (i > 0) { FinalMessage("操作成功", "My_Worklog_List.aspx", 0); } else { FinalMessage("操作失败", "My_Worklog_List.aspx", 0); } }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { Entity.WorklogEntity worklog = new Entity.WorklogEntity(); worklog.Uid = UserId; worklog.Begintime = Convert.ToDateTime(this.txtBegintime.Text); worklog.Endtime = Convert.ToDateTime(this.txtEndtime.Text); worklog.Title = this.txtTitle.Text; worklog.Content = this.txtContent.Text; worklog.Problem = this.txtProblem.Text; worklog.Manager = this.ddlManager.SelectedItem.Text; worklog.Remark = this.kindeditor.Value; int i = new Daiv_OA.BLL.WorklogBLL().Add(worklog); if (i > 0) { FinalMessage("操作成功", "My_Worklog_List.aspx", 0); } else { FinalMessage("操作失败", "My_Worklog_List.aspx", 0); } }
public List<Entity.WorklogEntity> getpage(int pageSize, int pageNum, out int count, string str) { string select, table, where, order; select = " * "; table = "[OA_Worklog] "; StringBuilder sb = new StringBuilder(); sb.Append(" ( 1 = 1 ) " + str); where = sb.ToString(); order = "Id"; 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.WorklogEntity> list = new List<Entity.WorklogEntity>(); Entity.WorklogEntity model; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { model = new Entity.WorklogEntity(); if (ds.Tables[0].Rows[i]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[i]["Id"].ToString()); } model.Begintime = Convert.ToDateTime(ds.Tables[0].Rows[i]["Begintime"].ToString()); model.Manager = ds.Tables[0].Rows[i]["Manager"].ToString(); model.Content = ds.Tables[0].Rows[i]["Content"].ToString(); model.Endtime = Convert.ToDateTime(ds.Tables[0].Rows[i]["Endtime"].ToString()); model.Title = ds.Tables[0].Rows[i]["Title"].ToString(); model.Uid = Convert.ToInt32(ds.Tables[0].Rows[i]["Uid"].ToString()); model.Problem = ds.Tables[0].Rows[i]["Problem"].ToString(); model.Remark = ds.Tables[0].Rows[i]["Remark"].ToString(); list.Add(model); } return list; }