private void cmdOK_Click(object sender, EventArgs e) { if (this.textName.Text == "") { MainModule.set_MessageBox(alu_tp.main_1.msg_txt.GetString("NotID"), 3000); return; } if (this.textCheck.Text == "") { MainModule.set_MessageBox(alu_tp.main_1.msg_txt.GetString("NotCheckingPassword"), 3000); return; } if (this.textCheck.Text != this.textPassword.Text) { MainModule.set_MessageBox(alu_tp.main_1.msg_txt.GetString("CheckingPassworderror"), 3000); return; } // con3 = new AccessDataSource(alu_tp.main_1.accdb_PATH, ""); MainModule.insertDatabasesel(" INSERT INTO [ho_user] (UserNo,UserName) VALUES ( '" + this.textName.Text + "','" + this.textName.Text + "')"); MainModule.insertDatabasesel(" INSERT INTO [HmdRegister] (id,Passwd,RS_232,Unit1,Time1,Max1,Min1,Maxp,Minp) VALUES ( '" + this.textName.Text + "','" + this.textPassword.Text + "','COM1','1','1','180','50','300','30')"); //con3.InsertParameters.Clear(); //con3.InsertCommand = "INSERT INTO [sta_data] (starNo,staemail,staName,sta_phone,user_address,CreateDate,IsExport) VALUES ( @starNo,@staemail,@staName,@sta_phone,@user_address,@CreateDate,@IsExport)"; //con3.InsertParameters.Add(new Parameter("starNo", TypeCode.String, id.Text)); //con3.InsertParameters.Add(new Parameter("staemail", TypeCode.String, Convert.ToString(textBox5.Text))); //con3.InsertParameters.Add(new Parameter("staName", TypeCode.String, textBox1.Text)); //con3.InsertParameters.Add(new Parameter("sta_phone", TypeCode.String, textBox4.Text)); //con3.InsertParameters.Add(new Parameter("user_address", TypeCode.String, textBox6.Text)); //con3.InsertParameters.Add(new Parameter("CreateDate", TypeCode.DateTime, DateTime.Now.ToString())); //con3.InsertParameters.Add(new Parameter("IsExport", TypeCode.Boolean, Convert.ToString(false))); //con3.Insert(); //con3.UpdateParameters.Clear(); //con3.UpdateCommand = "UPDATE [HmdRegister] SET id=@id,Passwd=@Passwd"; //con3.UpdateParameters.Add(new Parameter("id", TypeCode.String, Convert.ToString(id.Text))); //con3.UpdateParameters.Add(new Parameter("Passwd", TypeCode.String, textBox2.Text)); //con3.Update(); //} MessageBox.Show("NEW paciente [" + textName.Text + "] Registration OK !!", "Glucose Management Software", MessageBoxButtons.OK); this.Close(); loginForm f = new loginForm(); f.addCountButton3.Enabled = false; f.ShowDialog(); aendsub :; }
private void loadData() { lblMeterid2.Text = alu_tp.main_1.MeterIDNo.ToString(); MainModule.insertDatabasesel(" INSERT INTO [ho_user] (UserNo,UserName) VALUES ( '" + lblUserID.Text + "','" + lblName.Text + "')"); /* * DataView dv1 = new DataView(); * dv1 = MainModule.AccessDatabasesel("SELECT * FROM HmdRegister where mid='" + lblMeterid2.Text + "'"); * //127.053.618-47 * if (dv1 != null) * { * if (dv1.Count > 0) * { * txtUserID.Text = dv1[0]["id"].ToString(); * oldtxtUserID = dv1[0]["id"].ToString(); * } * } */ }