public ActionResult DeleteConfirmed(int id)
{
ReturnVisit returnVisit = db.returnVisits.Find(id);
db.returnVisits.Remove(returnVisit);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,scannum,Identinum,VisitId,Date,Name,returnvisit,returnvisitcontent,returnvisitdate")] ReturnVisit returnVisit)
{
if (ModelState.IsValid)
{
db.Entry(returnVisit).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(returnVisit));
}
public ActionResult Create([Bind(Include = "Id,scannum,Identinum,VisitId,Date,Name,returnvisit,returnvisitcontent,returnvisitdate")] ReturnVisit returnVisit)
{
if (ModelState.IsValid)
{
db.returnVisits.Add(returnVisit);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(returnVisit));
}
// GET: ReturnVisits/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ReturnVisit returnVisit = db.returnVisits.Find(id);
if (returnVisit == null)
{
return(HttpNotFound());
}
return(View(returnVisit));
}
public ActionResult Index(DateTime dt1, int page = 1)
{
string d = dt1.ToString("yyyy-MM-dd");
List <ReturnVisit> listreturnvisits = new List <ReturnVisit>();
MySqlConnection mysql = getMySqlConnection();
string sql = "SELECT `user` .`name`,`user`.phone,`user`.identinum,followup.id,followup.visit,followup.scannum,followup.weijing_check," +
"followup.weijing_check_time,followup.weinianmo_check,followup.weinianmo_check_time,followup.youmen_check," +
"followup.youmen_check_time,followup.other_check,followup.other_check_time,followup.youmen_treat," +
"followup.youmen_treat_time,followup.operater_treat,followup.operater_treat_time,followup.other_treat," +
"followup.other_treat_time FROM `user`,followup WHERE`user`.scannum = followup.scannum AND(weijing_check_time ='" +
d + "'OR weinianmo_check_time = '" + d + "'OR youmen_check_time = '" + d + "'OR other_check_time = '" + d + "'OR youmen_treat_time ='" +
d + "'OR operater_treat_time = '" + d + "'OR other_treat_time = '" + d + "');";
MySqlCommand mySqlCommand = getSqlCommand(sql, mysql);
mysql.Open();
MySqlDataReader reader = mySqlCommand.ExecuteReader();
try
{
while (reader.Read())
{
if (reader.HasRows)
{
ReturnVisit returnVisit = new ReturnVisit();
returnVisit.flag_time = dt1;
returnVisit.Id = reader.GetInt32("id");
returnVisit.Name = reader.GetString("name");
returnVisit.VisitId = reader.GetString("visit");
returnVisit.scannum = reader.GetString("scannum");
returnVisit.Identinum = reader.GetString("identinum");
returnVisit.weijing_check = reader.GetInt32("weijing_check");
returnVisit.weijing_check_time = reader.GetDateTime("weijing_check_time");
returnVisit.weinianmo_check = reader.GetInt32("weinianmo_check");
returnVisit.weinianmo_check_time = reader.GetDateTime("weinianmo_check_time");
returnVisit.youmen_check = reader.GetInt32("youmen_check");
returnVisit.youmen_check_time = reader.GetDateTime("youmen_check_time");
returnVisit.other_check = reader.GetInt32("other_check");
returnVisit.other_check_time = reader.GetDateTime("other_check_time");
returnVisit.operater_treat = reader.GetInt32("operater_treat");
returnVisit.operater_treat_time = reader.GetDateTime("operater_treat_time");
returnVisit.youmen_treat = reader.GetInt32("youmen_treat");
returnVisit.youmen_treat_time = reader.GetDateTime("youmen_treat_time");
returnVisit.other_treat = reader.GetInt32("other_treat");
returnVisit.other_treat_time = reader.GetDateTime("other_treat_time");
listreturnvisits.Add(returnVisit);
}
}
}
catch
{
return(HttpNotFound());
}
finally
{
mysql.Close();
}
const int pagesize = 8;
var data = listreturnvisits
.OrderBy(p => p.Id).ToPagedList(page, pagesize);
return(View(data));
}
// GET: ReturnVisits/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ReturnVisit returnVisit = new ReturnVisit();
MySqlConnection mysql = getMySqlConnection();
string d = DateTime.Now.ToString("yyyy-MM-dd");
string sql = "SELECT `user` .`name`,`user`.phone,`user`.identinum,followup.id,followup.visit,followup.scannum,followup.weijing_check," +
"followup.weijing_check_time,followup.weinianmo_check,followup.weinianmo_check_time,followup.youmen_check," +
"followup.youmen_check_time,followup.other_check,followup.other_check_time,followup.youmen_treat," +
"followup.youmen_treat_time,followup.operater_treat,followup.operater_treat_time,followup.other_treat," +
"followup.other_treat_time FROM `user`,followup WHERE`user`.scannum = " +
"followup.scannum and followup.id=" + id;
MySqlCommand mySqlCommand = getSqlCommand(sql, mysql);
mysql.Open();
MySqlDataReader reader = mySqlCommand.ExecuteReader();
try
{
while (reader.Read())
{
if (reader.HasRows)
{
returnVisit.Id = reader.GetInt32("id");
returnVisit.Name = reader.GetString("name");
returnVisit.VisitId = reader.GetString("visit");
returnVisit.scannum = reader.GetString("scannum");
returnVisit.Identinum = reader.GetString("identinum");
returnVisit.weijing_check = reader.GetInt32("weijing_check");
returnVisit.weijing_check_time = reader.GetDateTime("weijing_check_time");
returnVisit.weinianmo_check = reader.GetInt32("weinianmo_check");
returnVisit.weinianmo_check_time = reader.GetDateTime("weinianmo_check_time");
returnVisit.youmen_check = reader.GetInt32("youmen_check");
returnVisit.youmen_check_time = reader.GetDateTime("youmen_check_time");
returnVisit.other_check = reader.GetInt32("other_check");
returnVisit.other_check_time = reader.GetDateTime("other_check_time");
returnVisit.operater_treat = reader.GetInt32("operater_treat");
returnVisit.operater_treat_time = reader.GetDateTime("operater_treat_time");
returnVisit.youmen_treat = reader.GetInt32("youmen_treat");
returnVisit.youmen_treat_time = reader.GetDateTime("youmen_treat_time");
returnVisit.other_treat = reader.GetInt32("other_treat");
returnVisit.other_treat_time = reader.GetDateTime("other_treat_time");
}
}
reader.Close();
}
catch
{
return(HttpNotFound());
}
finally
{
reader.Close();
}
if (returnVisit == null)
{
return(HttpNotFound());
}
return(View(returnVisit));
}