/// <summary> /// 获得数据列表 /// </summary> /// <param name="pb">分页基本信息</param> /// <param name="count">返回总数</param> /// <returns></returns> public List <Tunnel.Model.Tunnel_workplan> GetList(PageBase pb, ref int count) { DataTable dt = dal.GetList(pb, ref count).Tables[0]; List <Tunnel.Model.Tunnel_workplan> modelList = new List <Tunnel.Model.Tunnel_workplan>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0 && pb.DoCount == 0) { Tunnel.Model.Tunnel_workplan model; for (int n = 0; n < rowsCount; n++) { model = new Tunnel.Model.Tunnel_workplan(); model.w_id = Convert.ToInt64(dt.Rows[n]["w_id"].ToString()); model.w_title = dt.Rows[n]["w_title"].ToString(); model.w_content = dt.Rows[n]["w_content"].ToString(); if (dt.Rows[n]["w_starttime"].ToString() != "") { model.w_starttime = DateTime.Parse(dt.Rows[n]["w_starttime"].ToString()); } if (dt.Rows[n]["w_endtime"].ToString() != "") { model.w_endtime = DateTime.Parse(dt.Rows[n]["w_endtime"].ToString()); } model.w_depict = dt.Rows[n]["w_depict"].ToString(); if (dt.Rows[n]["w_user"].ToString() != "") { model.w_user = int.Parse(dt.Rows[n]["w_user"].ToString()); } modelList.Add(model); } } return(modelList); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["id"])) { Tunnel.BLL.Tunnel_workplan tw = new Tunnel.BLL.Tunnel_workplan(); Tunnel.Model.Tunnel_workplan tww = tw.GetModel(int.Parse(Request.QueryString["id"].ToString())); Label1.Text = tww.w_title; Label2.Text = tww.w_starttime.ToString(); Label4.Text = tww.w_content; if (tww.w_endtime.ToString() == "1800-01-01 0:00:00") { Label3.Text = "不提醒"; } else { Label3.Text = tww.w_endtime.ToString(); } } else { Response.Redirect("Default.aspx"); } } }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Tunnel.Model.Tunnel_workplan model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@w_id", SqlDbType.BigInt, 8), new SqlParameter("@w_title", SqlDbType.VarChar, 200), new SqlParameter("@w_content", SqlDbType.Text), new SqlParameter("@w_starttime", SqlDbType.DateTime), new SqlParameter("@w_endtime", SqlDbType.DateTime), new SqlParameter("@w_depict", SqlDbType.VarChar, 1000), new SqlParameter("@w_user", SqlDbType.Int, 4), new SqlParameter("@w_ip", SqlDbType.VarChar, 20) }; parameters[0].Value = model.w_id; parameters[1].Value = model.w_title; parameters[2].Value = model.w_content; parameters[3].Value = model.w_starttime; parameters[4].Value = model.w_endtime; parameters[5].Value = model.w_depict; parameters[6].Value = model.w_user; parameters[7].Value = model.w_Ip; int relt = -1; if (DateTime.Compare(model.w_endtime, DateTime.Now.Date) > -1) { relt = DbHelperSQL.RunProcedure("Tunnel_workplan_Update", parameters, out rowsAffected); } return(relt); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Tunnel.Model.Tunnel_workplan model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@w_id", SqlDbType.BigInt, 8), new SqlParameter("@w_title", SqlDbType.VarChar, 200), new SqlParameter("@w_content", SqlDbType.Text), new SqlParameter("@w_starttime", SqlDbType.DateTime), new SqlParameter("@w_endtime", SqlDbType.DateTime), new SqlParameter("@w_depict", SqlDbType.VarChar, 1000), new SqlParameter("@w_user", SqlDbType.Int, 4), new SqlParameter("@w_ip", SqlDbType.VarChar, 20), }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.w_title; parameters[2].Value = model.w_content; parameters[3].Value = model.w_starttime; parameters[4].Value = model.w_endtime; parameters[5].Value = model.w_depict; parameters[6].Value = model.w_user; parameters[7].Value = model.w_Ip; DbHelperSQL.RunProcedure("Tunnel_workplan_ADD", parameters, out rowsAffected); int relt = -1; relt = Convert.ToInt32(parameters[0].Value); return(relt); }
protected void Button1_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(TextBox1.Text.Trim())) { if (Tunnel.Common.RegexComm.IsValidTime(text1.Value, 1)) { Tunnel.BLL.Tunnel_workplan tw = new Tunnel.BLL.Tunnel_workplan(); Tunnel.Model.Tunnel_workplan tww = new Tunnel.Model.Tunnel_workplan(); Tunnel.BLL.UserLogin ul = new Tunnel.BLL.UserLogin(); tww.w_user = ul.LoginID; tww.w_title = TextBox1.Text; tww.w_starttime = Convert.ToDateTime(text1.Value); switch (DropDownList1.SelectedValue) { case "0": tww.w_endtime = Convert.ToDateTime("1800-01-01"); break; case "1": tww.w_endtime = tww.w_starttime.AddMinutes(-10); break; case "2": tww.w_endtime = tww.w_starttime.AddMinutes(-30); break; case "3": tww.w_endtime = tww.w_starttime.AddMinutes(-60); break; case "4": tww.w_endtime = tww.w_starttime.Date; break; case "5": tww.w_endtime = tww.w_starttime; break; default: break; } tww.w_content = TextBox2.Text; int id = tw.Add(tww); //添加消息机制 call(tww.w_title, id.ToString(), tww.w_endtime); // Tunnel.Common.Message.Show("添加成功!"); } else { Tunnel.Common.Message.Show("日期格式不正确!"); } } else { Tunnel.Common.Message.Show("请填写标题!"); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Tunnel.Model.Tunnel_workplan GetModel(int w_id) { SqlParameter[] parameters = { new SqlParameter("@w_id", SqlDbType.Int) }; parameters[0].Value = w_id; Tunnel.Model.Tunnel_workplan model = new Tunnel.Model.Tunnel_workplan(); DataSet ds = DbHelperSQL.RunProcedure("Tunnel_workplan_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["w_id"].ToString() != "") { model.w_id = long.Parse(ds.Tables[0].Rows[0]["w_id"].ToString()); } model.w_title = ds.Tables[0].Rows[0]["w_title"].ToString(); model.w_content = ds.Tables[0].Rows[0]["w_content"].ToString(); if (ds.Tables[0].Rows[0]["w_starttime"].ToString() != "") { model.w_starttime = DateTime.Parse(ds.Tables[0].Rows[0]["w_starttime"].ToString()); } if (ds.Tables[0].Rows[0]["w_endtime"].ToString() != "") { model.w_endtime = DateTime.Parse(ds.Tables[0].Rows[0]["w_endtime"].ToString()); } model.w_depict = ds.Tables[0].Rows[0]["w_depict"].ToString(); if (ds.Tables[0].Rows[0]["w_user"].ToString() != "") { model.w_user = int.Parse(ds.Tables[0].Rows[0]["w_user"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 获得数据列表 /// </summary> public List <Tunnel.Model.Tunnel_workplan> DataTableToList(DataTable dt) { List <Tunnel.Model.Tunnel_workplan> modelList = new List <Tunnel.Model.Tunnel_workplan>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Tunnel.Model.Tunnel_workplan model; for (int n = 0; n < rowsCount; n++) { model = new Tunnel.Model.Tunnel_workplan(); model.w_id = Convert.ToInt64(dt.Rows[n]["w_id"].ToString()); model.w_title = dt.Rows[n]["w_title"].ToString(); model.w_content = dt.Rows[n]["w_content"].ToString(); model.w_depict = dt.Rows[n]["w_depict"].ToString(); model.w_endtime = Convert.ToDateTime(dt.Rows[n]["w_endtime"].ToString()); model.w_starttime = Convert.ToDateTime(dt.Rows[n]["w_starttime"].ToString()); model.w_user = Convert.ToInt32(dt.Rows[n]["w_user"].ToString()); modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Tunnel.Model.Tunnel_workplan model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Tunnel.Model.Tunnel_workplan model) { return(dal.Add(model)); }