using System;
using System
.Configuration;
using System
.Data;
using System
.Data
.SqlClient;
using System
.Linq;
using System
.Web;
using System
.Web
.UI;
using System
.Web
.UI
.WebControls;
namespace Q4_WEB
{
public partial class Q4_MAIN : System
.Web
.UI
.Page
{
// 数据库连接字符串
private string connectionString
= ConfigurationManager
.ConnectionStrings["EaPumpConnectionString"]
.ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// 页面首次加载时加载所有时段数据
LoadAllTimePeriods();
}
}
// 加载所有时段数据到Repeater控件
private void LoadAllTimePeriods()
{
using (SqlConnection conn
= new SqlConnection(connectionString))
{
string query
= "SELECT dwsd, qshour, jshour FROM Eamain ORDER BY CASE dwsd WHEN '尖期' THEN 1 WHEN '峰期' THEN 2 WHEN '平期' THEN 3 WHEN '谷期' THEN 4 END, qshour";
SqlCommand cmd
= new SqlCommand(query, conn);
SqlDataAdapter da
= new SqlDataAdapter(cmd);
DataTable dt
= new DataTable();
conn
.Open();
da
.Fill(dt);
conn
.Close();
// 将数据绑定到Repeater控件
rptTimePeriods
.DataSource
= dt;
rptTimePeriods
.DataBind();
}
}
// 在Repeater数据绑定完成后处理时间显示
protected void rptTimePeriods_
ItemDataBound(object sender, Repeater
ItemEventArgs e)
{
if (e
== null)
{
return;
}
if (e
.Item == null)
{
return;
}
// 只处理数据项和交替数据项
if (e
.Item.ItemType !
= List
ItemType.Item && e
.Item.ItemType !
= List
ItemType.Alternating
Item)
{
return;
}
// 获取当前绑定的数据项
DataRowView rowView
= e
.Item.Data
Item as DataRowView;
if (rowView
== null)
{
return;
}
// 获取控件
Label lbl
ItemPeriod
Type = e
.Item.FindControl("lbl
ItemPeriod
Type") as Label;
Label lbl
ItemStartTime
= e
.Item.FindControl("lbl
ItemStartTime") as Label;
Label lbl
ItemEndTime
= e
.Item.FindControl("lbl
ItemEndTime") as Label;
// 检查控件是否存在
if (lbl
ItemPeriod
Type == null || lbl
ItemStartTime
== null || lbl
ItemEndTime
== null)
{
return;
}
// 设置时段类型
string dwsd
= rowView["dwsd"]
.ToString();
lbl
ItemPeriod
Type.Text
= dwsd;
// 设置开始时间
string qshour
= rowView["qshour"]
.ToString();
lbl
ItemStartTime
.Text
= qshour;
// 设置结束时间
string jshour
= rowView["jshour"]
.ToString();
lbl
ItemEndTime
.Text
= jshour;
}
// 添加时段按钮点击事件
protected void btnAddPeriod_Click(object sender, EventArgs e)
{
try
{
// 获取输入值
string period
Type = ddlPeriod
Type.SelectedValue;
string startHour
= ddlStartHour
.SelectedValue;
string startMinute
= ddlStartMinute
.SelectedValue;
string endHour
= ddlEndHour
.SelectedValue;
string endMinute
= ddlEndMinute
.SelectedValue;
// 组合时间格式
string startTime
= $"{startHour}:{startMinute}";
string endTime
= $"{endHour}:{endMinute}";
// 检查是否存在相同时间段
bool exists
= false;
using (SqlConnection conn
= new SqlConnection(connectionString))
{
string query
= "SELECT COUNT(*) FROM Eamain WHERE dwsd
= @dwsd AND qshour
= @qshour AND jshour
= @jshour";
SqlCommand cmd
= new SqlCommand(query, conn);
cmd
.Parameters
.AddWithValue("@dwsd", period
Type);
cmd
.Parameters
.AddWithValue("@qshour", startTime);
cmd
.Parameters
.AddWithValue("@jshour", endTime);
conn
.Open();
int count
= (int)cmd
.ExecuteScalar();
conn
.Close();
exists
= (count > 0);
}
if (exists)
{
// 存在相同时间段，显示提示信息
ShowMessage("已添加该时段，请检查！", false);
return;
}
// 添加新时段
using (SqlConnection conn
= new SqlConnection(connectionString))
{
string query
= "INSERT INTO Eamain (dwsd, qshour, jshour) VALUES (@dwsd, @qshour, @jshour)";
SqlCommand cmd
= new SqlCommand(query, conn);
cmd
.Parameters
.AddWithValue("@dwsd", period
Type);
cmd
.Parameters
.AddWithValue("@qshour", startTime);
cmd
.Parameters
.AddWithValue("@jshour", endTime);
conn
.Open();
int rowsAffected
= cmd
.ExecuteNonQuery();
conn
.Close();
}
// 重新加载数据
LoadAllTimePeriods();
ShowMessage("时段已成功添加！", true);
}
catch (Exception ex)
{
ShowMessage("添加失败：" + ex
.Message, false);
}
}
// 删除时段按钮点击事件
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
Button btn
= (Button)sender;
Repeater
Item item = (Repeater
Item)btn
.NamingContainer;
// 获取要删除的时段信息
Label lbl
ItemPeriod
Type = (Label)
item.FindControl("lbl
ItemPeriod
Type");
Label lbl
ItemStartTime
= (Label)
item.FindControl("lbl
ItemStartTime");
Label lbl
ItemEndTime
= (Label)
item.FindControl("lbl
ItemEndTime");
string period
Type = lbl
ItemPeriod
Type.Text;
string startTime
= lbl
ItemStartTime
.Text;
string endTime
= lbl
ItemEndTime
.Text;
// 删除时段
using (SqlConnection conn
= new SqlConnection(connectionString))
{
string query
= "DELETE FROM Eamain WHERE dwsd
= @dwsd AND qshour
= @qshour AND jshour
= @jshour";
SqlCommand cmd
= new SqlCommand(query, conn);
cmd
.Parameters
.AddWithValue("@dwsd", period
Type);
cmd
.Parameters
.AddWithValue("@qshour", startTime);
cmd
.Parameters
.AddWithValue("@jshour", endTime);
conn
.Open();
cmd
.ExecuteNonQuery();
conn
.Close();
}
// 重新加载数据
LoadAllTimePeriods();
// 构建删除成功消息
string period
TypeName
= GetPeriod
TypeName(period
Type);
ShowMessage($"已删除{period
TypeName}时段：{startTime}到{endTime}", true);
}
catch (Exception ex)
{
ShowMessage("删除失败：" + ex
.Message, false);
}
}
// 保存所有时段按钮点击事件
protected void btnSaveAll_Click(object sender, EventArgs e)
{
try
{
// 由于时段列表现在是只读显示模式，保存所有按钮不再需要执行复杂操作
// 只需显示提示信息
ShowMessage("所有时段已保存！", true);
}
catch (Exception ex)
{
ShowMessage("保存失败：" + ex
.Message, false);
}
}
// 获取时段类型中文名称
private string GetPeriod
TypeName(string period
Type)
{
switch (period
Type)
{
case "尖期":
return "尖期";
case "峰期":
return "峰期";
case "平期":
return "平期";
case "谷期":
return "谷期";
default:
return period
Type;
}
}
// 显示消息
private void ShowMessage(string message, bool isSuccess)
{
// 直接在客户端脚本中设置模态框内容并显示，确保消息能正确显示
string safeMessage
= message
.Replace("'", "\\'");
string script
= $@"$(function() {{
$('#messageModal
.modal-body')
.html('<p>{safeMessage}</p>');
$('#messageModal')
.modal({{ show: true, backdrop: 'static' }});
}});";
ScriptManager
.RegisterStartupScript(Page, Page
.Get
Type(), "showModal", script, true);
}
}
}使用c#编程，为什么在删除时段信息后没有提示框
本文详细介绍了 ASP.NET 中 DataList 控件的 ListItemType 枚举使用方法及如何通过 ItemDataBound 事件来区分不同的控件元素类型，如内容项、交替项和表头等。
扫一扫
225
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
