Tak Tahu Nak Gune Method Ape..

[gadisPurple 0]

Sy kn buat system pasal blood test, User kn isi 15 value bg kod/item brdasarkn slip ujian drh yg diorg buat . Cont: WBC = 14.3, RBC = 3.70.
Stiap kod/item trsebut ade range dye contoh 0-3.4= LOW, 3.5-11=MEDIUM, 11.1-25.0=HIGH. Range tuk stiap kod/items da simpan dlm dtbase( tp xtahu la betul ke x cara nk smpanye; sy buat 4 kolum :1)KOD 2)STATUS(low,medium,high) 3)START RANGE 4)END RANGE))

Mslhnyer xtahu camne bndingkn value yg user masukkn dgn range yg ade dlm dtbase ni..xtahu nk gune method ape..Lps tu setiap nilai range bg kod/item
ade kombinasi yg memngkinkn user 2 berisiko sakit ape..Cont: RBC=LOW, HGB=LOW, MCH=LOW, MCHC=LOW, HCT=LOW, HGB=LOW brkmungkinan sakit Anemia. Camne nk buat kombinasi 2?..gune IF..ELSE k?..betul2 xtahu...harap sgt2 pakar leh tlg.. :-( :-(




[code]using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;

public partial class FullBloodCount : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
String UserID = UserTextBox0.Text;
String WBC = WBCTextBox.Text;
String RBC = PLTTextBox.Text;
String HGB = HGBTextBox1.Text;
String HCT = HCTTextBox2.Text;
String PLT = PLTTextBox.Text;
String PCT = PCTTextBox.Text;
String MCV = MCVTextBox.Text;
String MCH = MCHTextBox.Text;
String MCHC = MCHCTextBox.Text;
String RDW = RDWTextBox.Text;
String MPV = MPVTextBox.Text;
String PDW = PDWTextBox.Text;
String LYM = LYMTextBox.Text;
String MON = MONTextBox.Text;
String GRA = GRATextBox.Text;

int returnValue = 0;
SqlConnection connection = new SqlConnection(@"Data Source=SY-PC\SQLEXPRESS;Database=eBLOOD;Trusted_Connection=False; " + " User ID=sa;Password=sa");
try
{
connection.Open();

string insertString = "insert into dbo.UserInformation (UserID, WBC, RBC, HGB, HCT, PLT, PCT, MCV, MCH, MCHC, RDW, MPV, PDW, LYM, MON, GRA) values('" + UserID + "', '" + WBC + "','" + RBC + "', '" + HGB + "', '" + HCT + "', '" + PLT + "','" + PCT + "', '" + MCV + "', '" + MCH + "', '" + MCHC + "','" + RDW + "','" + MPV + "', '" + PDW + "','" + LYM + "','" + MON +"','" + GRA +" '); ";

SqlCommand cmd = new SqlCommand(insertString, connection);

returnValue = cmd.ExecuteNonQuery();

}
catch (Exception a)
{
String sError = a.Message.ToString();

}
finally
{
connection.Close();
}

if (returnValue > 0)
{

Response.Write("<script>alert('" + "PLEASE WAIT" + "');window.location='ValidTesting.aspx'</script>");
}
else
Response.Write("<script>alert('" + "Please Enter All The Information Again" + "');window.location='CompleteBloodCount.aspx'</script>");
}


}[/code] Edited October 26, 2010 by akuccputsedut

[akuccputsedut 147]

buat system nih guna pe..?? visual studio ker..??

[DevGuy 0]

dia buat guna asp.net laa ngan visual studio laa. dah tentu kat atas tu ada using... ngan web ui huhu sure la dia pakai c# ngan asp.net. ok gadis purple dah add me lom nnati chatt laa senang jerr huhuhuh

[akuccputsedut 147]

[quote name='DevGuy' date='28 October 2010 - 08:58 AM' timestamp='1288227537' post='1051600']
dia buat guna asp.net laa ngan visual studio laa. dah tentu kat atas tu ada using... ngan web ui huhu sure la dia pakai c# ngan asp.net. ok gadis purple dah add me lom nnati chatt laa senang jerr huhuhuh
[/quote]

oo yer ker.. sorry la tak berapa pandai... gadis purple cakap dia PM hang devguy.. ha chat laa lagi senang yek.. aku pung sampai pening fikir apa yang dia nak 2 hari dah dok chat ngan aku...

[TOYSЯUS 62]

Dah settle ke belum?

Saya rasa nak senang guna method IF-ELSE.

Tapi, betul ke simpan range dalam database?
Macam mana rupa table database tu yer.. huhu.
Sebab rasanya range tu buat masa nak compare range dalam IF ELSE nnt..

Saya boleh bagi contoh kalau coding dalam PHP sbb saya tak tau ASP..
Nanti jap lg saya bagi cth tu, kalau faham nanti boleh "convert" ke coding ASP je.

[gadisPurple 0]

[quote name='TOYSЯUS' date='28 October 2010 - 10:22 AM' timestamp='1288232561' post='1051609']
Dah settle ke belum?

Saya rasa nak senang guna method IF-ELSE.

Tapi, betul ke simpan range dalam database?
Macam mana rupa table database tu yer.. huhu.
Sebab rasanya range tu buat masa nak compare range dalam IF ELSE nnt..

Saya boleh bagi contoh kalau coding dalam PHP sbb saya tak tau ASP..
Nanti jap lg saya bagi cth tu, kalau faham nanti boleh "convert" ke coding ASP je.
[/quote]


sbb range ni berbeza..depend pd mesin yg proses blood test 2..so value dye blh berubah2 la..ke nk buat hard code?..sbb 2 tugas admin yg tentukn range bg setiap item..

[DevGuy 0]

tak per benda tu senang jer range tu pun ok jer. tak per senang jer leh settle.

[TOYSЯUS 62]

Ok, ini saya try HTML + PHP code (sbb saya xtahu ASP.. )
Dan saya tak ambil kesemua 15 kod, saya cuma ambil 2 daripadanya (WBC dan RBC).

[code]<html>
<head><style type="text/css">
label {
display: block;
width: 150px;
float: left;
margin: 4px 4px 6px 4px;
text-align: right;
}
br { clear: left; }
</style></head>
<body>


<?php

//Connect to MySQL
if(!($db = mysql_connect("localhost","root","")))
die("could not connect database");

//Open database
if(!mysql_select_db("disease",$db))
die("could not open database");


if (isset($_POST['submit']) && $_POST['submit'] == 'SUBMIT')
{
$WBC = $_POST['wbc'];
$RBC = $_POST['rbc'];

//GET ALL RANGES FOR WBC FROM DB
$query = mysql_query("SELECT * FROM disease WHERE kod = 'wbc'");
while($get = mysql_fetch_array($query, MYSQL_ASSOC))
{
$wbc_low_sr = $get['low_sr'];
$wbc_low_er = $get['low_er'];
$wbc_mid_sr = $get['mid_sr'];
$wbc_mid_er = $get['mid_er'];
$wbc_high_sr = $get['high_sr'];
$wbc_high_er = $get['high_er'];
}

//GET ALL RANGES FOR RBC FROM DB
$query = mysql_query("SELECT * FROM disease WHERE kod = 'rbc'");
while($get = mysql_fetch_array($query, MYSQL_ASSOC))
{
$rbc_low_sr = $get['low_sr'];
$rbc_low_er = $get['low_er'];
$rbc_mid_sr = $get['mid_sr'];
$rbc_mid_er = $get['mid_er'];
$rbc_high_sr = $get['high_sr'];
$rbc_high_er = $get['high_er'];
}

//DEFINE WBC LEVEL BY COMPARING USER INPUT AND RANGE IN DB
if($WBC >= $wbc_low_sr && $WBC <= $wbc_low_er) { $wbc_lv = 'low'; }
elseif($WBC >= $wbc_mid_sr && $WBC <= $wbc_mid_er) { $wbc_lv = 'mid'; }
elseif($WBC >= $wbc_high_sr && $WBC <= $wbc_high_er) { $wbc_lv = 'high'; }
else { $wbc_err = 'true'; }

//DEFINE RBC LEVEL BY COMPARING USER INPUT AND RANGE IN DB
if($RBC >= $rbc_low_sr && $RBC <= $rbc_low_er) { $rbc_lv = 'low'; }
elseif($RBC >= $rbc_mid_sr && $RBC <= $rbc_mid_er) { $rbc_lv = 'mid'; }
elseif($RBC >= $rbc_high_sr && $RBC <= $rbc_high_er) { $rbc_lv = 'high'; }
else { $rbc_err = 'true'; }

//IF USER INPUT IS OUT OF RANGE (<0 or >25)
if(isset($wbc_err) || isset($rbc_err)) { echo "ERROR"; }

//DETERMINE DISEASE (COMPARE WBC LEVEL vs RBC LEVEL)
elseif(($wbc_lv == 'low') && ($rbc_lv == 'low')) { echo "PENYAKIT A"; }
elseif($wbc_lv == 'low' && $rbc_lv == 'mid') { echo "PENYAKIT B"; }
elseif($wbc_lv == 'low' && $rbc_lv == 'high') { echo "PENYAKIT C"; }

elseif($wbc_lv == 'mid' && $rbc_lv == 'low') { echo "PENYAKIT D"; }
elseif($wbc_lv == 'mid' && $rbc_lv == 'mid') { echo "PENYAKIT E"; }
elseif($wbc_lv == 'mid' && $rbc_lv == 'high') { echo "PENYAKIT F"; }

elseif($wbc_lv == 'high' && $rbc_lv == 'low') { echo "PENYAKIT G"; }
elseif($wbc_lv == 'high' && $rbc_lv == 'mid') { echo "PENYAKIT H"; }
elseif($wbc_lv == 'high' && $rbc_lv == 'high') { echo "PENYAKIT I"; }


echo "<input type='button' onClick='history.go(-1)' value='BACK'>";

}
ELSE
{
echo"
<form method='post'>
<br><label>WBC</label><input type='text' name='wbc'>
<br><label>RBC</label> <input type='text' name='rbc'>
<br><label>&nbsp;</label><input type='submit' name='submit' value='SUBMIT'>
</form>";


}
?>

</body>
</html>[/code]

manakala ini database yg saya buat:
[img]http://images.devs-on.net/Image/URH5WcEG9VYESx5-Region.png[/img]
_sr = start range
_er = end range

BTW, coding ni mungkin boleh di simplifykan lagi (guna array kot).
Cuma saya nak cpt jadi saya buat apa yg sy terfikir skrg.. huhu.

[i]p/s: kalau silap minta dibetulkan, saya budak baru belajar. hehehe[/i]

[DevGuy 0]

ada option sebenarnya buat ni. kalau guna coding pun leh kalau nak thru database pun leh. cuba kalau guna database slow sikit. sebab everytime kena query databse so slow kan. tapi ada kelebihan kalau range tu berubah22 so kena la database tapi kalau tak berubah kita leh buat hardcode jer.

teringat lak masa buat projeect clinical trial utk cancer macam ni aaa kena ada range. heheh