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 !=
ListItemType.Item && e
.Item.ItemType !=
ListItemType.Alternating
Item)
{
return;
}
// 获取当前绑定的数据项
DataRowView rowView = e
.Item.Data
Item as DataRowView;
if (rowView
== null)
{
return;
}
// 获取控件
Label lbl
ItemPeriodType = e
.Item.FindControl("lbl
ItemPeriodType") as Label;
Label lbl
ItemStartTime = e
.Item.FindControl("lbl
ItemStartTime") as Label;
Label lbl
ItemEndTime = e
.Item.FindControl("lbl
ItemEndTime") as Label;
// 检查控件是否存在
if (lbl
ItemPeriodType
== null || lbl
ItemStartTime
== null || lbl
ItemEndTime
== null)
{
return;
}
// 设置时段类型
string dwsd = rowView["dwsd"]
.ToString();
lbl
ItemPeriodType
.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 periodType = ddlPeriodType
.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", periodType);
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", periodType);
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
ItemPeriodType = (Label)
item.FindControl("lbl
ItemPeriodType");
Label lbl
ItemStartTime = (Label)
item.FindControl("lbl
ItemStartTime");
Label lbl
ItemEndTime = (Label)
item.FindControl("lbl
ItemEndTime");
string periodType = lbl
ItemPeriodType
.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", periodType);
cmd
.Parameters
.AddWithValue("@qshour", startTime);
cmd
.Parameters
.AddWithValue("@jshour", endTime);
conn
.Open();
cmd
.ExecuteNonQuery();
conn
.Close();
}
// 重新加载数据
LoadAllTimePeriods();
// 构建删除成功消息
string periodTypeName = GetPeriodTypeName(periodType);
ShowMessage($"已删除{periodTypeName}时段：{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 GetPeriodTypeName(string periodType)
{
switch (periodType)
{
case "尖期":
return "尖期";
case "峰期":
return "峰期";
case "平期":
return "平期";
case "谷期":
return "谷期";
default:
return periodType;
}
}
// 显示消息
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
.GetType(), "showModal", script, true);
}
}
}使用
c#编程，为什么在删除时段信息后没有提示框
本文详细解释了如何在数据绑定场景下获取列表控件中的行内容或控件，包括基本行、交替行、标题行等内容，并通过代码示例展示了如何使用ListItemType枚举来判断项类型。
扫一扫
227
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
