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;
}
}
