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