public static List <shebei> select(string name) { string sql = string.Format("select ID from Shebei where name='{0}'", name); DataTable dt = DBHelper.ExecutReader(sql); List <shebei> list = new List <shebei>(); foreach (DataRow dr in dt.Rows) { shebei sb = new shebei(); sb.ID = (int)dr["ID"]; //sb.Name = dr["Name"].ToString(); //sb.TypeName = dr["TypeName"].ToString(); //sb.State = dr["State"].ToString(); //sb.XulieNumber = dr["XulieNumber"].ToString(); //sb.Xinghao = dr["Xinghao"].ToString(); //sb.Pinpai = dr["Pinpai"].ToString(); //sb.Shopdata = dr["Shopdata"].ToString(); //sb.Factory = dr["Factory"].ToString(); //sb.Outdata = dr["Outdata"].ToString(); //sb.Url = dr["Url"].ToString(); //sb.Beizu = dr["Beizu"].ToString(); list.Add(sb); } return(list); }
public static bool update(shebei sb) { string sql = string.Format("update Shebei set Name='{0}',Typeid={1},State='{2}',XulieNumber='{3}',Xinghao='{4}',Pinpai='{5}',Shopdata='{6}',Factory='{7}',Outdata='{8}',Url='{9}',Beizu='{10}' where Name='{11}'" , sb.Name, sb.Typeid, sb.State, sb.XulieNumber, sb.Xinghao, sb.Pinpai, sb.Shopdata, sb.Factory, sb.Outdata, sb.Url, sb.Beizu, sb.Name); return(DBHelper.ExecutNonQuery(sql)); }
protected void Button1_Click(object sender, EventArgs e) { shebei sb = new shebei(); sb.Name = this.TextBox1.Text; if (this.DropDownList1.SelectedItem.Text == "常用类") { sb.Typeid = 1; } if (this.DropDownList1.SelectedItem.Text == "普通类") { sb.Typeid = 2; } if (this.DropDownList1.SelectedItem.Text == "其他类") { sb.Typeid = 3; } sb.Xinghao = this.TextBox3.Text; sb.Pinpai = this.TextBox4.Text; sb.XulieNumber = this.TextBox5.Text; sb.Shopdata = this.TextBox7.Text; sb.Outdata = this.TextBox8.Text; sb.Factory = this.TextBox6.Text; if (FileUpload2.HasFile) { string filename = FileUpload2.FileName; string ex = filename.Substring(filename.LastIndexOf(".")); string newfilename = DateTime.Now.Ticks.ToString() + new Random().Next(100000, 1000000) + ex; string path = Server.MapPath("/") + "Images/"; FileUpload2.SaveAs(path + newfilename); this.TextBox2.Text = "Images/" + newfilename; sb.Url = "Images/" + newfilename; sb.Beizu = this.TextBox11.Text; this.Image1.ImageUrl = sb.Url; } this.TextBox2.Text = sb.Url; if (ShebeiManger.update(sb)) { Response.Write("<script>alert('更新成功!')</script>"); } }
protected void Button1_Click(object sender, EventArgs e) { shebei sb = new shebei(); sb.Name = this.TextBox1.Text; if (this.DropDownList1.Text == "常用类") { sb.Typeid = 1; } if (this.DropDownList1.Text == "普通类") { sb.Typeid = 1; } if (this.DropDownList1.Text == "其他类") { sb.Typeid = 1; } sb.Xinghao = this.TextBox3.Text; sb.Pinpai = this.TextBox4.Text; sb.XulieNumber = this.TextBox5.Text; sb.Shopdata = this.TextBox7.Text; sb.Outdata = this.TextBox8.Text; sb.Factory = this.TextBox6.Text; if (FileUpload2.HasFile) { string filename = FileUpload2.FileName; string ex = filename.Substring(filename.LastIndexOf(".")); string newfilename = DateTime.Now.Ticks.ToString() + new Random().Next(100000, 1000000) + ex; string path = Server.MapPath("/") + "Images/"; FileUpload2.SaveAs(path + newfilename); this.TextBox2.Text = "Images/" + newfilename; sb.Url = "Images/" + newfilename; sb.Beizu = this.TextBox11.Text; if (ShebeiManger.insert(sb)) { ClientScript.RegisterStartupScript(this.GetType(), "loginSucess", "<script>alert('添加成功! ')</script>"); } } }
public static List <shebei> selectlist(string name, string typename, string datatime) { string sql = string.Format("select * from Shebei,SheBeiType where Shebei.typeid=SheBeiType.TypeId "); if (name != "") { sql += string.Format("and Name='{0}'", name); } if (typename != "----请选择类型----") { sql += string.Format("and TypeName='{0}'", typename); } if (datatime != "") { sql += string.Format("and Shopdata>='{0}'", datatime); } DataTable dt = DBHelper.ExecutReader(sql); List <shebei> list = new List <shebei>(); foreach (DataRow dr in dt.Rows) { shebei sb = new shebei(); sb.ID = (int)dr["ID"]; sb.Name = dr["Name"].ToString(); sb.TypeName = dr["TypeName"].ToString(); sb.State = dr["State"].ToString(); sb.XulieNumber = dr["XulieNumber"].ToString(); sb.Xinghao = dr["Xinghao"].ToString(); sb.Pinpai = dr["Pinpai"].ToString(); sb.Shopdata = dr["Shopdata"].ToString(); sb.Factory = dr["Factory"].ToString(); sb.Outdata = dr["Outdata"].ToString(); sb.Url = dr["Url"].ToString(); sb.Beizu = dr["Beizu"].ToString(); list.Add(sb); } return(list); }
public static bool insert(shebei sb) { string sql = string.Format("insert into Shebei values('{0}',{1},'空闲','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')", sb.Name, sb.Typeid, sb.XulieNumber, sb.Xinghao, sb.Pinpai, sb.Shopdata, sb.Factory, sb.Outdata, sb.Url, sb.Beizu); return(DBHelper.ExecutNonQuery(sql)); }