我想在系统日期=最后日期时移动或删除数据... [英] i want to move or delete the data when system date = last date...
本文介绍了我想在系统日期=最后日期时移动或删除数据...的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想在系统日期=上次日期时移动或删除数据...
i want to move or delete the data when system date = last date...
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<cc1:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
<table width="50%" align="center">
<tr>
<td align="right">
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td align="right">
<asp:Label ID="lblstart" runat="server" Font-Bold="True" Text="StartDate:">
</td>
<td>
</td>
<td>
<asp:TextBox ID="txtstart" runat="server">
<cc1:CalendarExtender ID="CalendarExtender1" runat="server" TargetControlID="txtstart">
</td>
<td>
</td>
</tr>
<%--<tr>
<td align="right">
Upload Image:</td>
<td>
</td>
<td>
<asp:FileUpload ID="fileuploadimages" runat="server" />
</td>
<td>
</td>
</tr>
<tr>
<td align="right">
Enter Image Desc</td>
<td>
</td>
<td>
<asp:TextBox ID="txtDesc" runat="server">
</td>
<td>
</td>
</tr>--%>
<tr>
<td align="right">
<asp:Label ID="lblEnd" runat="server" Font-Bold="True" Text="EndDate:">
</td>
<td>
</td>
<td>
<asp:TextBox ID="txtEnd" runat="server">
<cc1:CalendarExtender ID="CalendarExtender2" runat="server" TargetControlID="txtEnd" >
</td>
<td>
</td>
</tr>
<tr>
<td align="right">
</td>
<td>
</td>
<td>
<asp:Label ID="diffrence" runat="server">
</td>
<td>
</td>
</tr>
<tr>
<td>
</td>
<td>
</td>
<td>
<asp:Button ID="btncreat" runat="server" onclick="btncreat_Click"
Text="Submit" />
</td>
<td>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
代码部分 -
code part--
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btncreat_Click(object sender, EventArgs e)
{
int Totaldays = duration(txtstart.Text, txtEnd.Text);
diffrence.Text = Convert.ToString(Totaldays);
}
public int duration(string startdate, string enddate)
{
DateTime dt1 = DateTime.Parse(Convert.ToDateTime(txtstart.Text).ToString("MM/dd/yyyy"));
DateTime dt2 = DateTime.Parse(Convert.ToDateTime(txtEnd.Text).ToString("MM/dd/yyyy"));
TimeSpan ts = dt2.Subtract(dt1);
int days = ts.Days;
return days;
}
}
推荐答案
亲爱的,你需要这类问题在数据库中使用触发器。
Dear for this kind of problem you need to use trigger in database.
这篇关于我想在系统日期=最后日期时移动或删除数据...的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文