public static void TestReadVersion()
{
XmlRpcClient client = new XmlRpcClient();
client.Url = Url;
client.Path = "common";
XmlRpcResponse response = client.Execute("version");
Console.WriteLine("version");
Console.WriteLine("REQUEST: ");
client.WriteRequest(Console.Out);
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("RESPONSE: ");
client.WriteResponse(Console.Out);
Console.WriteLine();
Console.WriteLine();
if (response.IsFault())
{
Console.WriteLine(response.GetFaultString());
}
else
{
Console.WriteLine(response.GetString());
}
}
/// <summary>
/// </summary>
/// <param name="method"></param>
/// <param name="request">Full request to send to the master </param>
/// <param name="response">Full response including status code and status message. Initially empty.</param>
/// <param name="payload">Location to store the actual data requested, if any.</param>
/// <param name="wait_for_master">If you recieve an unseccessful status code, keep retrying.</param>
/// <returns></returns>
public static bool execute(string method, XmlRpcValue request, ref XmlRpcValue response, ref XmlRpcValue payload,
bool wait_for_master)
{
try
{
DateTime startTime = DateTime.Now;
string master_host = host;
int master_port = port;
//EDB.WriteLine("Trying to connect to master @ " + master_host + ":" + master_port);
XmlRpcClient client = XmlRpcManager.Instance.getXMLRPCClient(master_host, master_port, "/");
bool printed = false;
bool ok = true;
while (!client.IsConnected && !ROS.shutting_down && !XmlRpcManager.Instance.shutting_down ||
!(ok = client.Execute(method, request, response) && XmlRpcManager.Instance.validateXmlrpcResponse(method, response, ref payload)))
{
if (!wait_for_master)
{
XmlRpcManager.Instance.releaseXMLRPCClient(client);
return(false);
}
if (!printed)
{
EDB.WriteLine("[{0}] FAILED TO CONTACT MASTER AT [{1}:{2}]. {3}", method, master_host,
master_port, (wait_for_master ? "Retrying..." : ""));
printed = true;
}
if (retryTimeout.TotalSeconds > 0 && DateTime.Now.Subtract(startTime) > retryTimeout)
{
EDB.WriteLine("[{0}] Timed out trying to connect to the master after [{1}] seconds", method,
retryTimeout.TotalSeconds);
XmlRpcManager.Instance.releaseXMLRPCClient(client);
return(false);
}
Thread.Sleep(10);
}
if (ok && !firstsucces)
{
firstsucces = true;
//EDB.WriteLine(string.Format("CONNECTED TO MASTER AT [{0}:{1}]", master_host, master_port));
}
XmlRpcManager.Instance.releaseXMLRPCClient(client);
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(false);
}
public static void Test(String xmlcommand)
{
XmlRpcClient client = new XmlRpcClient();
client.Url = Url;
//client.Path = "common";
XmlRpcRequest requestCreate = new XmlRpcRequest(xmlcommand);
//XmlRpcResponse responseCreate = client.Execute(requestCreate);
client.Execute(requestCreate); //xml malformed error
client.WriteRequest(Console.Out);
Console.ReadKey();
}
private static bool Connect()
{
bool rc = false;
try
{
var DBPath = rootFolder + "ICM802.mdb";
conn = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;"
+ "Data Source=" + DBPath);
conn.Open();
client = new XmlRpcClient();
client.Url = odooUrl;
client.Path = "common";
// LOGIN
XmlRpcRequest requestLogin = new XmlRpcRequest("authenticate");
requestLogin.AddParams(db, user, pass, XmlRpcParameter.EmptyStruct());
responseLogin = client.Execute(requestLogin);
if (responseLogin.IsFault())
{
logger.Error("無法連線到 odoo 資料庫");
}
else
{
rc = true;
}
}
catch (Exception ex)
{
logger.Error(ex.Message, ex);
}
return(rc);
}
public bool Execute(string method, XmlRpcValue parameters, XmlRpcValue result)
{
lock (client_lock)
return(client.Execute(method, parameters, result));
}
private static string AddToOdoo(object[] pressValues)
{
string timestampStr = "";
try
{
string gear_qr = ((string)pressValues[0]).Trim();
string pinion_qr = ((string)pressValues[1]).Trim();
string product_model = (string)pressValues[2];
DateTime timestamp = (DateTime)pressValues[3];
timestampStr = timestamp.ToString();
float press_distance = float.Parse((string)pressValues[4]);
float press_duration = float.Parse((string)pressValues[5]);
float compressor_pressure = float.Parse((string)pressValues[6]);
float final_pressure = float.Parse((string)pressValues[7]);
float pos1_pressure = float.Parse((string)pressValues[8]);
float pos2_pressure = float.Parse((string)pressValues[9]);
float pos3_pressure = float.Parse((string)pressValues[10]);
float pos4_pressure = float.Parse((string)pressValues[11]);
float pos5_pressure = float.Parse((string)pressValues[12]);
string result = (string)pressValues[13];
string ng_reason = (string)pressValues[14];
string chartFileName = GetChartFile(timestamp);
if (chartFileName != "")
{
try
{
string destDir = rootFolder + @"110438";
if (!Directory.Exists(destDir))
{
Directory.CreateDirectory(destDir);
}
File.Copy(rootFolder + @"JPG\" + chartFileName, destDir + @"\" + chartFileName);
}
catch (Exception e1)
{
logger.Error(e1.Message, e1);
}
}
logger.Info("QR1: " + gear_qr);
logger.Info("QR2: " + pinion_qr);
logger.Info("Time: " + timestamp.ToString());
logger.Info("chart: " + chartFileName);
if (gear_qr == "" && pinion_qr == "")
{
logger.Warn("No QR code");
}
else
{
client.Path = "object";
List <object> domain = new List <object>();
if (gear_qr != "")
{
domain.Add(XmlRpcParameter.AsArray("gear_qr", "=", gear_qr));
}
if (pinion_qr != "")
{
domain.Add(XmlRpcParameter.AsArray("pinion_qr", "=", pinion_qr));
}
if (domain.Count == 2)
{
domain.Insert(0, "|");
}
XmlRpcRequest requestSearch = new XmlRpcRequest("execute_kw");
requestSearch.AddParams(db, responseLogin.GetInt(), pass, "batom.tesla.qrcode", "search_read",
XmlRpcParameter.AsArray(
domain
),
XmlRpcParameter.AsStruct(
XmlRpcParameter.AsMember("fields", XmlRpcParameter.AsArray("gear_qr", "pinion_qr"))
// ,XmlRpcParameter.AsMember("limit", 2)
)
);
XmlRpcResponse responseSearch = client.Execute(requestSearch);
if (responseSearch.IsFault())
{
logger.Error(responseSearch.GetFaultString());
}
else if (!responseSearch.IsArray())
{
logger.Error("查詢 odoo 資料庫異常");
}
else
{
int qr_id = -1; // used as the flag (ok: qr_id > 0)
List <Object> valueList = responseSearch.GetArray();
if (valueList.Count == 0)
{
Dictionary <string, object> values = new Dictionary <string, object>();
if (gear_qr != "")
{
values["gear_qr"] = gear_qr;
}
if (pinion_qr != "")
{
values["pinion_qr"] = pinion_qr;
}
XmlRpcRequest requestCreate = new XmlRpcRequest("execute_kw");
requestCreate.AddParams(db, responseLogin.GetInt(), pass, "batom.tesla.qrcode", "create",
XmlRpcParameter.AsArray(values)
);
XmlRpcResponse responseCreate = client.Execute(requestCreate);
if (responseCreate.IsFault())
{
logger.Error(responseCreate.GetFaultString());
}
else
{
qr_id = responseCreate.GetInt();
}
}
else
{
string db_gear_qr = "";
string db_pinion_qr = "";
foreach (Dictionary <string, object> valueDictionary in valueList)
{
foreach (KeyValuePair <string, object> kvp in valueDictionary)
{
if (kvp.Key == "id")
{
qr_id = (int)kvp.Value;
}
else if (kvp.Key == "gear_qr" && kvp.Value is string)
{
db_gear_qr = (string)kvp.Value;
}
else if (kvp.Key == "pinion_qr" && kvp.Value is string)
{
db_pinion_qr = (string)kvp.Value;
}
}
}
if ((gear_qr == "" || gear_qr == db_gear_qr) &&
(pinion_qr == "" || pinion_qr == db_pinion_qr))
{
// existing qr record, do nothing
}
else if (ValueConflict(gear_qr, db_gear_qr) ||
ValueConflict(pinion_qr, db_pinion_qr))
{
logger.Error("與資料庫中下列 QR code 組合衝突，無法儲存：\n" +
"軸： " + db_pinion_qr + "\n" +
"餅： " + db_gear_qr
);
}
else
{
Dictionary <string, object> values = new Dictionary <string, object>();
if (gear_qr != "")
{
values["gear_qr"] = gear_qr;
}
if (pinion_qr != "")
{
values["pinion_qr"] = pinion_qr;
}
XmlRpcRequest requestWrite = new XmlRpcRequest("execute_kw");
requestWrite.AddParams(db, responseLogin.GetInt(), pass, "batom.tesla.qrcode", "write",
XmlRpcParameter.AsArray(XmlRpcParameter.AsArray(qr_id), values)
);
XmlRpcResponse responseWrite = client.Execute(requestWrite);
if (responseWrite.IsFault())
{
logger.Error(responseWrite.GetFaultString());
qr_id = -1;
}
}
}
if (qr_id > 0)
{
domain = new List <object>();
domain.Add(XmlRpcParameter.AsArray("timestamp", "=", timestampStr));
requestSearch = new XmlRpcRequest("execute_kw");
requestSearch.AddParams(db, responseLogin.GetInt(), pass, "batom.tesla.press_info", "search_read",
XmlRpcParameter.AsArray(
domain
),
XmlRpcParameter.AsStruct(
XmlRpcParameter.AsMember("fields", XmlRpcParameter.AsArray("timestamp"))
// ,XmlRpcParameter.AsMember("limit", 2)
)
);
responseSearch = client.Execute(requestSearch);
if (responseSearch.IsFault())
{
logger.Error(responseSearch.GetFaultString());
}
else if (!responseSearch.IsArray())
{
logger.Error("查詢 odoo 資料庫異常");
}
else
{
valueList = responseSearch.GetArray();
if (valueList.Count > 0)
{
logger.Warn("壓配資料已存在");
}
else
{
Dictionary <string, object> values = new Dictionary <string, object>();
values["qr_id"] = qr_id;
values["product_model"] = product_model;
values["timestamp"] = timestampStr;
values["press_distance"] = press_distance;
values["press_duration"] = press_duration;
values["compressor_pressure"] = compressor_pressure;
values["final_pressure"] = final_pressure;
values["pos1_pressure"] = pos1_pressure;
values["pos2_pressure"] = pos2_pressure;
values["pos3_pressure"] = pos3_pressure;
values["pos4_pressure"] = pos4_pressure;
values["pos5_pressure"] = pos5_pressure;
values["result"] = result;
values["ng_reason"] = ng_reason;
values["chart_file_name"] = chartFileName;
if (chartFileName != "")
{
try
{
values["chart"] = Convert.ToBase64String(File.ReadAllBytes(rootFolder + @"JPG\" + chartFileName));
}
catch (Exception e2)
{
logger.Error(e2.Message, e2);
}
}
else
{
values["chart"] = false;
}
XmlRpcRequest requestCreate = new XmlRpcRequest("execute_kw");
requestCreate.AddParams(db, responseLogin.GetInt(), pass, "batom.tesla.press_info", "create",
XmlRpcParameter.AsArray(values)
);
XmlRpcResponse responseCreate = client.Execute(requestCreate);
if (responseCreate.IsFault())
{
logger.Error(responseCreate.GetFaultString());
}
}
}
}
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message, ex);
}
return(timestampStr);
}
private void Save()
{
string pressfit_qr = "";
string gear_qr = "";
string pinion_qr = "";
if (txtPressfit.Text != null)
{
pressfit_qr = txtPressfit.Text.Trim();
}
if (txtGear.Text != null)
{
gear_qr = txtGear.Text.Trim();
}
if (txtPinion.Text != null)
{
pinion_qr = txtPinion.Text.Trim();
}
if (pressfit_qr == "" && gear_qr == "" && pinion_qr == "")
{
MessageBox.Show("請掃描 QR Code", "錯誤");
}
else
{
try
{
Cursor.Current = Cursors.WaitCursor;
XmlRpcClient client = new XmlRpcClient();
client.Url = odooUrl;
client.Path = "common";
// LOGIN
XmlRpcRequest requestLogin = new XmlRpcRequest("authenticate");
requestLogin.AddParams(db, user, pass, XmlRpcParameter.EmptyStruct());
XmlRpcResponse responseLogin = client.Execute(requestLogin);
if (responseLogin.IsFault())
{
Cursor.Current = Cursors.Default;
MessageBox.Show("無法連線到資料庫，請通知 IT 人員", "錯誤");
}
else
{
client.Path = "object";
List <object> domain = new List <object>();
if (pressfit_qr != "")
{
domain.Add(XmlRpcParameter.AsArray("pressfit_qr", "=", pressfit_qr));
}
if (gear_qr != "")
{
domain.Add(XmlRpcParameter.AsArray("gear_qr", "=", gear_qr));
}
if (pinion_qr != "")
{
domain.Add(XmlRpcParameter.AsArray("pinion_qr", "=", pinion_qr));
}
if (domain.Count >= 2)
{
if (domain.Count == 3)
{
domain.Insert(0, "|");
}
domain.Insert(0, "|");
}
XmlRpcRequest requestSearch = new XmlRpcRequest("execute_kw");
requestSearch.AddParams(db, responseLogin.GetInt(), pass, "batom.tesla.qrcode", "search_read",
XmlRpcParameter.AsArray(
domain
),
XmlRpcParameter.AsStruct(
XmlRpcParameter.AsMember("fields", XmlRpcParameter.AsArray("pressfit_qr", "gear_qr", "pinion_qr"))
// ,XmlRpcParameter.AsMember("limit", 2)
)
);
XmlRpcResponse responseSearch = client.Execute(requestSearch);
if (responseSearch.IsFault())
{
MessageBox.Show(responseSearch.GetFaultString(), "錯誤");
}
else if (!responseSearch.IsArray())
{
Cursor.Current = Cursors.Default;
MessageBox.Show("查詢資料庫異常，請通知 IT 人員", "錯誤");
}
else
{
List <Object> valueList = responseSearch.GetArray();
if (valueList.Count == 0)
{
Dictionary <string, object> values = new Dictionary <string, object>();
if (pressfit_qr != "")
{
values["pressfit_qr"] = pressfit_qr;
}
if (gear_qr != "")
{
values["gear_qr"] = gear_qr;
}
if (pinion_qr != "")
{
values["pinion_qr"] = pinion_qr;
}
XmlRpcRequest requestCreate = new XmlRpcRequest("execute_kw");
requestCreate.AddParams(db, responseLogin.GetInt(), pass, "batom.tesla.qrcode", "create",
XmlRpcParameter.AsArray(values)
);
XmlRpcResponse responseCreate = client.Execute(requestCreate);
if (responseCreate.IsFault())
{
MessageBox.Show(responseCreate.GetFaultString(), "錯誤");
}
else
{
AutoClosingMessageBox.Show("已儲存", "完成", 1000);
ClearFields();
}
}
else
{
string db_pressfit_qr = "";
string db_gear_qr = "";
string db_pinion_qr = "";
int id = -1;
foreach (Dictionary <string, object> valueDictionary in valueList)
{
foreach (KeyValuePair <string, object> kvp in valueDictionary)
{
if (kvp.Key == "id")
{
id = (int)kvp.Value;
}
else if (kvp.Key == "pressfit_qr" && kvp.Value is string)
{
db_pressfit_qr = (string)kvp.Value;
}
else if (kvp.Key == "gear_qr" && kvp.Value is string)
{
db_gear_qr = (string)kvp.Value;
}
else if (kvp.Key == "pinion_qr" && kvp.Value is string)
{
db_pinion_qr = (string)kvp.Value;
}
}
}
if ((pressfit_qr == "" || pressfit_qr == db_pressfit_qr) &&
(gear_qr == "" || gear_qr == db_gear_qr) &&
(pinion_qr == "" || pinion_qr == db_pinion_qr))
{
Cursor.Current = Cursors.Default;
MessageBox.Show("QR code 組合已存在", "錯誤");
}
else if (ValueConflict(pressfit_qr, db_pressfit_qr) ||
ValueConflict(gear_qr, db_gear_qr) ||
ValueConflict(pinion_qr, db_pinion_qr))
{
Cursor.Current = Cursors.Default;
MessageBox.Show("與資料庫中下列 QR code 組合衝突，無法儲存：\n\n" +
"總成：" + db_pressfit_qr + "\n" +
"軸： " + db_pinion_qr + "\n" +
"餅： " + db_gear_qr,
"錯誤"
);
}
else
{
Dictionary <string, object> values = new Dictionary <string, object>();
if (pressfit_qr != "")
{
values["pressfit_qr"] = pressfit_qr;
}
if (gear_qr != "")
{
values["gear_qr"] = gear_qr;
}
if (pinion_qr != "")
{
values["pinion_qr"] = pinion_qr;
}
XmlRpcRequest requestWrite = new XmlRpcRequest("execute_kw");
requestWrite.AddParams(db, responseLogin.GetInt(), pass, "batom.tesla.qrcode", "write",
XmlRpcParameter.AsArray(XmlRpcParameter.AsArray(id), values)
);
XmlRpcResponse responseWrite = client.Execute(requestWrite);
if (responseWrite.IsFault())
{
MessageBox.Show(responseWrite.GetFaultString(), "錯誤");
}
else
{
AutoClosingMessageBox.Show("已儲存", "完成", 1000);
ClearFields();
}
}
}
}
Cursor.Current = Cursors.Default;
}
}
catch
{
MessageBox.Show("無法儲存，請通知IT人員", "錯誤");
}
}
}
public static void TestReadRecords()
{
XmlRpcClient client = new XmlRpcClient();
client.Url = Url;
client.Path = "common";
// LOGIN
XmlRpcRequest requestLogin = new XmlRpcRequest("authenticate");
requestLogin.AddParams(db, user, pass, XmlRpcParameter.EmptyStruct());
XmlRpcResponse responseLogin = client.Execute(requestLogin);
// Console.WriteLine("authenticate");
// Console.WriteLine("REQUEST: ");
// client.WriteRequest(Console.Out);
// Console.WriteLine();
// Console.WriteLine();
// Console.WriteLine("RESPONSE: ");
// client.WriteResponse(Console.Out);
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("LOGIN: "******"object";
XmlRpcRequest requestSearch = new XmlRpcRequest("execute_kw");
requestSearch.AddParams(db, responseLogin.GetInt(), pass, "res.partner", "search",
XmlRpcParameter.AsArray(
XmlRpcParameter.AsArray(
XmlRpcParameter.AsArray("is_company", "=", true), XmlRpcParameter.AsArray("customer", "=", true)
)
)
);
requestSearch.AddParamStruct(
XmlRpcParameter.AsMember("limit", 2)
);
XmlRpcResponse responseSearch = client.Execute(requestSearch);
// Console.WriteLine();
// Console.WriteLine();
// Console.WriteLine("search");
// Console.WriteLine("REQUEST: ");
// client.WriteRequest(Console.Out);
// Console.WriteLine();
// Console.WriteLine();
// Console.WriteLine("RESPONSE: ");
// client.WriteResponse(Console.Out);
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("SEARCH: ");
if (responseSearch.IsFault())
{
Console.WriteLine(responseSearch.GetFaultString());
}
else
{
Console.WriteLine(responseSearch.GetString());
}
// READ
XmlRpcRequest requestRead = new XmlRpcRequest("execute_kw");
requestRead.AddParams(db, responseLogin.GetInt(), pass, "res.partner", "read",
XmlRpcParameter.AsArray(
responseSearch.GetArray()
)
);
requestRead.AddParamStruct(XmlRpcParameter.AsMember("fields",
XmlRpcParameter.AsArray("name")
)
);
XmlRpcResponse responseRead = client.Execute(requestRead);
// Console.WriteLine();
// Console.WriteLine();
// Console.WriteLine("read");
// Console.WriteLine("REQUEST: ");
// client.WriteRequest(Console.Out);
// Console.WriteLine();
// Console.WriteLine();
// Console.WriteLine("RESPONSE: ");
// client.WriteResponse(Console.Out);
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("READ: ");
if (responseRead.IsFault())
{
Console.WriteLine(responseRead.GetFaultString());
}
else
{
Console.WriteLine(responseRead.GetString());
}
}
public static void TestCreateRecord()
{
XmlRpcClient client = new XmlRpcClient();
client.Url = Url;
client.Path = "common";
// LOGIN
XmlRpcRequest requestLogin = new XmlRpcRequest("authenticate");
requestLogin.AddParams(db, user, pass, XmlRpcParameter.EmptyStruct());
XmlRpcResponse responseLogin = client.Execute(requestLogin);
Console.WriteLine("authenticate");
Console.WriteLine("REQUEST: ");
client.WriteRequest(Console.Out);
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("RESPONSE: ");
client.WriteResponse(Console.Out);
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("LOGIN: "******"object";
XmlRpcRequest requestCreate = new XmlRpcRequest("execute_kw");
requestCreate.AddParams(db, responseLogin.GetInt(), pass, "res.partner", "create",
XmlRpcParameter.AsArray(
XmlRpcParameter.AsStruct(
XmlRpcParameter.AsMember("name", "Albert Einstein")
, XmlRpcParameter.AsMember("image", Convert.ToBase64String(File.ReadAllBytes("img/einstein.jpg")))
, XmlRpcParameter.AsMember("email", "*****@*****.**")
)
)
);
XmlRpcResponse responseCreate = client.Execute(requestCreate);
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("create");
Console.WriteLine("REQUEST: ");
client.WriteRequest(Console.Out);
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("RESPONSE: ");
client.WriteResponse(Console.Out);
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("READ: ");
if (responseCreate.IsFault())
{
Console.WriteLine(responseCreate.GetFaultString());
}
else
{
Console.WriteLine(responseCreate.GetString());
}
}