/// <summary> /// 获取出库列表 /// </summary> public void GetOutDeviceList() { DataSet ds = OperaterBase.GetData("select * from V_Out_Stock"); Repeater1.DataSource = ds; Repeater1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { string username = TextBox1.Text; string password = TextBox2.Text; string adminLoginSql = "select * from Staff_Table where worker_mobile='" + username + "' and worker_password='******'"; DataSet ds = OperaterBase.GetData(adminLoginSql); if (ds.Tables[0].Rows.Count == 0) { Label1.Text = "信息有误,请检查"; return; } // 存入session,判断session是否为空 Session["login_user"] = ds.Tables[0].Rows[0]["worker_mobile"]; if (string.IsNullOrEmpty(Session["login_user"].ToString())) { Label1.Text = "服务器错误,请联系管理员"; return; } // 必须是管理员 if (ds.Tables[0].Rows[0]["worker_num"].ToString() == "admin") { Response.Redirect("manage_staff.aspx?staffId=1"); } else { Response.Redirect("order_list.aspx?staffId=" + ds.Tables[0].Rows[0]["Id"]); } }
/// <summary> /// 获取学生列表 /// </summary> private void getStudentList(string sql) { DataSet ds = OperaterBase.GetData(sql); Repeater1.DataSource = ds; Repeater1.DataBind(); }
/// <summary> /// 库存数量比对,重新设置库存数量 /// </summary> /// <param name="device_number">设备型号</param> /// <param name="device_count">下单数量</param> /// <returns></returns> public int GetIinventoryCount(string device_number, string device_count) { // 应该重新设置的库存数量 int count = -1; DataSet ds = OperaterBase.GetData("select * from Device_List where device_number = '" + device_number + "'"); // 说明查出来数据了 if (ds.Tables[0].Rows.Count > 0) { if (Convert.ToInt32(device_count) > Convert.ToInt32(ds.Tables[0].Rows[0]["device_count"])) { Label1.Text = "下单数量大于库存数量,库存数量为" + Convert.ToInt32(ds.Tables[0].Rows[0]["device_count"]); } else { // 数量正常,可以正常减去 count = Convert.ToInt32(ds.Tables[0].Rows[0]["device_count"]) - Convert.ToInt32(device_count); OperaterBase.CommandBySql("update Device_List set device_count=" + count + " where device_number='" + device_number + "'"); } } else { Label1.Text = "设备号有异常,请检查"; } return(count); }
/// <summary> /// 根据指定条件获取员工数据 /// </summary> private void GetStaffData(string sql) { DataSet ds = OperaterBase.GetData(sql); Repeater1.DataSource = ds; Repeater1.DataBind(); }
/// <summary> /// 更新用户 /// 给文本框获取数据库原值 /// </summary> private void UpdateUser() { int deviceId = Convert.ToInt32(Request["deviceId"]); string sql = "select * from Device_List where id=" + deviceId; DataSet ds = OperaterBase.GetData(sql); TextBox1.Text = ds.Tables[0].Rows[0]["device_number"].ToString(); TextBox2.Text = ds.Tables[0].Rows[0]["device_count"].ToString(); }
private void DropList1() { string sql = "select sp.ProvinceName,sp.ProvinceID from S_Province sp"; DataSet ds = OperaterBase.GetData(sql); DropDownList1.DataSource = ds; DropDownList1.DataTextField = "ProvinceName"; DropDownList1.DataValueField = "ProvinceID"; DropDownList1.DataBind(); }
private void GetClassList() { string sql = "select * from ClassInfo"; DataSet ds = OperaterBase.GetData(sql); DropDownList1.DataSource = ds; DropDownList1.DataValueField = "ID"; DropDownList1.DataTextField = "className"; DropDownList1.DataBind(); }
private void DropList2() { int value = Convert.ToInt32(DropDownList1.SelectedValue); string sql = "SELECT * FROM S_City WHERE ProvinceID = " + value; DataSet ds = OperaterBase.GetData(sql); DropDownList2.DataSource = ds; DropDownList2.DataTextField = "CityName"; DropDownList2.DataValueField = "CityID"; DropDownList2.DataBind(); }
/// <summary> /// 判断手机号是否唯一 /// </summary> /// <param name="mobile"></param> /// <returns>true or false</returns> private Boolean IsMobile(string studentNum, string mobile) { string sql = "select mobile , studentNum from studentInfo where studentNum = '" + studentNum + "' or mobile = '" + mobile + "'"; DataSet ds = OperaterBase.GetData(sql); if (ds.Tables[0].Rows.Count <= 0) { return(true); } return(false); }
/// <summary> /// 获取设备型号 /// </summary> private void GetDeviceList() { DataSet ds = OperaterBase.GetData("select * from Device_List where is_delete=0 order by device_number"); DropDownList1.DataSource = ds; DropDownList1.DataTextField = "device_number"; DropDownList1.DataValueField = "id"; DropDownList1.DataBind(); // 插入到第一个位置,内容和value值 DropDownList1.Items.Insert(0, new ListItem("请选择设备编号", "0")); }
private void DropList3() { int value = Convert.ToInt32(DropDownList2.SelectedValue); string sql = "SELECT * FROM S_District WHERE CityID = " + value; DataSet ds = OperaterBase.GetData(sql); DropDownList3.DataSource = ds; DropDownList3.DataTextField = "DistrictName"; DropDownList3.DataValueField = "DistrictID"; DropDownList3.DataBind(); }
/// <summary> /// 获取订单列表 /// </summary> public void GetOrderList() { string staffId = Request["staffId"]; // 判断是否为空 if (!string.IsNullOrEmpty(staffId)) { DataSet ds = OperaterBase.GetData("select * from V_Order_Sta_Dev where order_staff= " + staffId); Repeater1.DataSource = ds; Repeater1.DataBind(); } }
/// <summary> /// 获取所有省份 /// </summary> private void GetAllProvince() { string sql = "select * from S_Province"; DataSet ds = OperaterBase.GetData(sql); // 给下拉框绑定 DropDownList1.DataSource = ds; // 绑定下拉框文字 DropDownList1.DataTextField = "ProvinceName"; //绑定下拉框value值 DropDownList1.DataValueField = "ProvinceID"; DropDownList1.DataBind(); DropDownList1.Items.Insert(0, new ListItem("请选择省份", "0")); }
private Boolean isMobile(string mobile, string password) { if (mobile != "") { string sql = "select mobile from studentInfo where mobile = '" + mobile + "'"; if (OperaterBase.GetData(sql) != null) { ResetPassword(mobile, password); return(true); } } return(false); }
/// <summary> /// 获取选定城市的区县 /// </summary> private void GetSelectedDistrict() { string CityID = DropDownList2.SelectedValue; string sql = "select * from S_District where CityID=" + CityID + ""; DataSet ds = OperaterBase.GetData(sql); // 给下拉框绑定 DropDownList3.DataSource = ds; // 绑定下拉框文字 DropDownList3.DataTextField = "DistrictName"; //绑定下拉框value值 DropDownList3.DataValueField = "DistrictID"; DropDownList3.DataBind(); DropDownList3.Items.Insert(0, new ListItem("请选择地区", "0")); }
/// <summary> /// 把数据 填入框里面 /// </summary> /// <param name="StudentID"></param> private void FillData(int StudentID) { string Bysql = "select * from studentInfo where ID = " + StudentID; DataSet ds = OperaterBase.GetData(Bysql); TextBox1.Text = ds.Tables[0].Rows[0]["studentNum"].ToString(); TextBox2.Text = ds.Tables[0].Rows[0]["studentSex"].ToString(); TextBox3.Text = ds.Tables[0].Rows[0]["mobile"].ToString(); TextBox4.Text = ds.Tables[0].Rows[0]["password"].ToString(); TextBox5.Text = ds.Tables[0].Rows[0]["birthday"].ToString(); TextBox6.Text = ds.Tables[0].Rows[0]["province"].ToString(); TextBox7.Text = ds.Tables[0].Rows[0]["city"].ToString(); TextBox8.Text = ds.Tables[0].Rows[0]["district"].ToString(); TextBox10.Text = ds.Tables[0].Rows[0]["classId"].ToString(); TextBox9.Text = ds.Tables[0].Rows[0]["studentName"].ToString(); }
protected void Button1_Click(object sender, EventArgs e) { string user = TextBox1.Text.Trim(); string pwd = TextBox2.Text.Trim(); string sql = "SELECT studentNum,password FROM studentInfo WHERE studentNum = " + user + " AND password = "******"登录成功"; } else { Button1.Text = "登录失败"; } Response.Redirect("studentInfo.aspx"); }
/// <summary> /// 修改员工信息 /// </summary> private void UpdateStaff() { var ID = Convert.ToInt32(Request["staffID"]); string sql = "select * from Staff_Table where Id=" + ID + ""; DataSet ds = OperaterBase.GetData(sql); TextBox1.Text = ds.Tables[0].Rows[0]["worker_num"].ToString(); TextBox2.Text = ds.Tables[0].Rows[0]["worker_name"].ToString(); Image1.ImageUrl = ds.Tables[0].Rows[0]["worker_avatar"].ToString(); Sex_Tb.SelectedValue = ds.Tables[0].Rows[0]["worker_sex"].ToString(); TextBox4.Text = ds.Tables[0].Rows[0]["worker_age"].ToString(); TextBox5.Text = ds.Tables[0].Rows[0]["worker_mobile"].ToString(); TextBox6.Text = ds.Tables[0].Rows[0]["worker_password"].ToString(); DropDownList1.SelectedValue = ds.Tables[0].Rows[0]["s_province"].ToString(); DropDownList2.SelectedValue = ds.Tables[0].Rows[0]["s_city"].ToString(); DropDownList3.SelectedValue = ds.Tables[0].Rows[0]["s_district"].ToString(); }
/// <summary> /// 获取选定省份的城市 /// </summary> private void GetSelectedCity() { string ProvinceID = DropDownList1.SelectedValue; string sql = "select * from S_City where ProvinceID=" + ProvinceID + ""; DataSet ds = OperaterBase.GetData(sql); // 给下拉框绑定 DropDownList2.DataSource = ds; // 绑定下拉框文字 DropDownList2.DataTextField = "CityName"; //绑定下拉框value值 DropDownList2.DataValueField = "CityID"; DropDownList2.DataBind(); DropDownList2.Items.Insert(0, new ListItem("请选择城市", "0")); // 改变省份清除区县 DropDownList3.Items.Clear(); DropDownList3.Items.Insert(0, new ListItem("请选择地区", "0")); }
protected void Button1_Click(object sender, EventArgs e) { string worker_mobile = TextBox1.Text; // string worker_password = TextBox2.Text; string worker_password = TextBox2.Text; DataSet ds = OperaterBase.GetData("select * from Staff_Table where worker_mobile='" + worker_mobile + "' and worker_password='******'"); if (ds.Tables[0].Rows.Count > 0) { bool CheckBoxResult = CheckBox1.Checked; if (CheckBoxResult) { CookieHelper.SetCookie("worker_mobile", ds.Tables[0].Rows[0]["worker_mobile"].ToString(), DateTime.Now.AddMinutes(10)); CookieHelper.SetCookie("worker_password", ds.Tables[0].Rows[0]["worker_password"].ToString(), DateTime.Now.AddMinutes(10)); CookieHelper.SetCookie("remember_password", CheckBox2.Checked.ToString(), DateTime.Now.AddMinutes(10)); CookieHelper.SetCookie("auto_login", CheckBox2.Checked.ToString(), DateTime.Now.AddMinutes(10)); CookieHelper.SetCookie("Id", ds.Tables[0].Rows[0]["Id"].ToString(), DateTime.Now.AddMinutes(10)); } else { Session["worker_mobile"] = ds.Tables[0].Rows[0]["worker_mobile"]; Session["worker_password"] = ds.Tables[0].Rows[0]["worker_password"]; } // 必须是管理员 if (ds.Tables[0].Rows[0]["worker_num"].ToString() == "admin") { Response.Redirect("manage_staff.aspx?staffId=1"); } else { Response.Redirect("order_list.aspx?staffId=" + ds.Tables[0].Rows[0]["Id"]); } } }
/// <summary> /// 锁定员工姓名 /// </summary> private void GetStaffDetail() { // 获取传递过来的员工id string staffId = Request["staffId"]; if (!string.IsNullOrEmpty(staffId)) { DataSet ds = OperaterBase.GetData("select * from Staff_Table where is_delete=0 and Id=" + staffId); // 如果查询到数据,给员工姓名textBox赋值,并向隐藏控件赋值id if (ds.Tables[0].Rows.Count > 0) { TextBox4.Text = ds.Tables[0].Rows[0]["worker_name"].ToString(); HiddenField1.Value = ds.Tables[0].Rows[0]["Id"].ToString(); } // 查不到跳转到登录页面 else { Response.Redirect("manage_staff_login.aspx"); } } }
/// <summary> /// 根据指定条件获取员工数据 /// </summary> private void GetStaffData(string sql) { DataSet ds = OperaterBase.GetData(sql); List <DeviceModel> deviceList = new List <DeviceModel>(); foreach (DataRow dataRow in ds.Tables[0].Rows) { DeviceModel deviceModel = new DeviceModel(); foreach (DataColumn dataColumn in ds.Tables[0].Columns) { switch (dataColumn.ColumnName) { case "worker_num": deviceModel.worker_num = dataRow["worker_name"].ToString(); break; case "worker_name": deviceModel.worker_name = dataRow["worker_name"].ToString(); break; case "worker_avatar": deviceModel.worker_avatar = dataRow["worker_avatar"].ToString(); break; case "worker_sex": deviceModel.worker_sex = dataRow["worker_sex"].ToString(); break; case "worker_age": deviceModel.worker_age = dataRow["worker_age"].ToString(); break; case "worker_mobile": deviceModel.worker_mobile = dataRow["worker_mobile"].ToString(); break; case "worker_password": deviceModel.worker_password = dataRow["worker_password"].ToString(); break; case "s_province": deviceModel.s_province = dataRow["s_province"].ToString(); break; case "s_city": deviceModel.s_city = dataRow["s_city"].ToString(); break; case "s_district": deviceModel.s_district = dataRow["s_district"].ToString(); break; case "Id": deviceModel.Id = dataRow["Id"].ToString(); break; } } deviceList.Add(deviceModel); } Repeater1.DataSource = deviceList; Repeater1.DataBind(); }