在读者登录图书馆网页以后,Gridview 进行绑定,如果发现有过期的书籍(当前时间>应还时间)就将数据插入"惩罚"表里
,这样的情况,如果只有一条数据那是很好处理的,但是如果有两条或者更多,就难办了,
尝试过用for(i=0;i<x;i++)这样的语句不行,希望大侠帮忙. public void insertPunishment()
{
string ReaderNumber = Session["ReaderNumber"].ToString(); //获取读者条形码
DateTime now = DateTime.Now.Date; string _chaoqi = "select * from Lib_BookBorrow where ReaderNumber='" + ReaderNumber + "'and (('" + now + "' > ShouldReturnTime and IsReturn='0' ) )";
int i = DataOperate.seleSQL(_chaoqi);
int j = 0;
for (j = 0; j <= i; j++)
{
SQLiteDataReader chaoqi = DataOperate.getRow(_chaoqi); if (chaoqi.Read())
{
string _shouldReturnTime = chaoqi["ShouldReturnTime"].ToString();
shouldReturnTime = Convert.ToDateTime(_shouldReturnTime);
string _realReturnTime = chaoqi["RealReturnTime"].ToString();
realReturnTime = Convert.ToDateTime(_realReturnTime);
string bookBarCode = chaoqi["BookBarCode"].ToString();
DateTime today = DateTime.Now.Date;
TimeSpan _overdueDay = today - shouldReturnTime;
int shouldPayMoney = _overdueDay.Days; int isDispose = Convert.ToInt32(0);
int isReturn = Convert.ToInt32(chaoqi["IsReturn"]);
chaoqi.Close();
if (isReturn == 1)
{
TimeSpan _isCouldReturn = realReturnTime - shouldReturnTime;
shouldPayMoney = _isCouldReturn.Days;
} string sql = "select IsDispose from [Lib_Punishment] where BookBarCode='" + bookBarCode + "'and ReaderNumber='" + ReaderNumber + "'and IsDispose='0'";
SQLiteDataReader dr = DataOperate.getRow(sql);
if (dr.Read())
{
dr.Close(); }
else
{ string sql2 = "insert into [Lib_Punishment] values(null,'" + bookBarCode + "','" + ReaderNumber + "','" + shouldPayMoney + "','" + isDispose + "')";
DataOperate.execSQL(sql2);
} } else
ClientScript.RegisterStartupScript(this.GetType(), "", "<Script>alert('未找到!')</Script>"); } }
,这样的情况,如果只有一条数据那是很好处理的,但是如果有两条或者更多,就难办了,
尝试过用for(i=0;i<x;i++)这样的语句不行,希望大侠帮忙. public void insertPunishment()
{
string ReaderNumber = Session["ReaderNumber"].ToString(); //获取读者条形码
DateTime now = DateTime.Now.Date; string _chaoqi = "select * from Lib_BookBorrow where ReaderNumber='" + ReaderNumber + "'and (('" + now + "' > ShouldReturnTime and IsReturn='0' ) )";
int i = DataOperate.seleSQL(_chaoqi);
int j = 0;
for (j = 0; j <= i; j++)
{
SQLiteDataReader chaoqi = DataOperate.getRow(_chaoqi); if (chaoqi.Read())
{
string _shouldReturnTime = chaoqi["ShouldReturnTime"].ToString();
shouldReturnTime = Convert.ToDateTime(_shouldReturnTime);
string _realReturnTime = chaoqi["RealReturnTime"].ToString();
realReturnTime = Convert.ToDateTime(_realReturnTime);
string bookBarCode = chaoqi["BookBarCode"].ToString();
DateTime today = DateTime.Now.Date;
TimeSpan _overdueDay = today - shouldReturnTime;
int shouldPayMoney = _overdueDay.Days; int isDispose = Convert.ToInt32(0);
int isReturn = Convert.ToInt32(chaoqi["IsReturn"]);
chaoqi.Close();
if (isReturn == 1)
{
TimeSpan _isCouldReturn = realReturnTime - shouldReturnTime;
shouldPayMoney = _isCouldReturn.Days;
} string sql = "select IsDispose from [Lib_Punishment] where BookBarCode='" + bookBarCode + "'and ReaderNumber='" + ReaderNumber + "'and IsDispose='0'";
SQLiteDataReader dr = DataOperate.getRow(sql);
if (dr.Read())
{
dr.Close(); }
else
{ string sql2 = "insert into [Lib_Punishment] values(null,'" + bookBarCode + "','" + ReaderNumber + "','" + shouldPayMoney + "','" + isDispose + "')";
DataOperate.execSQL(sql2);
} } else
ClientScript.RegisterStartupScript(this.GetType(), "", "<Script>alert('未找到!')</Script>"); } }
解决方案 »
- 求开源商城!来者有分!
- 为什么运行一个页面这么慢,原来都还好。急死人
- 一个简单问题
- 在ASP.NET里如何实现 不同项目之间会话状态的保持。。。
- 关于substring 的用法。怎么没效果。高手指点---没分了。抱歉哦
- 哪有下载ado.net的帮助文档?chm格式
- serv-u6.0编程
- 哥们门问个问题关于查询排序的sql 急急几 哥们求你们了
- 网页上有个图片游来游去的效果怎样做?
- 留言本的输入框 处理:this.Span1.InnerHtml="your favorites is <br>"+(this.content.Value).Replace("<","<").Replace(">", ">").R
- 将一张表的id重新排序
- 关于iisapi_rewrite中的cookie问题
·详情请访问:http://www.515dns.com
自己搜搜看
foreach (GridViewRow gr in this.gv.Rows)//
{}