private void button1_Click(object sender, EventArgs e) { if (textBox1.Text != "" && textBox2.Text != "" && textBox3.Text != "" && pictureBox1.ImageLocation != null) { int sname = Convert.ToInt16(textBox3.Text); int row = Convert.ToInt16(textBox1.Text); int col = Convert.ToInt16(textBox2.Text); string simage = pictureBox1.ImageLocation; string image_Path = @"resource\cinema\S" + textBox3.Text.Trim() + ".PNG"; if (File.Exists(image_Path)) { File.Delete(image_Path); File.Copy(simage, image_Path); } else { File.Copy(simage, image_Path); } Screens screen = new Screens(sname, row, col, image_Path); SqlScreens.scressAdd(screen); cinema.Combox_Load(); cinema.button4_Click(null, null); MessageBox.Show("添加成功"); this.Dispose(); } else { MessageBox.Show("请输入完整信息!"); } }
public static Screens getScreenBySName(String sName) { Screens screen = new Screens(); screen.setName(Convert.ToInt16(sName)); screen.setRow((int)DbHelperSQL.GetSingle("select Row from Screens where SName='" + sName + "'")); screen.setCol((int)DbHelperSQL.GetSingle("select col from Screens where SName='" + sName + "'")); screen.setImage((string)DbHelperSQL.GetSingle("select SImage from Screens where SName='" + sName + "'")); return screen; }
public static void scressAdd(Screens screen) { string insert = "insert into Screens(SName,Row,col,SImage) values(" + screen.getName() + "," + screen.getRow() + "," + screen.getCol() + ",'" + screen.getImage() + "')"; DbHelperSQL.ExecuteSql(insert); }