private bool Signup(string id, string pw) { DataSet ds = DBFactory.ExcuteQuery( @"SELECT * " + @" FROM TB_CURER " + @" WHERE 1=1 " + @" AND CURER_ID = '" + id + "'" ); if (ds != null && ds.Tables[0].Rows.Count > 0) { Console.WriteLine(" id : " + ds.Tables[0].Rows[0][0]); return(false); } else { DBFactory.ExcuteNonQuery( @"INSERT INTO " + @" TB_CURER (CURER_ID, CURER_PW) " + @"VALUES " + @" ('" + id + "', '" + pw + "')" ); return(true); } }
// /*register Error*/ // private int Add_FigureToDb() { FileStream fs = new FileStream(pictureBox_fig_img.Tag.ToString(), FileMode.Open, FileAccess.Read); byte[] bImage = new byte[fs.Length]; fs.Read(bImage, 0, (int)fs.Length); int fNum = int.Parse(DBFactory.ExcuteQuery(@"SELECT count(*) FROM TB_FIGURE").Tables[0].Rows[0][0].ToString()); fNum++; DBFactory.ExcuteNonQuery( @"INSERT INTO " + @" TB_FIGURE (FIG_NUM,IMAGE,CATEGORY,DIVISION,SECTION,SYMBOL)" + @"VALUES" + @"('" + fNum + "','" + utfEncoding.ToUtf8(tb_img_path.Text) + "','" + utfEncoding.ToUtf8(comboBox_add_cate.Text) + "','" + utfEncoding.ToUtf8(comboBox_add_div.Text) + "','" + utfEncoding.ToUtf8(comboBox_add_sel.Text) + "','" + utfEncoding.ToUtf8(textBox_add_sym.Text) + "')" ); fs.Close(); return(fNum); }
private void insertForDB() { int pNum = int.Parse(DBFactory.ExcuteQuery(String.Format(Query.countFig)).Tables[0].Rows[0][0].ToString()); // 선택된 모래상자 이미지들을 DB에 저장 // TODO 쿼리를 전역변수로 바꾸기 for (int i = 0; i < 8; i++) { DBFactory.ExcuteNonQuery(@"INSERT INTO TB_PHOTO (PO_NUM, PHOTO_DATA) VALUES( (SELECT COUNT(*) FROM TB_PHOTO), '" + utfEncoding.ToUtf8(picBoxArr[i]) + "')"); } }
private bool Add_patient() { // throw new System.NotImplementedException(); if (textBox_name.ToString() == null) { Console.WriteLine("No name"); return(false); } else { DBFactory.ExcuteNonQuery( @"INSERT INTO " + @" TB_PATIENT (IDX,PAT_NUM,PAT_NAME,PAT_AGE,PAT_SEX,PAT_FEATURE)" + @"VALUES" + @"('" + Session.curSession.id + "','" + (new Random()).Next(1000000000) + "','" + utfEncoding.ToUtf8(textBox_name.Text) + "','" + int.Parse(textBox_age.Text) + "','" + utfEncoding.ToUtf8(this.selectedSex) + "','" + utfEncoding.ToUtf8(textbox_feat.Text) + "')" ); return(true); } }
private void button2_Click(object sender, EventArgs e) { DBFactory.ExcuteNonQuery("INSERT INTO TB_CURER VALUES (1, 'test', 'test')"); }