提醒到期日期 [英] Alert For expire date

问题描述

嗨......

plz在c＃到期日期30天之前发送警报信息代码。

plz回复我.....

解决方案

string d1 = DateTime.Today.ToString（yyyy-MM-dd）;

string d2 = DateTime.Now.AddDays （30）.ToString（yyyy-MM-dd）;

string constr = ConfigurationManager.AppSettings（DEFAULT_PATH）。ToString（）;

SqlConnection con = new SqlConnection（constr）;

string sql =SELECT COUNT（vehicleid）FROM vehicle_master WHERE PUC> =''+ d1 +''和PUC< =''+ d2 +' ';;

con.Open（）;

SqlCommand cmd = new SqlCommand（sql，con）;

int temp = Convert.ToInt32 （cmd.ExecuteScalar（）。ToString（））;



con.Close（）;

if（（temp> 0） ）{

gvpuc.Visible = true;

DataTable dt = new DataTable（）;

string constr1 = ConfigurationManager.AppSettings（DEFAULT_PATH ）.ToString（）;

SqlConnect ion con1 = new SqlConnection（constr1）;

string sql1 =SELECT * FROM vehicle_master WHERE PUC> =''+ d1 +''和PUC< =''+ d2 +' ';;

SqlCommand cmd1 =新的SqlCommand（sql1，con1）;

con1.Open（）;

SqlDataReader dr1 = cmd1.ExecuteReader ;

dt.Load（dr1）;

gvpuc.DataSource = dt;

gvpuc.DataBind（）;

lblmsg.Visible = true;

lblmsg.Text =PUC由于过期。;

}其他{

gvpuc.Visible = false;

lblmsg.Visible = true;

lblmsg.Text =没有PUC即将到期。;

}

Hi......
plz send code for alert message before 30 days of expiry date in c#.
plz reply me.....

解决方案

string d1 = DateTime.Today.ToString("yyyy-MM-dd");
string d2 = DateTime.Now.AddDays(30).ToString("yyyy-MM-dd");
string constr = ConfigurationManager.AppSettings("DEFAULT_PATH").ToString();
SqlConnection con = new SqlConnection(constr);
string sql = "SELECT COUNT (vehicleid) FROM vehicle_master WHERE PUC>=''" + d1 + "'' and PUC<=''" + d2 + "''";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
int temp = Convert.ToInt32(cmd.ExecuteScalar().ToString());

con.Close();
if ((temp > 0)) {
gvpuc.Visible = true;
DataTable dt = new DataTable();
string constr1 = ConfigurationManager.AppSettings("DEFAULT_PATH").ToString();
SqlConnection con1 = new SqlConnection(constr1);
string sql1 = "SELECT * FROM vehicle_master WHERE PUC>=''" + d1 + "'' and PUC<=''" + d2 + "''";
SqlCommand cmd1 = new SqlCommand(sql1, con1);
con1.Open();
SqlDataReader dr1 = cmd1.ExecuteReader;
dt.Load(dr1);
gvpuc.DataSource = dt;
gvpuc.DataBind();
lblmsg.Visible = true;
lblmsg.Text = "PUC Due to Expire.";
} else {
gvpuc.Visible = false;
lblmsg.Visible = true;
lblmsg.Text = "No PUC that are Due to Expire.";
}

这篇关于提醒到期日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！