public static bool MakeGastroscopeExamination(GastroscopeInfo item)
{
// GastroscopeInfo gastroscope = new GastroscopeInfo(from_picture, diagnoses, picture);
OracleCommand cmd = new OracleCommand();
cmd.Connection = DatabaseHelper.GetInstance().conn;
cmd.Transaction = DatabaseHelper.GetInstance().conn.BeginTransaction();
try
{
string sqlStr =
@"insert into Gastroscope(exam_id,from_picture,diagnoses,picture)
values(:exam_id,:frompicture,:diagnoses,:picture)";
cmd.CommandText = sqlStr;
cmd.Parameters.Add("exam_id", item.exam_id);
cmd.Parameters.Add("frompicture", OracleDbType.Varchar2, 2000).Value = item.from_picture;
cmd.Parameters.Add("diagnoses", OracleDbType.Varchar2, 2000).Value = item.diagnoses;
cmd.Parameters.Add("picture", OracleDbType.Varchar2, 200).Value = item.picture;
cmd.ExecuteNonQuery();
cmd.Transaction.Commit();
return(true);
}
catch (Exception e)
{
cmd.Transaction.Rollback();
throw e;
return(false);
}
return(false);
}
private async Task <Object> ReadAndSaveFile()
{
string root = System.Web.HttpContext.Current.Server.MapPath("~/App_Data/Uploads");
var provider = new MultipartFormDataStreamProvider(root);
await Request.Content.ReadAsMultipartAsync(provider);
FileInfo finfo = new FileInfo(provider.FileData.First().LocalFileName);
string guid = Guid.NewGuid().ToString();
string path = Path.Combine(root, guid + "_" + provider.FileData.First().Headers.ContentDisposition.FileName.Replace("\"", ""));
File.Move(finfo.FullName, path);
var formData = provider.FormData;
int type = 10;
try
{
type = int.Parse(formData.GetValues("type").FirstOrDefault());
}
catch (Exception e)
{
throw e;
}
// 新建一个对象
Object info = new object();
string exam_id;
string checkpoint;
string from_picture;
string picture;
string diagnoses;
switch (type)
{
case 0:
break;
case 1:
exam_id = formData.GetValues("exam_id").FirstOrDefault();
diagnoses = formData.GetValues("diagnoses").FirstOrDefault();
from_picture = formData.GetValues("from_picture").FirstOrDefault();
info = new GastroscopeInfo(exam_id, from_picture, diagnoses, path);
break;
case 2:
exam_id = formData.GetValues("exam_id").FirstOrDefault();
checkpoint = formData.GetValues("checkpoint").FirstOrDefault();
from_picture = formData.GetValues("from_picture").FirstOrDefault();
info = new XrayInfo(exam_id, checkpoint, from_picture, path);
break;
default:
return(null);
}
return(info);
}
