public void DeleteTest() { StoreHouse v = new StoreHouse(); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { v.WarehouseCode = "Jm78"; v.WarehouseAddress = "M9B"; v.ContractName = "TxlQdb31"; v.ContractPhone = "Vww3t"; context.Set <StoreHouse>().Add(v); context.SaveChanges(); } PartialViewResult rv = (PartialViewResult)_controller.Delete(v.ID.ToString()); Assert.IsInstanceOfType(rv.Model, typeof(StoreHouseVM)); StoreHouseVM vm = rv.Model as StoreHouseVM; v = new StoreHouse(); v.ID = vm.Entity.ID; vm.Entity = v; _controller.Delete(v.ID.ToString(), null); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { Assert.AreEqual(context.Set <StoreHouse>().Count(), 1); } }
public StoreHouse FindByGoodsFileId(string goodsFileId) { StoreHouse obj = new StoreHouse(); string sql = "select id,store, storemoney from zc_storehouse where branch_id = :branchId and goodsfile_id = :goodsFileId "; OracleConnection conn = null; OracleCommand cmd = new OracleCommand(); try { conn = OracleUtil.OpenConn(); cmd.Connection = conn; cmd.CommandText = sql; cmd.Parameters.Add(":branchId", ConstantUtil.BranchId); cmd.Parameters.Add(":goodsFileId", goodsFileId); OracleDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { obj.Id = reader.IsDBNull(0) ? string.Empty : reader.GetString(0); obj.Store = reader.IsDBNull(1) ? string.Empty : reader.GetString(1); obj.StoreMoney = reader.IsDBNull(2) ? string.Empty : reader.GetString(2); obj.GoodsFileId = goodsFileId; } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { cmd.Dispose(); OracleUtil.CloseConn(conn); } return(obj); }
protected void init() { object action = Request.QueryString["action"]; if (action != null) { if (action.ToString().Equals("edit")) { int ID = Int16.Parse(Request.QueryString["ID"].ToString()); StoreHouse s = new StoreHouse(); s = Leyp.SQLServerDAL.Factory.getStoreHouseDAL().getByHouseID(ID); SubareaName.Text = s.HouseName; Pageaction.Text = "edit"; editID.Text = ID.ToString(); Description.Text = s.Description; } else if (action.ToString().Equals("del")) { int ID = Int16.Parse(Request.QueryString["ID"].ToString()); if (!Leyp.SQLServerDAL.Factory.getStoreHouseDAL().deleteEitity(ID)) { Jscript.AjaxAlert(this, "删除失败!可能记录正在使用"); Response.Redirect("StoreHouseManager.aspx", true); } } } DataBand(); }
public async Task <ActionResult> Remove(StoreHouse model) { if (ModelState.IsValid) { try { StoreHouse current = db.StoreHouses.SingleOrDefault( p => p.StoreHouseId == model.StoreHouseId); if (current == null) { ModelState.AddModelError(string.Empty, "仓库不存在"); } else { current.IsDeleted = true; db.SaveChanges(); //Task.Run(() => //{ ResBusinessManager.Instance.ClearCache( ResBusinessManager.RESOURCES_STOREHOUSES); //}); } } catch (Exception e) { LogHelper.Error("StoreHousesController.Remove", e); ModelState.AddModelError(string.Empty, e.Message + "\t\t" + e.StackTrace); //ModelState.AddModelError(string.Empty, e); } } var allErrors = this.GetModelStateErrors(ModelState); return(Json(allErrors)); }
public void CreateTest() { PartialViewResult rv = (PartialViewResult)_controller.Create(); Assert.IsInstanceOfType(rv.Model, typeof(StoreHouseVM)); StoreHouseVM vm = rv.Model as StoreHouseVM; StoreHouse v = new StoreHouse(); v.WarehouseCode = "Jm78"; v.WarehouseAddress = "M9B"; v.ContractName = "TxlQdb31"; v.ContractPhone = "Vww3t"; vm.Entity = v; _controller.Create(vm); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { var data = context.Set <StoreHouse>().FirstOrDefault(); Assert.AreEqual(data.WarehouseCode, "Jm78"); Assert.AreEqual(data.WarehouseAddress, "M9B"); Assert.AreEqual(data.ContractName, "TxlQdb31"); Assert.AreEqual(data.ContractPhone, "Vww3t"); Assert.AreEqual(data.CreateBy, "user"); Assert.IsTrue(DateTime.Now.Subtract(data.CreateTime.Value).Seconds < 10); } }
public void BatchDeleteTest() { StoreHouse v1 = new StoreHouse(); StoreHouse v2 = new StoreHouse(); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { v1.WarehouseCode = "Jm78"; v1.WarehouseAddress = "M9B"; v1.ContractName = "TxlQdb31"; v1.ContractPhone = "Vww3t"; v2.WarehouseCode = "NgIudeNx"; v2.WarehouseAddress = "INq1"; v2.ContractName = "zE7Ho"; v2.ContractPhone = "6dCP"; context.Set <StoreHouse>().Add(v1); context.Set <StoreHouse>().Add(v2); context.SaveChanges(); } PartialViewResult rv = (PartialViewResult)_controller.BatchDelete(new string[] { v1.ID.ToString(), v2.ID.ToString() }); Assert.IsInstanceOfType(rv.Model, typeof(StoreHouseBatchVM)); StoreHouseBatchVM vm = rv.Model as StoreHouseBatchVM; vm.Ids = new string[] { v1.ID.ToString(), v2.ID.ToString() }; _controller.DoBatchDelete(vm, null); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { Assert.AreEqual(context.Set <StoreHouse>().Count(), 2); } }
public async Task <ActionResult> Add(StoreHouse model) { if (ModelState.IsValid) { try { db.StoreHouses.Add(model); db.SaveChanges(); //Task.Run(() => //{ ResBusinessManager.Instance.ClearCache( ResBusinessManager.RESOURCES_STOREHOUSES); //}); } catch (Exception e) { LogHelper.Error("StoreHousesController.Add", e); ModelState.AddModelError(string.Empty, e.Message + "\t\t" + e.StackTrace); //ModelState.AddModelError(string.Empty, e); } } var allErrors = this.GetModelStateErrors(ModelState); return(Json(allErrors)); }
public ActionResult DeleteConfirmed(int id) { StoreHouse storeHouse = db.StoreHouses.Find(id); db.StoreHouses.Remove(storeHouse); db.SaveChanges(); return(RedirectToAction("Index")); }
public static int StoreHouseInsert(StoreHouse s) { Database db = DatabaseFactory.CreateDatabase("Constr"); string sql = string.Format("insert into t_StoreHouse values('{0}','{1}')", s.HouseName, s.Description); int rows = db.ExecuteNonQuery(CommandType.Text, sql); return(rows); }
public static int StoreHouseUpdate(StoreHouse s) { Database db = DatabaseFactory.CreateDatabase("Constr"); string sql = string.Format("update t_StoreHouse set HouseName='{0}' , Description='{1}' where HouseID='{2}'", s.HouseName, s.Description, s.HouseID); int rows = db.ExecuteNonQuery(CommandType.Text, sql); return(rows); }
public bool insertEitity(StoreHouse s) { int rowsAffected = 0; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@HouseName", SqlDbType.NVarChar), new SqlParameter("@Description", SqlDbType.NVarChar) }; parameters[0].Value = s.HouseName; parameters[1].Value = s.Description; SQLHelper.RunProcedure("p_StoreHouse_insertNewStoreHouse", parameters, out rowsAffected); return(1 == rowsAffected); }
public void Update(StoreHouse entity) { var house = db.StoreHouse.FirstOrDefault(u => u.Id == entity.Id); house.MedicalBillId = entity.MedicalBillId; house.MedicalBills = entity.MedicalBills; house.ShelfLife = entity.ShelfLife; house.DateOfManufacture = entity.DateOfManufacture; db.SaveChanges(); }
public ActionResult Create([Bind(Include = "StoreHouseId,StoreHouseKey,StoreHouseName")] StoreHouse storeHouse) { if (ModelState.IsValid) { db.StoreHouses.Add(storeHouse); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(storeHouse)); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; if (context.Request["housename"] != null) { StoreHouse s = new StoreHouse(); s.HouseID = Convert.ToInt32(context.Request["houseid"]); s.HouseName = context.Request["housename"]; s.Description = context.Request["Description"]; context.Response.Write(StoreHouseManager.StoreHouseUpdate(s) > 0); } }
public static StoreHouse FromDTO(StoreHouseDTO storeHouse) { StoreHouse f = new StoreHouse { Id = storeHouse.Id, DateOfManufacture = storeHouse.DateOfManufacture, ShelfLife = storeHouse.ShelfLife, MedicalBills = FromDTO(storeHouse.MedicalBills) }; return(f); }
public ActionResult Edit(StoreHouse storeHouse) { using (CCV_Tables_Context db = new CCV_Tables_Context()) { if (ModelState.IsValid) { db.Entry(storeHouse).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View()); } }
/* * // POST: StoreHouses/Edit/5 * // 为了防止“过多发布”攻击,请启用要绑定到的特定属性,有关 * // 详细信息,请参阅 http://go.microsoft.com/fwlink/?LinkId=317598。 * [HttpPost] * [ValidateAntiForgeryToken] * public ActionResult Edit([Bind(Include = "StoreHouseId,StoreHouseKey,StoreHouseName")] StoreHouse storeHouse) * { * if (ModelState.IsValid) * { * db.Entry(storeHouse).State = EntityState.Modified; * db.SaveChanges(); * return RedirectToAction("Index"); * } * return View(storeHouse); * }*/ // GET: StoreHouses/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StoreHouse storeHouse = db.StoreHouses.Find(id); if (storeHouse == null) { return(HttpNotFound()); } return(View(storeHouse)); }
private Guid AddStoreHouse() { StoreHouse v = new StoreHouse(); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { v.WarehouseCode = "iZUW"; v.WarehouseAddress = "TmxY"; v.ContractName = "5RMRFbb"; v.ContractPhone = "UQeQFutWe"; context.Set <StoreHouse>().Add(v); context.SaveChanges(); } return(v.ID); }
private Guid AddStoreHouse() { StoreHouse v = new StoreHouse(); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { v.WarehouseCode = "eumrkUhk"; v.WarehouseAddress = "1lcQ"; v.ContractName = "paWDf6YK"; v.ContractPhone = "2CFrNFzy"; context.Set <StoreHouse>().Add(v); context.SaveChanges(); } return(v.ID); }
private Guid AddStoreHouse() { StoreHouse v = new StoreHouse(); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { v.WarehouseCode = "OUrZ1YPS"; v.WarehouseAddress = "pX8nakz"; v.ContractName = "lnxG7n9p"; v.ContractPhone = "37qxovgA"; context.Set <StoreHouse>().Add(v); context.SaveChanges(); } return(v.ID); }
//库房 public static List <StoreHouse> GetStore() { string sqlstr = string.Format("select * from t_StoreHouse"); DataTable dt = DBHelper.GetDataTable(sqlstr); List <StoreHouse> list = new List <StoreHouse>(); foreach (DataRow item in dt.Rows) { StoreHouse st = new StoreHouse(); st.HouseName = item["HouseName"].ToString(); st.HouseID = Convert.ToInt32(item["HouseID"].ToString()); list.Add(st); } return(list); }
public void EditTest() { StoreHouse v = new StoreHouse(); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { v.WarehouseCode = "Jm78"; v.WarehouseAddress = "M9B"; v.ContractName = "TxlQdb31"; v.ContractPhone = "Vww3t"; context.Set <StoreHouse>().Add(v); context.SaveChanges(); } PartialViewResult rv = (PartialViewResult)_controller.Edit(v.ID.ToString()); Assert.IsInstanceOfType(rv.Model, typeof(StoreHouseVM)); StoreHouseVM vm = rv.Model as StoreHouseVM; v = new StoreHouse(); v.ID = vm.Entity.ID; v.WarehouseCode = "NgIudeNx"; v.WarehouseAddress = "INq1"; v.ContractName = "zE7Ho"; v.ContractPhone = "6dCP"; vm.Entity = v; vm.FC = new Dictionary <string, object>(); vm.FC.Add("Entity.WarehouseCode", ""); vm.FC.Add("Entity.WarehouseAddress", ""); vm.FC.Add("Entity.ContractName", ""); vm.FC.Add("Entity.ContractPhone", ""); _controller.Edit(vm); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { var data = context.Set <StoreHouse>().FirstOrDefault(); Assert.AreEqual(data.WarehouseCode, "NgIudeNx"); Assert.AreEqual(data.WarehouseAddress, "INq1"); Assert.AreEqual(data.ContractName, "zE7Ho"); Assert.AreEqual(data.ContractPhone, "6dCP"); Assert.AreEqual(data.UpdateBy, "user"); Assert.IsTrue(DateTime.Now.Subtract(data.UpdateTime.Value).Seconds < 10); } }
public StoreHouse getByHouseID(int HouseID) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@HouseID", SqlDbType.Int) }; parameters[0].Value = HouseID; StoreHouse house = new StoreHouse(); SqlDataReader reader = SQLHelper.RunProcedure("p_StoreHouse_getByHouseID", parameters); if (reader.Read()) { house.HouseID = reader.GetInt32(reader.GetOrdinal("HouseID")); house.Description = reader.GetString(reader.GetOrdinal("Description")); house.HouseName = reader.GetString(reader.GetOrdinal("HouseName")); } reader.Close(); return(house); }
public List <StoreHouse> getAllStoreHouse() { List <StoreHouse> list = new List <StoreHouse>(); SqlDataReader reader = SQLHelper.RunProcedure("p_StoreHouse_getAll", null); while (reader.Read()) { StoreHouse item = new StoreHouse(); item.HouseID = reader.GetInt32(reader.GetOrdinal("HouseID")); item.Description = reader.GetString(reader.GetOrdinal("Description")); item.HouseName = reader.GetString(reader.GetOrdinal("HouseName")); list.Add(item); } reader.Close(); return(list); }
public static List <StoreHouse> StoreHouseID(int id) { Database db = DatabaseFactory.CreateDatabase("Constr"); string sql = string.Format("select * from t_StoreHouse where HouseID='{0}'", id); DataSet ds = db.ExecuteDataSet(CommandType.Text, sql); List <StoreHouse> ll = new List <StoreHouse>(); foreach (DataRow item in ds.Tables[0].Rows) { StoreHouse sh = new StoreHouse(); sh.HouseName = item["HouseName"].ToString(); sh.Description = item["Description"].ToString(); ll.Add(sh); } return(ll); }
public ActionResult Import(HttpPostedFileBase upload) { if (ModelState.IsValid) { if (upload != null && upload.ContentLength > 0) { if (upload.FileName.EndsWith(".csv")) { Stream stream = upload.InputStream; DataTable csvTable = new DataTable(); using (CsvReader csvReader = new CsvReader(new StreamReader(stream), true)) { csvTable.Load(csvReader); } using (CCV_Tables_Context db = new CCV_Tables_Context()) { string[] words; for (int i = 0; i < csvTable.Rows.Count; i++) { csvTable.Rows[i].ItemArray[0].ToString(); words = csvTable.Rows[i].ItemArray[0].ToString().Split(';'); StoreHouse storeHouse = new StoreHouse(); storeHouse.StoreHouseName = words[0]; StringToEnum myIntToEnum = new StringToEnum(); storeHouse.storeHouseType = myIntToEnum.GetStoreHouseTypeFromString(words[1]); storeHouse.StoreHouseActiv = Boolean.Parse(words[2]); db.StoreHouses.Add(storeHouse); db.SaveChanges(); } } return(View(csvTable)); } else { ModelState.AddModelError("File", "This file format is not supported"); return(View()); } } else { ModelState.AddModelError("File", "Please Upload Your file"); } } return(View()); }
public static List <StoreHouse> StoreHouseALL(int index, int rows) { Database db = DatabaseFactory.CreateDatabase("Constr"); string sql = string.Format("select top {0} * from t_StoreHouse where HouseID not in(select top {1} HouseID from t_StoreHouse)", index, index * (rows - 1)); DataSet ds = db.ExecuteDataSet(CommandType.Text, sql); List <StoreHouse> ll = new List <StoreHouse>(); foreach (DataRow item in ds.Tables[0].Rows) { StoreHouse sh = new StoreHouse(); sh.HouseID = Convert.ToInt32(item["HouseID"].ToString()); sh.HouseName = item["HouseName"].ToString(); sh.Description = item["Description"].ToString(); ll.Add(sh); } return(ll); }
public void DetailsTest() { StoreHouse v = new StoreHouse(); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { v.WarehouseCode = "Jm78"; v.WarehouseAddress = "M9B"; v.ContractName = "TxlQdb31"; v.ContractPhone = "Vww3t"; context.Set <StoreHouse>().Add(v); context.SaveChanges(); } PartialViewResult rv = (PartialViewResult)_controller.Details(v.ID.ToString()); Assert.IsInstanceOfType(rv.Model, typeof(IBaseCRUDVM <TopBasePoco>)); Assert.AreEqual(v.ID, (rv.Model as IBaseCRUDVM <TopBasePoco>).Entity.GetID()); }
public ActionResult Edit(int?id) { using (CCV_Tables_Context db = new CCV_Tables_Context()) { Session["StoreHouseName"] = db.StoreHouses.Where(c => c.StoreHouseId == id).Single().StoreHouseName; if (id == null) { return(new HttpStatusCodeResult(BadRequest)); } StoreHouse account = db.StoreHouses.Find(id); if (User == null) { return(HttpNotFound()); } return(View(db.StoreHouses.SingleOrDefault(c => c.StoreHouseId == id))); } }
public IHttpActionResult RegistrationMaterialIntoStoreHouse(StoreHouse storeHouse) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { db.StoreHouses.Add(storeHouse); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = storeHouse.StoreHouseId }, storeHouse)); } catch (Exception ee) { return(BadRequest(ModelState)); } }