public static List <Serice> select(string name, string type)
{
string sql = string.Format(" select Shebei.Name,SheBeiType.TypeName,Area,Weixiuer,WeixiuData,Guzhang from Shebei,SheBeiType,Serice where Shebei.Typeid=SheBeiType.TypeId and Serice.shibeiID=Shebei.ID ");
if (name != "")
{
sql += string.Format("and Shebei.Name='{0}'", name);
}
if (type == "----请选择类型----")
{
}
else
{
sql += string.Format("and SheBeiType.TypeName='{0}'", type);
}
DataTable dt = DBHelper.ExecutReader(sql);
List <Serice> list = new List <Serice>();
foreach (DataRow dr in dt.Rows)
{
Serice sc = new Serice();
sc.Name = dr["Name"].ToString();
sc.TypeName = dr["TypeName"].ToString();
sc.Area = dr["Area"].ToString();
sc.Weixiuer = dr["Weixiuer"].ToString();
sc.WeixiuData = dr["WeixiuData"].ToString();
sc.Guzhang = dr["Guzhang"].ToString();
list.Add(sc);
}
return(list);
}
protected void Button1_Click(object sender, EventArgs e)
{
Serice sc = new Serice();
sc.shebeiID = 1;
sc.DeviceType = 0;
int id = 0;
if (this.DropDownList1.SelectedItem.Text == "电脑")
{
sc.shebeiID = 1;
}
if (this.DropDownList1.SelectedItem.Text == "手机")
{
sc.shebeiID = 2;
}
if (this.DropDownList1.SelectedItem.Text == "自行车")
{
sc.shebeiID = 3;
}
if (this.DropDownList1.SelectedItem.Text == "小汽车")
{
sc.shebeiID = 1;
}
if (this.DropDownList2.SelectedItem.Text == "常用类")
{
sc.DeviceType = 1;
}
if (this.DropDownList2.SelectedItem.Text == "空闲类")
{
sc.DeviceType = 2;
}
if (this.DropDownList2.SelectedItem.Text == "其他类")
{
sc.DeviceType = 3;
}
sc.Weixiuer = this.TextBox1.Text;
sc.Area = this.TextBox2.Text;
sc.Guzhang = this.TextBox3.Text;
sc.WeixiuData = this.TextBox4.Text;
sc.Beizu = this.TextBox5.Text;
//string url = null;
//string usertime=null;
//string money = null;
if (SericeManger.add(sc))
{
ClientScript.RegisterStartupScript(this.GetType(), "loginSucess", "<script>alert('提交成功！ ')</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Serice sc = new Serice();
sc.Name = Request["name"].ToString();
List <shebei> list = ShebeiManger.select(sc.Name);
foreach (shebei item in list)
{
sc.shebeiID = item.ID;
}
if (Request["type"].ToString() == "常用类")
{
sc.DeviceType = 1;
}
if (Request["type"].ToString() == "普通类")
{
sc.DeviceType = 2;
}
if (Request["type"].ToString() == "其他类")
{
sc.DeviceType = 3;
}
sc.Area = Request["area"].ToString();
sc.Weixiuer = this.TextBox1.Text;
sc.Guzhang = this.TextBox2.Text;
sc.WeixiuData = this.TextBox3.Text;
sc.Money = this.TextBox4.Text;
sc.UseTime = this.TextBox5.Text;
sc.Beizu = this.TextBox6.Text;
sc.Url = "Images/";
if (SericeManger.add(sc))
{
ClientScript.RegisterStartupScript(this.GetType(), "loginSucess", "<script>alert('提交成功！ ')</script>");
}
}
public static bool insert(Serice sc)
{
string sql = string.Format("insert into Serice values({0},'{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')", sc.DeviceType, sc.Weixiuer, sc.Area, sc.Guzhang, sc.WeixiuData, sc.Beizu, sc.Url, sc.UseTime, sc.Money);
return(DBHelper.ExecutNonQuery(sql));
}
public static bool add(Serice sc)
{
string sql = string.Format("insert into Serice values({0},{1},'{2}','{3}','{4}','{5}','{6}','null','null','null')", sc.shebeiID, sc.DeviceType, sc.Weixiuer, sc.Area, sc.Guzhang, sc.WeixiuData, sc.Beizu);
return(DBHelper.ExecutNonQuery(sql));
}
