/// <summary>
/// 编辑状态下的数据保存
/// </summary>
/// <returns></returns>
public override bool SaveUpdated()
{
WareHouseInfo info = BLLFactory <WareHouse> .Instance.FindById(Id);
if (info != null)
{
SetInfo(info);
try
{
bool succeed = BLLFactory <WareHouse> .Instance.Update(info, info.Id);
if (succeed)
{
return(true);
}
}
catch (Exception ex)
{
LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmEditWareHouse));
MessageDxUtil.ShowError(ex.Message);
}
}
return(false);
}
private void SetInfo(WareHouseInfo info)
{
info.Name = txtName.Text;
info.Address = txtAddress.Text;
info.UserId = txtManager.Text.ToInt32();
info.MobilePhone = txtPhone.Text;
info.Remark = txtNote.Text;
}
private void SetInfo(WareHouseInfo info)
{
info.Name = txtName.Text;
info.Address = txtAddress.Text;
info.Manager = txtManager.Text;
info.Phone = txtPhone.Text;
info.Note = txtNote.Text;
}
public ActionResult Add(WareHouseInfo model)
{
model.CreatedAt = model.UpdatedAt = DateTime.Now;
model.IsDeleted = false;
if (ModelState.IsValid)
{
db.WareHouseInfoes.Add(model);
db.SaveChanges();
return(Content(javasctipt_add("/WareHouseInfo", "Thêm dữ liệu thành công")));
}
var status = StatusUtils.GetSettingStatus();
ViewBag.IsActive = new SelectList(status, "Value", "Text", model.IsActive);
return(Content(javasctipt_add("/WareHouseInfo", "Thêm dữ liệu thất bại")));
}
public int UpdateWareHouse(WareHouseInfo wareHouse, SqlTransaction trans)
{
string sql = @"UPDATE [WareHouse]
SET [id] = @id
,[Name] = @Name
,[No] = @No
,[Address] = @Address
,[Tel] = @Tel
,[detail] = @detail
,[InsertDateTime] = @InsertDateTime
,[InsertUser] = @InsertUser
WHERE id=@id";
SqlParameter[] spvalues = DBTool.GetSqlPm(wareHouse);
return(SqlHelper.ExecuteNonQuery(trans, System.Data.CommandType.Text, sql, spvalues));
}
public override void DisplayData()
{
if (Id > 0)
{
WareHouseInfo info = BLLFactory <WareHouse> .Instance.FindById(Id);
if (info != null)
{
txtName.Text = info.Name;
txtAddress.Text = info.Address;
txtNote.Text = info.Remark;
txtManager.Text = info.UserId.ToString();
txtManager.Tag = info.UserId;
txtPhone.Text = info.MobilePhone;
}
}
}
// GET: WareHouseInfo/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
WareHouseInfo model = db.WareHouseInfoes.Find(id);
if (model == null)
{
return(HttpNotFound());
}
var status = StatusUtils.GetSettingStatus();
ViewBag.IsActive = new SelectList(status, "Value", "Text", model.IsActive);
return(View(model));
}
public override void DisplayData()
{
if (!string.IsNullOrEmpty(ID))
{
WareHouseInfo info = BLLFactory <WareHouse> .Instance.FindByID(ID);
if (info != null)
{
txtName.Text = info.Name;
txtAddress.Text = info.Address;
txtNote.Text = info.Note;
txtManager.Text = info.Manager;
txtManager.Tag = info.Manager;
txtPhone.Text = info.Phone;
}
}
}
/// <summary>
/// 保存仓库
/// </summary>
/// <returns></returns>
public WareHouseUpdateResponse SaveWareHouse(WareHouseUpdateRequest request)
{
WareHouseUpdateResponse response = new WareHouseUpdateResponse();
WareHouseInfo ware = new WareHouseInfo()
{
WareHouseId = request.WareHouseId,
WareHouseName = request.WareHouseName,
WareHouseAddress = request.WareHouseAddress,
WareHouseCapacity = request.WareHouseCapacity,
WareHouseRemark = request.WareHouseRemark,
WareHouseStatus = request.WareHouseStatus
};
//获取名不能为空
if (request == null || string.IsNullOrEmpty(request.WareHouseName))
{
response.Status = false;
response.Message = "仓库名称不能为空";
return(response);
}
if (string.IsNullOrEmpty(request.WareHouseAddress))
{
response.Status = false;
response.Message = "仓库地址不能为空";
return(response);
}
var res = wdal.SaveWareHouse(ware);
if (res > 0)
{
response.IsRegistSuccess = true;
response.Message = "修改成功";
}
else
{
response.Status = false;
response.Message = "修改失败";
return(response);
}
return(response);
}
public bool UploadMaterialaInfo(IEnumerable <GoodsInput> goodsInputs, string userId, string msg)
{
//遍历
foreach (var item in goodsInputs)
{
//输入信息表
InputInfo inputInfo = new InputInfo
{
InstanceId = item.InstanceId,
CategoryId = item.CategoryId,
InputUser = userId,
Name = item.Name,
Num = item.Num,
Unit = item.Unit,
AddTime = DateTime.Now
};
_dbContext.Set <InputInfo>().Add(inputInfo);
//仓库信息表
string instanceId = "W" + item.InstanceId.Substring(3);
WareHouseInfo goods = new WareHouseInfo
{
InstanceId = instanceId,
CategoryId = item.CategoryId,
Name = item.Name,
Num = item.Num,
Unit = item.Unit,
IsPress = false,
DelFlag = false,
AddTime = DateTime.Now
};
_dbContext.Set <WareHouseInfo>().Add(goods);
//上传的同时要把相应的订单改为已完成
}
if (_dbContext.SaveChanges() > 0)
{
msg = "导入成功！";
return(true);
}
msg = "失败！内部错误！";
return(false);
}
/// <summary>
/// 添加仓库
/// </summary>
/// <returns></returns>
public WareHouseAddResponse AddWareHouse(WareHouseAddRequest request)
{
WareHouseAddResponse response = new WareHouseAddResponse();
if (request == null || string.IsNullOrEmpty(request.WareHouseName))
{
response.Status = false;
response.Message = "仓库名不能为空";
return(response);
}
if (request == null || string.IsNullOrEmpty(request.WareHouseAddress))
{
response.Status = false;
response.Message = "仓库地址不能为空";
return(response);
}
WareHouseInfo ware = new WareHouseInfo()
{
WareHouseName = request.WareHouseName,
WareHouseCapacity = request.WareHouseCapacity,
WareHouseAddress = request.WareHouseAddress,
WareHouseStatus = request.WareHouseStatus,
WareHouseRemark = request.WareHouseRemark
};
var res = wdal.AddWareHouse(ware);
if (res > 0)
{
response.IsRegistSuccess = true;
response.Message = "添加仓库成功";
}
else
{
response.Status = false;
response.Message = "添加仓库失败";
}
return(response);
}
public int InsertWareHouse(WareHouseInfo wareHouse, SqlTransaction trans)
{
string sql = @"INSERT INTO [WareHouse]
([Name]
,[No]
,[Address]
,[Tel]
,[detail]
,[InsertDateTime]
,[InsertUser])
VALUES
(@Name
,@No
,@Address
,@Tel
,@detail
,@InsertDateTime
,@InsertUser)";
SqlParameter[] spvalues = DBTool.GetSqlPm(wareHouse);
return(SqlHelper.ExecuteNonQuery(trans, System.Data.CommandType.Text, sql, spvalues));
}
public ActionResult Edit(WareHouseInfo model)
{
model.UpdatedAt = DateTime.Now;
model.IsDeleted = false;
if (ModelState.IsValid)
{
try
{
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
return(Content(javasctipt_add("/WareHouseInfo", "Cập nhật dữ liệu thành công")));
}
catch (Exception)
{
return(Content(javasctipt_add("/WareHouseInfo", "Có lỗi xảy ra, vui lòng kiểm tra lại dữ liệu")));
}
}
var status = StatusUtils.GetSettingStatus();
ViewBag.IsActive = new SelectList(status, "Value", "Text", model.IsActive);
return(Content(javasctipt_add("/WareHouseInfo", "Cập nhật dữ liệu thất bại")));
}
public int InsertWareHouse(WareHouseInfo wareHouse)
{
SqlConnection conn;
int count = 0;
using (conn = SqlHelper.CreateConntion())
{
conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
count = DAL.InsertWareHouse(wareHouse, trans);
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
}
conn.Close();
}
return(count);
}
/// <summary>
/// 新增状态下的数据保存
/// </summary>
/// <returns></returns>
public override bool SaveAddNew()
{
WareHouseInfo info = new WareHouseInfo();
SetInfo(info);
try
{
bool succeed = BLLFactory <WareHouse> .Instance.Insert(info);
if (succeed)
{
return(true);
}
}
catch (Exception ex)
{
LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmEditWareHouse));
MessageDxUtil.ShowError(ex.Message);
}
return(false);
}
private void FrmEditWareHouse_Load(object sender, EventArgs e)
{
//this.btnOK.Enabled = HasFunction("BasicInfo/Manufacture");
if (!string.IsNullOrEmpty(ID))
{
this.Text = "编辑 " + this.Text;
WareHouseInfo info = BLLFactory <WareHouse> .Instance.FindByID(ID);
if (info != null)
{
txtName.Text = info.Name;
txtAddress.Text = info.Address;
txtNote.Text = info.Note;
txtManager.Text = info.Manager;
txtManager.Tag = info.Manager;
txtPhone.Text = info.Phone;
}
this.btnOK.Enabled = HasFunction("WareHouse");
}
else
{
this.Text = "新建 " + this.Text;
}
}
/// <summary>
/// 添加仓库
/// </summary>
/// <returns></returns>
public int AddWareHouse(WareHouseInfo info)
{
string sql = $"insert into WareHouse values('{info.WareHouseName}',{info.WareHouseCapacity},'{info.WareHouseAddress}',{info.WareHouseStatus},'{info.WareHouseRemark}',GETDATE(),GETDATE(),1,1,1)";
return(DBHelper.ExecuteNonQuery(sql));
}
/// <summary>
/// 保存仓库
/// </summary>
/// <returns></returns>
public int SaveWareHouse(WareHouseInfo info)
{
string sql = $"update WareHouse set WareHouseName='{info.WareHouseName}',WareHouseCapacity='{info.WareHouseCapacity}',WareHouseAddress='{info.WareHouseAddress}',WareHouseStatus='{info.WareHouseStatus}',WareHouseRemark= '{info.WareHouseRemark}',UpdateTime=GETDATE()where WareHouseId='{info.WareHouseId}'";
return(DBHelper.ExecuteNonQuery(sql));
}
private void btnOK_Click(object sender, EventArgs e)
{
if (this.txtName.Text.Trim().Length == 0)
{
MessageDxUtil.ShowTips("库房名称不能为空");
this.txtName.Focus();
return;
}
if (this.txtManager.Text.Trim().Length == 0)
{
MessageDxUtil.ShowTips("库房负责人不能为空");
this.txtManager.Focus();
return;
}
if (!string.IsNullOrEmpty(ID))
{
WareHouseInfo info = BLLFactory <WareHouse> .Instance.FindByID(ID);
if (info != null)
{
SetInfo(info);
try
{
bool succeed = BLLFactory <WareHouse> .Instance.Update(info, info.ID.ToString());
if (succeed)
{
MessageDxUtil.ShowTips("保存成功");
this.DialogResult = DialogResult.OK;
}
}
catch (Exception ex)
{
LogTextHelper.Error(ex);
MessageDxUtil.ShowError(ex.Message);
}
}
}
else
{
WareHouseInfo info = new WareHouseInfo();
SetInfo(info);
try
{
bool succeed = BLLFactory <WareHouse> .Instance.Insert(info);
if (succeed)
{
MessageDxUtil.ShowTips("保存成功");
this.DialogResult = DialogResult.OK;
}
}
catch (Exception ex)
{
LogTextHelper.Error(ex);
MessageDxUtil.ShowError(ex.Message);
}
}
}
