bool SubmitResult_lineleader(double dValue)
{
string strTaskCode, strMac;
string remark = DatabaseFunc.Context.ContextData["Key1"].ToString() + ",线长上传";
try
{
if (!DatabaseFunc.GetInfo(m_strSN, out strTaskCode, out strMac))
{
ShowResult("获取工单信息失败", eState.eFail);
return(false);
}
if (!DatabaseFunc.SaveResult_Weight("", strTaskCode, strMac, m_strSN, dValue.ToString("f4"), remark))
{
ShowResult("上传测试记录失败", eState.eFail);
return(false);
}
return(true);
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
bool SubmitResult(double dValue)
{
string strTaskCode, strMac;
string remark = "Down:" + txtDown.Text + ",Up:" + txtUp.Text;
try
{
if (!DatabaseFunc.GetInfo(m_strSN, out strTaskCode, out strMac))
{
ShowResult("获取工单信息失败", eState.eFail);
return(false);
}
if (!DatabaseFunc.SaveResult_Weight("", strTaskCode, strMac, m_strSN, dValue.ToString("f4"), remark))
{
ShowResult("上传测试记录失败", eState.eFail);
return(false);
}
return(true);
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
private void FormLogin_Load(object sender, EventArgs e)
{
DataTable dt = DatabaseFunc.GetAccountInfo();
m_UserList.Clear();
m_PwdList.Clear();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; ++i)
{
m_UserList.Add(dt.Rows[i]["Fusername"].ToString());
m_PwdList.Add(dt.Rows[i]["Fpassword"].ToString());
}
}
else
{
MessageBox.Show("获取账号信息失败");
return;
}
}
else
{
MessageBox.Show("获取账号信息失败");
return;
}
DataView dv = new DataView(dt);
cmbUser.DataSource = dv;
cmbUser.DisplayMember = "fusername";
}
/// <summary>
/// Silence when error occur.
/// </summary>
public static T Execute <T>(string name, DatabaseFunc <Database, T> func)
{
T result = default(T);
try
{
using (Database db = new Database(name))
{
result = func(db);
}
}
catch (Exception ex)
{
TraceLogger.Instance.WriteException(ex);
//throw;
}
return(result);
}
/// <summary>
/// throw Exception when error.
/// </summary>
public static T Invoke <T>(DatabaseFunc <Database, T> func)
{
T result;
try
{
using (Database db = new Database())
{
result = func(db);
}
}
catch (Exception ex)
{
TraceLogger.Instance.WriteException(ex);
throw;
}
return(result);
}
bool SubmitResult_math(double dValue, out double fweight_c, out int fweight_num)
{
string strTaskCode, strMac;
fweight_c = 0;
fweight_num = 0;
string remark = "称重计算产品";
try
{
if (!DatabaseFunc.GetInfo(m_strSN, out strTaskCode, out strMac))
{
ShowResult("获取工单信息失败", eState.eFail);
return(false);
}
if (!DatabaseFunc.SaveResult_Weight("", strTaskCode, strMac, m_strSN, dValue.ToString("f4"), remark))
{
ShowResult("上传测试记录失败", eState.eFail);
return(false);
}
if (!DatabaseFunc.GetWeight_coefficient(strTaskCode, out fweight_c))
{
ShowResult("获取称重系数失败", eState.eFail);
return(false);
}
if (!DatabaseFunc.GetWeight_num(strTaskCode, out fweight_num))
{
ShowResult("获取称重个数失败", eState.eFail);
return(false);
}
return(true);
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
void InitFunc()
{
if (!File.Exists(AppDomain.CurrentDomain.BaseDirectory + "Config.ini"))
{
MessageBox.Show(AppDomain.CurrentDomain.BaseDirectory + "Config.ini" + "文件不存在");
return;
}
//读取配置文件，加载账号、密码、工位码
string[] lines = File.ReadAllLines(AppDomain.CurrentDomain.BaseDirectory + "Config.ini", System.Text.Encoding.GetEncoding("GB2312"));
string serverIp = "", database = "", user = "", pwd = "";
foreach (string line in lines)
{
if (line.Contains("OperatorID"))
{
m_strOperatorID = line.Substring(line.IndexOf("=") + 1);
}
if (line.Contains("UnitID"))
{
m_strUnitid = line.Substring(line.IndexOf("=") + 1);
}
if (line.Contains("ServerIP"))
{
serverIp = line.Substring(line.IndexOf("=") + 1);
}
if (line.Contains("Database"))
{
database = line.Substring(line.IndexOf("=") + 1);
}
if (line.Contains("user"))
{
user = line.Substring(line.IndexOf("=") + 1);
}
if (line.Contains("pwd"))
{
pwd = line.Substring(line.IndexOf("=") + 1);
}
}
try
{
if (m_bInitOK)
{
m_Port.Close();
m_bInitOK = false;
RefreshUI(m_bInitOK);
ShowIpInfo(serverIp);
}
else
{
m_bInitOK = false;
RefreshUI(m_bInitOK);
ShowIpInfo(serverIp);
do
{
string strConnectString = string.Format("database={0};Server={1},1433;User ID={2};Password={3}", database, serverIp, user, pwd);
if (DatabaseFunc.Connect_DataBase(strConnectString) == null)
{
m_bInitOK = false;
MessageBox.Show("连接数据库失败，请检查网络以及服务器地址");
break;
}
if (!OpenPort())
{
m_bInitOK = false;
}
m_bInitOK = true;
} while (false);
RefreshUI(m_bInitOK);
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 建立資料庫命令產生器。
/// </summary>
private IDbCommandBuilder CreateDbCommandBuilder()
{
return(DatabaseFunc.CreateDbCommandBuilder(this.SessionInfo, this.ProgramDefine));
}
