//获取当前账号的测试站位
private string getTestCode(string tt_username)
{
string tt_testcode = "";
string tt_sql1 = "select count(1),min(Fcode),0 " +
" from odc_fhpassword where Fname = '" + tt_username + "' ";
string[] tt_array1 = new string[3];
tt_array1 = Dataset1.GetDatasetArrayTwo(tt_sql1, tt_conn);
if (tt_array1[0] == "1")
{
tt_testcode = tt_array1[1];
}
else
{
MessageBox.Show("当前用户号：" + tt_username + "没有找到设定的待测站位，请确认");
}
return(tt_testcode);
}
//获取密码
private string GetUserPassword(string tt_username)
{
string tt_password = "******";
string tt_sql = "select count(1),min(fpassword),min(Fcode) " +
" from odc_fhpassword where Fname = '" + tt_username + "' ";
string[] tt_array = new string[3];
tt_array = Dataset1.GetDatasetArrayTwo(tt_sql, tt_conn);
if (tt_array[0] == "1")
{
tt_password = tt_array[1];
}
else
{
MessageBox.Show("网络连接失败，或没有" + tt_username + "此账号，请确认");
}
return(tt_password);
}
//获取小版本
private string GetProgramVersion2(string tt_programname)
{
string tt_newversion = "";
string tt_sql = "select count(1),min(fremark),0 " +
" from odc_fhpassword where Fname = '" + tt_programname + "' ";
string[] tt_array = new string[3];
tt_array = Dataset1.GetDatasetArrayTwo(tt_sql, tt_conn);
if (tt_array[0] == "1")
{
tt_newversion = tt_array[1];
}
else
{
MessageBox.Show("网络连接失败，或没有" + tt_programname + "此程序账号，请确认");
}
return(tt_newversion);
}
//流程检查，获取下一流程
private bool GetNextCode(string tt_task, string tt_username)
{
Boolean tt_flag = false;
//第一步获取当前站位
Boolean tt_flag1 = false;
string tt_testcode = "";
string tt_sql1 = "select count(1),min(Fcode),0 " +
" from odc_fhpassword where Fname = '" + tt_username + "' ";
string[] tt_array1 = new string[3];
tt_array1 = Dataset1.GetDatasetArrayTwo(tt_sql1, tt_conn);
if (tt_array1[0] == "1")
{
tt_testcode = tt_array1[1];
tt_flag1 = true;
}
else
{
MessageBox.Show("当前用户号：" + tt_username + "没有找到设定的待测站位，请确认");
}
//第二步获取当前站位
Boolean tt_flag2 = false;
string tt_firstcode = "";
string tt_ccode = "";
string tt_process = "";
if (tt_flag1)
{
string tt_sql2 = "select count(1),min(b.PXID) ,min(a.GYID) " +
"from odc_tasks a,odc_routing b " +
"WHERE a.GYID=b.PID AND b.LCBZ=1 AND a.TASKSCODE='" + tt_task + "' ";
string[] tt_array2 = new string[3];
tt_array2 = Dataset1.GetDatasetArray(tt_sql2, tt_conn);
if (tt_array2[0] == "1")
{
tt_firstcode = tt_array2[1];
tt_ccode = tt_testcode;
tt_process = tt_array2[2];
tt_flag2 = true;
}
else
{
MessageBox.Show("该工单没有配置流程,请检查流程位置工单表以及流程表！");
}
}
//第三步检查第一站位与设定的站位是否一致
Boolean tt_flag3 = false;
if (tt_flag1 && tt_flag2)
{
if (tt_ccode == tt_testcode)
{
tt_flag3 = true;
}
else
{
MessageBox.Show("程序设定待测站位与流程的第一站位不匹配，请检查！");
}
}
//第四步 获取下一站位
Boolean tt_flag4 = false;
string tt_ncode = "";
if (tt_flag1 && tt_flag2 && tt_flag3)
{
string tt_sql4 = "select count(1),min(z.pxid),min(z.lcbz) " +
" from odc_tasks t,odc_routing z " +
" where t.gyid=z.pid and t.taskscode='" + tt_task + "' " +
" and z.lcbz in( select (lcbz+1) lcbz " +
"from odc_tasks a,odc_routing b " +
"where b.pid=a.gyid and b.pxid='" + tt_ccode + "' " +
" and a.taskscode='" + tt_task + "') ";
string[] tt_array4 = new string[3];
tt_array4 = Dataset1.GetDatasetArray(tt_sql4, tt_conn);
if (tt_array4[0] == "1")
{
tt_flag4 = true;
tt_ncode = tt_array4[1];
}
else
{
MessageBox.Show("该工单流程配置异常,有前站位没有后站位，请检查流程位置工单表以及流程表!");
}
}
if (tt_flag1 && tt_flag2 && tt_flag3 && tt_flag4)
{
tt_flag = true;
this.textBox2.Text = tt_ccode;
this.textBox4.Text = tt_ncode;
}
return(tt_flag);
}