protected void Button6_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
Lib.DataUtility du = new Lib.DataUtility();
string sqlcmd = string.Empty;
if (txtID_BMI.Text.Trim() != "" && txtCode.Text.Trim() != "" && txtCloNO.Text.Trim() != "")
{
try
{
sqlcmd = "select id from result where status in ('113','123') and id = @id";
dt = du.getDataTableByText(sqlcmd, "@id", txtID_BMI.Text.Trim());
if (dt.Rows.Count != 1)
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('BMI不合格出現筆數錯誤');", true);
}
else
{
// 有比對出資料
#region
dt.Clear();
sqlcmd = "select code from result where code = @code and status = '001'";
dt = du.getDataTableByText(sqlcmd, "@code", txtCode.Text.Trim());
if (dt.Rows.Count != 0)
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('該晶片使用中');", true);
}
else
{
dt.Clear();
sqlcmd = "select * from rfid where code = @code";
dt = du.getDataTableByText(sqlcmd, "@code", txtCode.Text.Trim());
if (dt.Rows.Count != 1)
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('該晶片內碼出現筆數錯誤');", true);
}
else
{
string lf_tag = dt.Rows[0]["LF_Tag_ID"].ToString();
string uhf_tag = dt.Rows[0]["UHF_Tag_ID"].ToString();
string memo = string.Empty;
//memo = DropDownList1.SelectedValue + DropDownList2.SelectedValue + DropDownList3.SelectedValue;
Dictionary <string, object> list = new Dictionary <string, object>();
list.Add("@id", txtID_BMI.Text.Trim());
list.Add("@code", txtCode.Text.Trim());
list.Add("@clothesNum", txtCloNO.Text.Trim());
list.Add("@LF_Tag_ID", lf_tag);
list.Add("@UHF_Tag_ID", uhf_tag);
sqlcmd = "update result set [status] = '001', [code] = @code, [clothesNum] = @clothesNum, [LF_Tag_ID] = @LF_Tag_ID, [UHF_Tag_ID] = @UHF_Tag_ID where id = @id";
du.executeNonQueryByText(sqlcmd, list);
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('該員重新檢錄完畢');", true);
// FOR 官校
#region FOR 官校
if (Lib.SysSetting.CenterCode == "9")
{
try
{
dt.Clear();
dt = du.getDataTableByText("select * from result where id = @id", "@id", txtID_BMI.Text.Trim());
dt.TableName = "forrunadd";
RemoteWS.WebService ws = new RemoteWS.WebService();
ws.Url = "http://10.116.53.41/Webservice.asmx";
ws.Discover();
ws.AddResultFor3KRun(dt);
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('該員重新檢錄完畢');", true);
}
catch (Exception ex)
{
sqlcmd = "update result set [op_id] = 'Fail' where id = @id";
du.executeNonQueryByText(sqlcmd, "@id", txtID_BMI.Text.Trim());
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('該員重新檢錄完畢，惟傳送受測資料至步校出現錯誤，請檢錄站人員稍後重新傳送');", true);
}
}
#endregion
}
}
#endregion
}
}
catch (Exception ex)
{
string msg = ex.InnerException.Message.Replace("'", "").Replace(@"/", "").Replace(@"\", "");
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('" + msg + "')", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('資料未輸入完畢');", true);
}
}
