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));
}
}
