/// <summary> /// ��������б� /// </summary> public List<Entity.TimeEntity> DataTableToList(DataTable dt) { List<Entity.TimeEntity> modelList = new List<Entity.TimeEntity>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Entity.TimeEntity model; for (int n = 0; n < rowsCount; n++) { model = new Entity.TimeEntity(); if(dt.Rows[n]["Tid"].ToString()!="") { model.Tid=int.Parse(dt.Rows[n]["Tid"].ToString()); } if(dt.Rows[n]["Uid"].ToString()!="") { model.Uid=int.Parse(dt.Rows[n]["Uid"].ToString()); } if(dt.Rows[n]["Retime"].ToString()!="") { model.Retime=DateTime.Parse(dt.Rows[n]["Retime"].ToString()); } if(dt.Rows[n]["Nowtime"].ToString()!="") { model.Nowtime=DateTime.Parse(dt.Rows[n]["Nowtime"].ToString()); } model.Timetype=dt.Rows[n]["Timetype"].ToString(); model.Ipaddress=dt.Rows[n]["Ipaddress"].ToString(); model.Timeinfo=dt.Rows[n]["Timeinfo"].ToString(); modelList.Add(model); } } return modelList; }
/// <summary> /// 获得数据列表 /// </summary> public List <Entity.TimeEntity> DataTableToList(DataTable dt) { List <Entity.TimeEntity> modelList = new List <Entity.TimeEntity>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Entity.TimeEntity model; for (int n = 0; n < rowsCount; n++) { model = new Entity.TimeEntity(); if (dt.Rows[n]["Tid"].ToString() != "") { model.Tid = int.Parse(dt.Rows[n]["Tid"].ToString()); } if (dt.Rows[n]["Uid"].ToString() != "") { model.Uid = int.Parse(dt.Rows[n]["Uid"].ToString()); } if (dt.Rows[n]["Retime"].ToString() != "") { model.Retime = DateTime.Parse(dt.Rows[n]["Retime"].ToString()); } if (dt.Rows[n]["Nowtime"].ToString() != "") { model.Nowtime = DateTime.Parse(dt.Rows[n]["Nowtime"].ToString()); } model.Timetype = dt.Rows[n]["Timetype"].ToString(); model.Ipaddress = dt.Rows[n]["Ipaddress"].ToString(); model.Timeinfo = dt.Rows[n]["Timeinfo"].ToString(); modelList.Add(model); } } return(modelList); }
//获取 protected void btWork_Click(object sender, EventArgs e) { //获取登记记录 string nowtime = DateTime.Today.ToString("yyyy-MM-dd"); bool isfirst = new JumbotOA.BLL.TimeBLL().Isfirst(UserId, "上班登记", nowtime); if (isfirst == true) { Tools.Common.JavaScript.MessageBox(this, "您上班已经登记了!"); //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>"); } //不存在记录就登记 else { string retime = "08:30:00"; Entity.TimeEntity timeEntity = new Entity.TimeEntity(); timeEntity.Uid = UserId; timeEntity.Nowtime = DateTime.Now; timeEntity.Retime = Convert.ToDateTime(retime); timeEntity.Timeinfo = ""; timeEntity.Timetype = this.btWork.Text; timeEntity.Ipaddress = Page.Request.UserHostAddress; int i = new JumbotOA.BLL.TimeBLL().Add(timeEntity); if (i > 0) { Tools.Common.JavaScript.MessageBox(this, "上班登记成功!"); //System.Web.UI.Page page = (System.Web.UI.Page)System.Web.HttpContext.Current.Handler; //JumbotOA.Utils.QQRobotHelp.SendClusterMessage("OA平台消息:" + UserName + "上班来了。"); //page.ClientScript.RegisterStartupScript(page.GetType(), "clientScript", "<script language='javascript'>alert('上班登记成功!');</script>"); } } Selectinfo(wheres()); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Entity.TimeEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [OA_Time] set "); strSql.Append("Uid=@Uid,"); strSql.Append("Retime=@Retime,"); strSql.Append("Nowtime=@Nowtime,"); strSql.Append("Timetype=@Timetype,"); strSql.Append("Ipaddress=@Ipaddress,"); strSql.Append("Timeinfo=@Timeinfo"); strSql.Append(" where Tid=@Tid "); SqlParameter[] parameters = { new SqlParameter("@Tid", SqlDbType.Int, 4), new SqlParameter("@Uid", SqlDbType.Int, 4), new SqlParameter("@Retime", SqlDbType.DateTime), new SqlParameter("@Nowtime", SqlDbType.DateTime), new SqlParameter("@Timetype", SqlDbType.VarChar, 10), new SqlParameter("@Ipaddress", SqlDbType.VarChar, 30), new SqlParameter("@Timeinfo", SqlDbType.VarChar, 30) }; parameters[0].Value = model.Tid; parameters[1].Value = model.Uid; parameters[2].Value = model.Retime; parameters[3].Value = model.Nowtime; parameters[4].Value = model.Timetype; parameters[5].Value = model.Ipaddress; parameters[6].Value = model.Timeinfo; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 分页获取数据列表 /// </summary> public List <Entity.TimeEntity> getpage(int pageSize, int pageNum, out int count, string str) { string select, table, where, order; select = " * "; table = "[OA_Time] "; StringBuilder sb = new StringBuilder(); sb.Append(" ( 1 = 1 ) " + str); where = sb.ToString(); order = "Tid"; 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.TimeEntity> list = new List <Entity.TimeEntity>(); Entity.TimeEntity model; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { model = new Entity.TimeEntity(); if (ds.Tables[0].Rows[i]["Tid"].ToString() != "") { model.Tid = int.Parse(ds.Tables[0].Rows[i]["Tid"].ToString()); } if (ds.Tables[0].Rows[i]["Uid"].ToString() != "") { model.Uid = int.Parse(ds.Tables[0].Rows[i]["Uid"].ToString()); } model.Nowtime = Convert.ToDateTime(ds.Tables[0].Rows[i]["Nowtime"].ToString()); model.Retime = Convert.ToDateTime(ds.Tables[0].Rows[i]["Retime"].ToString()); model.Ipaddress = ds.Tables[0].Rows[i]["Ipaddress"].ToString(); model.Timeinfo = ds.Tables[0].Rows[i]["Timeinfo"].ToString(); model.Timetype = ds.Tables[0].Rows[i]["Timetype"].ToString(); list.Add(model); } return(list); }
/// <summary> /// Executed every time the gamestate is activated. /// </summary> public override void Init() { base.Init(); for (int i = 0; i < 25; i++) { Entity.Entity entity = GetRandomEntity(); Entity.TimeEntity timeEntity = new Entity.TimeEntity(entity.rectangle, entity.brush, map); entities.Add(timeEntity); } centerBox.visible = false; caption.visible = false; inputBox.visible = false; }
protected void btErr_Click(object sender, EventArgs e) { string retime = "08:30:00"; Entity.TimeEntity timeEntity = new Entity.TimeEntity(); timeEntity.Uid = UserId; timeEntity.Nowtime = DateTime.Now; timeEntity.Retime = Convert.ToDateTime(retime); timeEntity.Timeinfo = this.txtErr.Text; timeEntity.Timetype = this.btErr0.Text; timeEntity.Ipaddress = Page.Request.UserHostAddress; int i = new JumbotOA.BLL.TimeBLL().Add(timeEntity); if (i > 0) { 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>"); } Selectinfo(wheres()); }
/// <summary> /// 得到一个对象实体 /// </summary> public Entity.TimeEntity GetEntity(int Tid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Tid,Uid,Retime,Nowtime,Timetype,Ipaddress,Timeinfo from [OA_Time] "); strSql.Append(" where Tid=@Tid "); SqlParameter[] parameters = { new SqlParameter("@Tid", SqlDbType.Int, 4) }; parameters[0].Value = Tid; Entity.TimeEntity model = new Entity.TimeEntity(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Tid"].ToString() != "") { model.Tid = int.Parse(ds.Tables[0].Rows[0]["Tid"].ToString()); } if (ds.Tables[0].Rows[0]["Uid"].ToString() != "") { model.Uid = int.Parse(ds.Tables[0].Rows[0]["Uid"].ToString()); } if (ds.Tables[0].Rows[0]["Retime"].ToString() != "") { model.Retime = DateTime.Parse(ds.Tables[0].Rows[0]["Retime"].ToString()); } if (ds.Tables[0].Rows[0]["Nowtime"].ToString() != "") { model.Nowtime = DateTime.Parse(ds.Tables[0].Rows[0]["Nowtime"].ToString()); } model.Timetype = ds.Tables[0].Rows[0]["Timetype"].ToString(); model.Ipaddress = ds.Tables[0].Rows[0]["Ipaddress"].ToString(); model.Timeinfo = ds.Tables[0].Rows[0]["Timeinfo"].ToString(); return(model); } else { return(null); } }
protected void btLogout_Click(object sender, EventArgs e) { string retime = "08:30:00"; Entity.TimeEntity timeEntity = new Entity.TimeEntity(); timeEntity.Uid = UserId; timeEntity.Nowtime = DateTime.Now; timeEntity.Retime = Convert.ToDateTime(retime); timeEntity.Timeinfo = this.txtLogout.Text; timeEntity.Timetype = this.btLogout0.Text; timeEntity.Ipaddress = Page.Request.UserHostAddress; int i = new JumbotOA.BLL.TimeBLL().Add(timeEntity); if (i > 0) { 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>"); } Selectinfo(wheres()); }
protected void btLeave_Click(object sender, EventArgs e) { string retime = "08:30:00"; Entity.TimeEntity timeEntity = new Entity.TimeEntity(); timeEntity.Uid = UserId; timeEntity.Nowtime = DateTime.Now; timeEntity.Retime = Convert.ToDateTime(retime); timeEntity.Timeinfo = this.txtLeave.Text; timeEntity.Timetype = this.btLeave0.Text; timeEntity.Ipaddress = Page.Request.UserHostAddress; int i = new Daiv_OA.BLL.TimeBLL().Add(timeEntity); if (i > 0) { System.Web.UI.Page page = (System.Web.UI.Page)System.Web.HttpContext.Current.Handler; Daiv_OA.Utils.QQRoHelp.SendClusterMessage("OA平台消息:" + UserName + "有事请假了。"); page.ClientScript.RegisterStartupScript(page.GetType(), "clientScript", "<script language='javascript'>alert('事病假登记成功!');</script>"); } Selectinfo(wheres()); }
protected void btOff_Click(object sender, EventArgs e) { //获取登记记录 string nowtime = DateTime.Now.ToString("yyyy-MM-dd"); bool isfirst1 = new JumbotOA.BLL.TimeBLL().Isfirst(UserId, "上班登记", nowtime); bool isfirst2 = new JumbotOA.BLL.TimeBLL().Isfirst(UserId, "下班登记", nowtime); if (isfirst1 == false)//没有上班登记,不允许下班登记 { 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>"); } else if (isfirst2 == true)//已经下班登记 { 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>"); } //不存在记录就登记 else { string retime = "17:30:00"; Entity.TimeEntity timeEntity = new Entity.TimeEntity(); timeEntity.Uid = UserId; timeEntity.Nowtime = DateTime.Now; timeEntity.Retime = Convert.ToDateTime(retime); timeEntity.Timeinfo = ""; timeEntity.Timetype = this.btOff.Text; timeEntity.Ipaddress = Page.Request.UserHostAddress; int i = new JumbotOA.BLL.TimeBLL().Add(timeEntity); if (i > 0) { System.Web.UI.Page page = (System.Web.UI.Page)System.Web.HttpContext.Current.Handler; JumbotOA.Utils.QQRobotHelp.SendClusterMessage("OA平台消息:" + UserName + "下班走了。"); page.ClientScript.RegisterStartupScript(page.GetType(), "clientScript", "<script language='javascript'>alert('下班登记成功!');</script>"); } } Selectinfo(wheres()); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Entity.TimeEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [OA_Time]("); strSql.Append("Uid,Retime,Nowtime,Timetype,Ipaddress,Timeinfo)"); strSql.Append(" values ("); strSql.Append("@Uid,@Retime,@Nowtime,@Timetype,@Ipaddress,@Timeinfo)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Uid", SqlDbType.Int, 4), new SqlParameter("@Retime", SqlDbType.DateTime), new SqlParameter("@Nowtime", SqlDbType.DateTime), new SqlParameter("@Timetype", SqlDbType.VarChar, 10), new SqlParameter("@Ipaddress", SqlDbType.VarChar, 30), new SqlParameter("@Timeinfo", SqlDbType.VarChar, 30) }; parameters[0].Value = model.Uid; parameters[1].Value = model.Retime; parameters[2].Value = model.Nowtime; parameters[3].Value = model.Timetype; parameters[4].Value = model.Ipaddress; parameters[5].Value = model.Timeinfo; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Entity.TimeEntity model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Entity.TimeEntity model) { return(dal.Add(model)); }
//获取 protected void btWork_Click(object sender, EventArgs e) { //获取登记记录 string nowtime = DateTime.Today.ToString("yyyy-MM-dd"); bool isfirst = new JumbotOA.BLL.TimeBLL().Isfirst(UserId, "上班登记", nowtime); if (isfirst == true) { Tools.Common.JavaScript.MessageBox(this,"您上班已经登记了!"); //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>"); } //不存在记录就登记 else { string retime = "08:30:00"; Entity.TimeEntity timeEntity = new Entity.TimeEntity(); timeEntity.Uid = UserId; timeEntity.Nowtime = DateTime.Now; timeEntity.Retime = Convert.ToDateTime(retime); timeEntity.Timeinfo = ""; timeEntity.Timetype = this.btWork.Text; timeEntity.Ipaddress = Page.Request.UserHostAddress; int i = new JumbotOA.BLL.TimeBLL().Add(timeEntity); if (i > 0) { Tools.Common.JavaScript.MessageBox(this,"上班登记成功!"); //System.Web.UI.Page page = (System.Web.UI.Page)System.Web.HttpContext.Current.Handler; //JumbotOA.Utils.QQRobotHelp.SendClusterMessage("OA平台消息:" + UserName + "上班来了。"); //page.ClientScript.RegisterStartupScript(page.GetType(), "clientScript", "<script language='javascript'>alert('上班登记成功!');</script>"); } } Selectinfo(wheres()); }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public Entity.TimeEntity GetEntity(int Tid) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 Tid,Uid,Retime,Nowtime,Timetype,Ipaddress,Timeinfo from [OA_Time] "); strSql.Append(" where Tid=@Tid "); SqlParameter[] parameters = { new SqlParameter("@Tid", SqlDbType.Int,4)}; parameters[0].Value = Tid; Entity.TimeEntity model=new Entity.TimeEntity(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["Tid"].ToString()!="") { model.Tid=int.Parse(ds.Tables[0].Rows[0]["Tid"].ToString()); } if(ds.Tables[0].Rows[0]["Uid"].ToString()!="") { model.Uid=int.Parse(ds.Tables[0].Rows[0]["Uid"].ToString()); } if(ds.Tables[0].Rows[0]["Retime"].ToString()!="") { model.Retime=DateTime.Parse(ds.Tables[0].Rows[0]["Retime"].ToString()); } if(ds.Tables[0].Rows[0]["Nowtime"].ToString()!="") { model.Nowtime=DateTime.Parse(ds.Tables[0].Rows[0]["Nowtime"].ToString()); } model.Timetype=ds.Tables[0].Rows[0]["Timetype"].ToString(); model.Ipaddress=ds.Tables[0].Rows[0]["Ipaddress"].ToString(); model.Timeinfo=ds.Tables[0].Rows[0]["Timeinfo"].ToString(); return model; } else { return null; } }
/// <summary> /// ��ҳ��ȡ�����б� /// </summary> public List<Entity.TimeEntity> getpage(int pageSize, int pageNum, out int count, string str) { string select, table, where, order; select = " * "; table = "[OA_Time] "; StringBuilder sb = new StringBuilder(); sb.Append(" ( 1 = 1 ) " + str); where = sb.ToString(); order = "Tid"; 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.TimeEntity> list = new List<Entity.TimeEntity>(); Entity.TimeEntity model; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { model = new Entity.TimeEntity(); if (ds.Tables[0].Rows[i]["Tid"].ToString() != "") { model.Tid = int.Parse(ds.Tables[0].Rows[i]["Tid"].ToString()); } if (ds.Tables[0].Rows[i]["Uid"].ToString() != "") { model.Uid = int.Parse(ds.Tables[0].Rows[i]["Uid"].ToString()); } model.Nowtime = Convert.ToDateTime(ds.Tables[0].Rows[i]["Nowtime"].ToString()); model.Retime = Convert.ToDateTime(ds.Tables[0].Rows[i]["Retime"].ToString()); model.Ipaddress = ds.Tables[0].Rows[i]["Ipaddress"].ToString(); model.Timeinfo = ds.Tables[0].Rows[i]["Timeinfo"].ToString(); model.Timetype = ds.Tables[0].Rows[i]["Timetype"].ToString(); list.Add(model); } return list; }