public static List <string> getStoreroomList() { Storeroom storeroom = new Storeroom(); List <string> flist = new List <string>(); MySqlDataReader rdr = null; try { string tableName = "storeroom"; string query = "SELECT * FROM " + tableName; MySqlCommand cmd = new MySqlCommand(query, MysqlDbc.Instance.getConn()); rdr = cmd.ExecuteReader(); while (rdr.Read()) { storeroom.Description = rdr.GetString("description"); flist.Add(storeroom.Description); } } catch (MySqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } finally { if (rdr != null) { rdr.Close(); } } return(flist); }
public IActionResult Create(StoreroomEditViewModel model) { if (ModelState.IsValid) { var storeroom = new Storeroom() { Name = model.Name }; Storeroom storeroomCreated = _storeroomData.Add(storeroom); return(RedirectToAction(nameof(Details), new { id = storeroomCreated.Id })); } else { return(View()); } }
//新加的按照用户编号查询的接口2020-04-07 static public Storeroom QueryByUserNum(string userNum) { string command = $"select storeID from [User] where num = '{userNum}'"; SqlDataReader read = SQL.getData(command); if (read == null) { SQL.Dispose(); return(null); } if ((int)read["storeID"] == -1) { SQL.Dispose(); return(null); } Storeroom storeroom = new Storeroom((int)read["storeID"], null, null, null); SQL.Dispose(); return(storeroom); }
public void addStock() { Storeroom store = new Storeroom(); store.Description = descriptionText.Text; store.StoringQty = Convert.ToInt32(storeNumericUpDown.Value); store.Temperature = Int32.Parse(tempText.Text); bool avail = false; int availability = availabilityBox.SelectedIndex; if (availability == 1) { avail = true; } store.Availability = avail; InsertSQL storeHnd = new InsertSQL(); int addrecord = storeHnd.addNewStore(store); MessageBox.Show(addrecord + " Your record is added"); }
public static bool Login(string username, string password, out string msg) { password = GenerateMD5(password); Dictionary <string, string> dictionary = UserDAL.QueryByUserName(username, password, out msg); if (dictionary == null) { return(false); } if (dictionary["authority"].Substring(4).Contains("1")) { Storeroom storeroom = StoreroomDAL.QueryByUserNum(dictionary["num"]); if (storeroom != null) { dictionary.Add("storeID", storeroom.id.ToString()); } } HttpContext.Current.Session["user"] = dictionary; return(true); }
static public bool Add(Storeroom storeroom, out string msg) { string command = $"insert into Storeroom(name,site) values('{storeroom.name}','{storeroom.site}');"; try { msg = null; return(SQL.Excute(command)); } catch (SqlException e) { if (e.Number == 2627) { msg = "请检查仓库名称是否重复或库管员是否已经绑定仓库"; } else { msg = e.Message; } return(false); } }
static public bool Update(Storeroom storeroom, out string msg) { string command = $"update Storeroom set name = '{storeroom.name}',site = '{storeroom.site}' where id = '{storeroom.id}'"; try { msg = null; return(SQL.Excute(command)); } catch (SqlException e) { if (e.Number == 2627) { msg = "请检查仓库名称是否重复或库管员是否已经绑定仓库"; } else { msg = e.Message; } return(false); } }
public Storeroom GetStoreroomFromID(int itemId) { Storeroom ss1 = new Storeroom(); MySqlDataReader rdr = null; try { string tableName = "storeroom"; string query = "SELECT * FROM " + tableName + " WHERE id = " + itemId; MySqlCommand cmd = new MySqlCommand(query, MysqlDbc.Instance.getConn()); rdr = cmd.ExecuteReader(); while (rdr.Read()) { ss1.Id = itemId; ss1.Description = rdr.GetString("description"); ss1.StoringQty = rdr.GetInt32("storingQty"); ss1.Temperature = rdr.GetInt32("temperature"); ss1.Availability = rdr.GetBoolean("availability"); } } catch (MySqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } finally { if (rdr != null) { rdr.Close(); } } return(ss1); }
public Storeroom Add(Storeroom storeroom) { _context.Storerooms.Add(storeroom); _context.SaveChanges(); return(storeroom); }
static public bool Add(Storeroom storeroom, out string msg) { return(StoreroomDAL.Add(storeroom, out msg)); }
static public bool Update(Storeroom storeroom, out string msg) { return(StoreroomDAL.Update(storeroom, out msg)); }
public Storeroom Add(Storeroom storeroom) { storeroom.Id = _storerooms.Max(s => s.Id) + 1; _storerooms.Add(storeroom); return(storeroom); }