private void checklogin() //update_data_to_db();
{
qrcode = user.Text;
//password_s = pass.Text;
WebReference.WebService_kanban mytagdata = new WebReference.WebService_kanban();
DataTable dt = mytagdata.login(this.qrcode);
string qr_db = (string)dt.Rows[0]["QRCode"];
string name = (string)dt.Rows[0]["Username"];
Form1 f1 = new Form1(qrcode); //ตั้งชื่อเพื่อเรียกใช้ฟอร์ม1 พร้อมส่งข้อความ (data)
MessageBox.Show(qrcode);
if (dt.Rows.Count > 0)
{
if (qrcode == qr_db)
{
MessageBox.Show("เข้าสู่ระบบสำเร็จ ยินดีต้อนรับ : '" + name + "' ");
user.Text = name;
this.Hide();
f1.ShowDialog();
this.Show();
}
else
{
MessageBox.Show("ไม่สามรถเข้าระบบได้");
}
//MessageBox.Show(get_username);
}
}
// ============= KANBAN ==================//
private void get_db_insert_kanban_local()
{
WebReference.WebService_kanban mytagdata = new WebReference.WebService_kanban();
DataTable dt = mytagdata.get_m_kanban();
rows_db = dt.Rows.Count;
// MessageBox.Show(rows_db.ToString());
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
srct_code_kanban = (string)dt.Rows[i]["SRCT_Code"];
customer_Code_kanban = (string)dt.Rows[i]["Customer_Code"];
attension_point_kanban = (string)dt.Rows[i]["Attension_point"];
part_Number_kanban = (string)dt.Rows[i]["Part_Number"];
part_Name_kanban = (string)dt.Rows[i]["Part_Name"];
model_kanban = (string)dt.Rows[i]["Model"];
package_kanban = (int)dt.Rows[i]["Package"];
customer_kanban = (string)dt.Rows[i]["Customer"];
line_kanban = (string)dt.Rows[i]["Line"];
store_Address_kanban = (string)dt.Rows[i]["Store_Address"];
part_Ilustration_kanban = (string)dt.Rows[i]["Part_Ilustration"];
part_Ilustration_Path_kanban = (string)dt.Rows[i]["Part_Ilustration_Path"];
dock_Code_kanban = (string)dt.Rows[i]["Dock_Code"];
location_kanban = (string)dt.Rows[i]["Location"];
kb_running_kanban = (int)dt.Rows[i]["KB_running"];
insert_data_kanban_to_local();
}
}
}
private void update_db_from_local()//update_data_to_db();
{
try
{
WebReference.WebService_kanban mytagdata = new WebReference.WebService_kanban();
DataTable dt = mytagdata.insert_data_to_db_from_local(this.part_local, this.srct_local, this.dock_local, this.pack_local, this.error_local, this.chk_local, this.user_local, this.date_local, this.ekb_local, this.kanban_local);
//DataTable dt = mytagdata.insert_data_to_db_from_local(this.part_local, this.srct_local, this.dock_local, this.pack_local);
rows_db = dt.Rows.Count;
//MessageBox.Show("rows DB :" + rows_db.ToString());
}catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
// ============ END ===========//
/*
* private void get_db_insert_local()
* {
* WebReference.WebService_kanban mytagdata = new WebReference.WebService_kanban();
* DataTable dt = mytagdata.count_rows_db();
* rows_db = dt.Rows.Count;
* // MessageBox.Show(rows_db.ToString());
* if (dt.Rows.Count > 0)
* {
* for (int i = 0; i < dt.Rows.Count; i++)
* {
* part_db = (string)dt.Rows[i]["Part_Number"];
* srct_db = (string)dt.Rows[i]["SRCT_Code"];
* dock_db = (string)dt.Rows[i]["Dock_Code"];
* pack_db = (int)dt.Rows[i]["Package"];
* error_db = (string)dt.Rows[i]["Error_Code"];
* chk_db = (string)dt.Rows[i]["Chk_Type"];
* match_db = (Boolean)dt.Rows[i]["IsMatch"];
* user_db = (string)dt.Rows[i]["LogUser"];
* date_db = (DateTime)dt.Rows[i]["LogDate"];
* pds_db = (string)dt.Rows[i]["PDS_number"];
* ekb_db = (string)dt.Rows[i]["ekb_order_no"];
* kanban_db = (string)dt.Rows[i]["Kanban_ID"];
* insert_data_to_local();
* }
* }
*
* }
*
*
* private void insert_data_to_local()//include get_db_insert_local();
* {
* try
* {
* SqlCeConnection connection = new SqlCeConnection("Data Source=C:\\Users\\SRCT\\Desktop\\job\\smartdevice\\smart_device_winform\\smart_device_winform\\localdata.sdf;Persist Security Info=False;");
* connection.Open(); //Error_Code LogDate
* SqlCeCommand sCommand = new SqlCeCommand(@"INSERT INTO LogHendheld (Part_Number,SRCT_Code,Dock_Code,Package,Error_Code,Chk_Type,IsMatch,LogUser,LogDate,PDS_number,ekb_order_no,Kanban_ID) VALUES ('" + part_db + "','" + srct_db + "','" + dock_db + "','" + pack_db + "','" + error_db + "','" + chk_db + "','" + match_db + "','" + user_db + "','" + date_db + "','" + pds_db + "','" + ekb_db + "','" + kanban_db + "')", connection);
* sCommand.ExecuteNonQuery();
* //MessageBox.Show("Row from db !! ");
* connection.Close();
* }
* catch (Exception ex)
* {
* MessageBox.Show(ex.Message);
* }
* }
*/
// ============ Service t_part_tag =============//
private void get_t_part_tag_db()
{
try
{
WebReference.WebService_kanban mytagdata = new WebReference.WebService_kanban();
DataTable dt = mytagdata.get_part_tag(this.partnumber_kanban);
if (dt.Rows.Count > 0)
{
part_number_t_tag = (string)dt.Rows[0]["PartNumber"];
MessageBox.Show(part_number_t_tag);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}// end method check_dupicate(Parameter)
// ========== Count Rows From DB ==========//
private void count_rows_db_m_kanban()
{
try
{
WebReference.WebService_kanban mytagdata = new WebReference.WebService_kanban();
DataTable dt = mytagdata.get_m_kanban();
rows_db = dt.Rows.Count;
MessageBox.Show("rows DB :" + rows_db.ToString());
/*
* if (dt.Rows.Count > 0)
* {
*
* }
* */
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
