public void Delete(int WarehouseRequestID)
{
WarehouseRequest _request = QueryByID(WarehouseRequestID);
_request.Enabled = false;
_context.SaveChanges();
}
public void ChangeStatus(int WarehouseRequestID, int State)
{
WarehouseRequest _request = QueryByID(WarehouseRequestID);
_request.State = State;
_context.SaveChanges();
}
//
// GET: /Audit/Warehouse/
public ActionResult Index(WarehouseRequest request)
{
var result = this.AuditService.GetWarehouseList(request);
ViewBag.AuditStateOption = "0";
if (request.AuditState == "未审核")
{
ViewBag.AuditStateOption = "1";
}
else if (request.AuditState == "初审通过")
{
ViewBag.AuditStateOption = "2";
}
else if (request.AuditState == "初审不通过")
{
ViewBag.AuditStateOption = "3";
}
else if (request.AuditState == "终审通过")
{
ViewBag.AuditStateOption = "4";
}
else if (request.AuditState == "终审不通过")
{
ViewBag.AuditStateOption = "5";
}
return(View(result));
}
/// <summary>
/// 添加或修改仓库信息
/// </summary>
/// <returns></returns>
public ActionResult WarehouseEdit(WarehouseRequest request)
{
var Warehouse = WarehouseFunc.Instance.SelectById(request.Id);
if (Warehouse != null)
{
ViewBag.WarehouseFullInfo = Warehouse;
}
return(View());
}
public void DoWork()
{
_warehouseRequest = new WarehouseRequest
{
WarehouseName = "Barnsley",
CountryName = "UK"
};
var warehouse = ParseEntry();
}
public WHRequestGridRowModel(WarehouseRequest Request, string UserName, string ApprovalUser)
{
cell = new string[7];
cell[0] = Request.WarehouseRequestID.ToString();
cell[1] = Request.RequestNumber;
cell[2] = UserName;
cell[3] = Request.CreateDate.ToString("yyyy-MM-dd HH:mm");
cell[4] = ApprovalUser;
cell[5] = Toolkits.CheckZero(Request.ApprovalDate)?"-": Request.ApprovalDate.ToString("yyyy-MM-dd HH:mm");
cell[6] = Enum.GetName(typeof(WarehouseRequestStatus), Request.State);
}
public void Remove()
{
// Web Service of the Entity to be used
Sync.WMS.WMSDataImportWS.WarehouseRequest wsEntity = new WarehouseRequest();
//Required Fields
wsEntity.ERPCompany = "DEMOWMS510";
wsEntity.WarehouseCode = "A100";
//Saving
object result;
result = m_WSClient.DeleteWarehouse(wsEntity);
}
public ResultJson DeleteWarehouse(WarehouseRequest request)
{
if (WarehouseFunc.Instance.DeleteListWarehouse(request.Ids))
{
return(new ResultJson {
HttpCode = 200, Message = "删除成功！"
});
}
else
{
return(new ResultJson {
HttpCode = 300, Message = "删除失败！"
});
}
}
public void Change()
{
// Web Service of the Entity to be used
Sync.WMS.WMSDataImportWS.WarehouseRequest wsEntity = new WarehouseRequest();
//Required Fields
wsEntity.ERPCompany = "DEMOWMS510";
wsEntity.OldWarehouseCode = "A100";
wsEntity.WarehouseCode = "A100";
wsEntity.WarehouseName = "Nova Descrição";
//Saving
object result;
result = m_WSClient.SaveWarehouse(wsEntity);
}
public async Task <IActionResult> Post(WarehouseRequest request)
{
try
{
Warehouse warehouse = _mapper.Map(request);
warehouse = await _repository.AddAsync(warehouse);
return(CreatedAtAction(nameof(GetById), new { id = warehouse.Id }, _mapper.Map(warehouse)));
}
catch (DataStoreException e)
{
_logger.LogError(e.Message, e, request);
return(StatusCode(StatusCodes.Status500InternalServerError, e.Message));
}
}
public int Save(WarehouseRequest WarehouseRequest)
{
WarehouseRequest _dbEntry = QueryByID(WarehouseRequest.WarehouseRequestID);
if (_dbEntry == null)
{
_context.WarehouseRequests.Add(WarehouseRequest);
}
else
{
_dbEntry.WarehouseUserID = WarehouseRequest.WarehouseUserID;
_dbEntry.ApprovalUserID = WarehouseRequest.ApprovalUserID;
_dbEntry.ApprovalDate = WarehouseRequest.ApprovalDate;
_dbEntry.WarehouseDate = WarehouseRequest.WarehouseDate;
_dbEntry.State = WarehouseRequest.State;
_dbEntry.Enabled = WarehouseRequest.Enabled;
}
_context.SaveChanges();
return(WarehouseRequest.WarehouseRequestID);
}
public IActionResult Add(WarehouseRequest oModel)
{
Respuesta oRespuesta = new Respuesta();
try
{
using (ERPContext db = new ERPContext())
{
Warehouse oWarehouse = new Warehouse();
oWarehouse.Category = oModel.Category;
db.Warehouses.Add(oWarehouse);
db.SaveChanges();
oRespuesta.Exito = 1;
}
}
catch (Exception ex)
{
oRespuesta.Mensaje = ex.Message;
}
return(Ok(oRespuesta));
}
public ResultJson EditWarehouseInfo(WarehouseRequest request)
{
var result = "";
#region 添加
if (request.Id == 0)
{
result = WarehouseFunc.Instance.InsertWarehouse(new DbOpertion.Models.Warehouse
{
Name = request.Name,
IsDelete = true
});
}
#endregion
#region 修改
else
{
result = WarehouseFunc.Instance.UpdateWarehouse(new DbOpertion.Models.Warehouse
{
Id = request.Id,
Name = request.Name
});
}
#endregion
if (result == "成功")
{
return(new ResultJson {
HttpCode = 200, Message = result
});
}
else
{
return(new ResultJson {
HttpCode = 300, Message = "失败!"
});
}
}
public IActionResult Edit(WarehouseRequest oModel)
{
Respuesta oRespuesta = new Respuesta();
try
{
using (ERPContext db = new ERPContext())
{
Warehouse oWarehouse = db.Warehouses.Find(oModel.Id);
oWarehouse.Category = oModel.Category;
db.Entry(oWarehouse).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
oRespuesta.Exito = 1;
}
}
catch (Exception ex)
{
oRespuesta.Mensaje = ex.Message;
}
return(Ok(oRespuesta));
}
public async Task <IHttpActionResult> PostAsync([FromBody] WarehouseRequest request)
{
try
{
var data = _mapper.Map <Warehouse>(request);
var response = await _warehouseService.AddWarehouse(data);
if (response.IsValid == false)
{
return(Ok(new ApiBadRequestResponse(400, response.Errors)));
}
var result = _mapper.Map <WarehouseResponse>(response.Object);
return(Ok(new ApiOkResponse(result, 1)));
}
catch (Exception ex)
{
//Log here
return(BadRequest());
}
}
//搜索功能
public IEnumerable <Warehouse> GetWarehouseList(WarehouseRequest request = null)
{
request = request ?? new WarehouseRequest();
using (var dbContext = new AuditDbContext())
{
IQueryable <Warehouse> Warehouses = dbContext.Warehouses;
if (request != null)
{
if (!string.IsNullOrEmpty(request.buyoff))
{
Warehouses = Warehouses.Where(u => u.buyoff.Contains(request.buyoff));
}
if (!string.IsNullOrEmpty(request.Owner))
{
Warehouses = Warehouses.Where(u => u.Owner.Contains(request.Owner));
}
if (!string.IsNullOrEmpty(request.AuditState) && request.AuditState != "全部")
{
Warehouses = Warehouses.Where(u => u.AuditState == request.AuditState);
}
}
return(Warehouses.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize));
}
}
public async Task <IActionResult> Put(Guid id, WarehouseRequest request)
{
try
{
Warehouse warehouse = await _repository.GetByIdAsync(id);
if (warehouse == null)
{
return(NotFound());
}
_mapper.Map(warehouse, request);
await _repository.UpdateAsync(warehouse);
return(Ok());
}
catch (DataStoreException e)
{
_logger.LogError(e.Message, e, request);
return(StatusCode(StatusCodes.Status500InternalServerError, e.Message));
}
}
public WarehouseResponse Warehouse(IUnitOfWork uow, WarehouseRequest request)
{
request.CheckNotNull();
var response = new WarehouseResponse();
response.ErrorList = new List <string>();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
var user = (UserDefinition)Authorization.UserDefinition;
int tn = user.TenantId;
List <MyRow> Items = new List <MyRow>();
SqlDataAdapter adapter = new SqlDataAdapter();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Store"].ToString()))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("usp_MakeStore", conn))
{
try
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Tenant", SqlDbType.Int).Value = tn;
//conn.Open();
cmd.ExecuteNonQuery();
}
catch (SqlException sqlException)
{
response.ErrorList.Add("Exception: " + sqlException.Message);
}
}
adapter = DAL.StoreAdapter(conn, tn);
adapter.Fill(dt);
adapter.DeleteCommand.ExecuteNonQuery();
foreach (DataRow row in dt.Rows)
{
MyRow obj = row.ToObject <MyRow>();
Items.Add(obj);
}
Average(Items);
dt = DAL.ConvertTo(Items);
adapter.Update(dt);
adapter.Dispose();
using (SqlCommand cmd = new SqlCommand("usp_PriceUpdate", conn))
{
try
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Tenant", SqlDbType.Int).Value = tn;
//conn.Open();
cmd.ExecuteNonQuery();
}
catch (SqlException sqlException)
{
response.ErrorList.Add("Exception: " + sqlException.Message);
}
}
conn.Close();
}
return(response);
}
