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