/// <summary> /// 写入Mysql数据 /// </summary> /// <param name="examinedby"></param> /// <param name="WriteString"></param> private void WriteMysql(string observation_id, string examined_by, String WriteString) { Encription encription = new Encription(); ANICshare share = new ANICshare(); string dbHost = "192.168.0.10"; string dbPort = "3366"; string dbUser = "******"; //資料庫使用者帳號 string dbPass = "******"; //資料庫使用者密碼 string dbName = "alpine"; //資料庫名稱 string db_testName = "alpine_test"; //資料庫名稱 string LoginName = "100053"; //資料庫名稱 string LoginPass = "******"; //資料庫名稱 share.dbHost = dbHost; share.dbPort = dbPort; share.dbUser = dbUser; share.dbPass = dbPass; share.dbName = dbName; share.db_testName = db_testName; share.refresh_connection(); // CExecSql sql = new CExecSql(); // sql.SaveImage(examinedby, Convert.FromBase64String(WriteString)); StringBuilder sql = new StringBuilder(); bool insert = false; String photo_id_str = ""; string photo_id = share.Get_mysql_database_MaxID("care_wound_document", "wound_photo_id"); // string ordering = share.Get_mysql_database_MaxID_ordering("care_wound_document", "ordering", string.Format("observation_id = {0}", observation_id)); string ordering = share.Get_mysql_database_MaxID_ordering("care_wound_document", "ordering", string.Format("observation_id = {0}", observation_id)); string[] values = new string[] { photo_id, observation_id, ordering, examined_by }; sql.Append("Insert into care_wound_document(wound_photo_id,observation_id,ordering,created_by,created_datetime,document_photo) Values({0},{1},{2},'{3}',now(),?parval);"); // String cmdText = "select * from client_documents2 Where client_photo_id IN (@id) and valid = 'Y'"; // sql.Append("select document_photo from client_documents2 Where client_photo_id = '{0}' and valid = 'Y';"); string comm = string.Format(sql.ToString(), values); //byte[] image_bytes = Convert.FromBase64String(photo_data); int a = share.ExecBoldSql(comm.ToString(), WriteString); if (a > 0) { insert = true; } }
public String PostFile() { ANICshare share = new ANICshare(); ClientImageInfo image_info = new ClientImageInfo(); share.dbHost = dbHost; share.dbPort = dbPort; share.dbUser = dbUser; share.dbPass = dbPass; share.dbName = dbName; share.db_testName = db_testName; image_info.dbHost = dbHost; image_info.dbPort = dbPort; image_info.dbUser = dbUser; image_info.dbPass = dbPass; image_info.dbName = dbName; image_info.db_testName = db_testName; share.refresh_connection(); var context = (HttpContextBase)Request.Properties["MS_HttpContext"]; context.Request.InputStream.Seek(0, SeekOrigin.Begin); String ret = string.Empty; using (var sr = new StreamReader(context.Request.InputStream, Encoding.UTF8, true, 1024, true)) { string observation_id = ""; string examined_by = ""; string command = ""; string[] bodyValues = sr.ReadToEnd().Split(';'); try { command = share.dencry_value(bodyValues[0]); observation_id = share.dencry_value(bodyValues[2]); examined_by = share.dencry_value(bodyValues[3]); } catch (Exception) { throw; } if (!share.dencry_value(bodyValues[1]).Equals(dbUser)) { return(null); } ///0; db_name; oberserver_id; examineby; path; StartIndex; PhotoBytes switch (command) { case "0": //登陆 // if (bodyValues[1] == "admin" && bodyValues[2] == "123456") // { ret = image_info.CreateNewFile(bodyValues[6]); //删除除了今天创建的文件。保存目录下只留下今天的文件。 try { image_info.DeleteOldDayFile(); } catch (Exception e) { return(e.Message); } return(ret); // } break; case "1": //追到到指定文件当中 ret = image_info.AppandToFile(bodyValues[4], bodyValues[5], bodyValues[6]); break; case "2": //完成文件的上传。 ret = image_info.CmpleteUpLoadFile(bodyValues[4], observation_id, examined_by, bodyValues[6]); break; case "3": //完成文件的上传。 ret = "Cancel Upload"; try { File.Delete(@bodyValues[3]); } catch (Exception e) { return(e.Message + "\n" + @bodyValues[3]); } break; } } return("true"); }