public ActionResult GetPayPateint() { try { DataSet _PatData = new DataSet(); if (!IPatCon.ConInit(out str_msg)) { ViewBag.Message = str_msg; ViewBag.PatientDate = null; return(View()); } else { if (IPatOraCon.ConInit(out str_msg)) { DataSet _dataSet = new DataSet(); IPatOraCon.ConInit(out str_msg); if (IPatOraCon.SelPayPatient(out str_msg, out _dataSet)) { List <string[]> arr2_insertValues = new List <string[]>(); DataTable _dataTable = _dataSet.Tables[0]; for (int i = 0; i < _dataTable.Rows.Count; i++) { PatientModel _patientModel = new PatientModel(); _patientModel.PatName = _dataTable.Rows[i]["病人姓名"] + ""; _patientModel.PatIdCardNo = _dataTable.Rows[i]["身份证"] + ""; _patientModel.PatOutCardNo = _dataTable.Rows[i]["卡号"] + ""; _patientModel.PatSex = _dataTable.Rows[i]["性别"] + ""; _patientModel.SendDeptName = _dataTable.Rows[i]["开方科室"] + ""; _patientModel.TelphoneNo = _dataTable.Rows[i]["电话"] + ""; string str_paymentDate = _dataTable.Rows[i]["日期"] + ""; string str_Brithday = _dataTable.Rows[i]["出生日期"] + ""; DateTime _briDateTime = DateTime.Parse(str_Brithday); DateTime _payDateTime = DateTime.Parse(str_paymentDate); _patientModel.PaymentDate = string.IsNullOrEmpty(str_paymentDate) ? string.Empty : string.Format("{0:yyyy-MM-dd}", _payDateTime); _patientModel.PatBrithday = string.IsNullOrEmpty(str_Brithday) ? string.Empty : string.Format("{0:yyyy-MM-dd}", _briDateTime); _patientModel.PatAge = Convert.ToInt32(((_payDateTime - _briDateTime).TotalDays / 365)); _patientModel.IsRead = 1; string[] arr_check = { _patientModel.PatName, _patientModel.PatIdCardNo }; string[] arr_ValueTmp = { _patientModel.PatName.ConvertSqlCondition() , _patientModel.PatSex.ConvertSqlCondition() , _patientModel.PatBrithday.ConvertSqlCondition() , _patientModel.PatAge.ToString() , _patientModel.PatIdCardNo.ConvertSqlCondition() , _patientModel.SendDeptId.ConvertSqlCondition() , _patientModel.SendDeptName.ConvertSqlCondition() , _patientModel.PatOutCardNo.ToUpper().ConvertSqlCondition() , _patientModel.TelphoneNo.ConvertSqlCondition() , _patientModel.PaymentDate.ConvertSqlCondition() , _patientModel.Remark.ConvertSqlCondition() }; if (IPatCon.CheckPatIsRead(out str_msg, arr_check)) { arr2_insertValues.Add(arr_ValueTmp); } } if (arr2_insertValues != null) { IPatCon.InsertPatInformation(out str_msg, arr2_insertValues); } if (IPatCon.SelPatInformation(out str_msg, out _PatData, string.Empty)) { var _PatTable = _PatData.Tables[0]; var arr_PatModel = Convert <PatientModel> .ConvertToList(_PatTable); ViewBag.PatientDate = arr_PatModel.ToList <PatientModel>(); } PartialViewResult x = PartialView("/Views/Patient/GetPatient.cshtml"); return(x); } else { throw new Exception(str_msg); } } else { throw new Exception(str_msg); } } } catch (Exception ex) { throw ex; } }