private bool Save()
{
if (!IsFieldValueValid())
{
return(false);
}
try
{
RecLocationEntity entity = PrepareSave();
bool isCreateNew = (this.recLocationEntity == null);
//int result = recLocationDal.Save(entity, isCreateNew);
//if (result == -1)
//{
// MsgBox.Warn("编号已经存在，请改为其他的编号。");
// return false;
//}
if (SaveUpdate(entity, isCreateNew))
{
if (DataSourceChanged != null)
{
DataSourceChanged(null, null);
}
return(true);
}
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
return(false);
}
return(false);
}
public int Save(RecLocationEntity entity, bool IsCreateNew)
{
IMapper map = DatabaseInstance.Instance();
int ret = -1;
if (entity.RecLoc == "")
{
ret = map.Execute("Insert into wm_sku_location (LC_CODE,SKU_CODE) values(@lcCode,@skuCode)",
new
{
lcCode = entity.Location,
skuCode = entity.SkuCode
});
}
else
{
ret = map.Execute("Update wm_sku_location set SKU_CODE=@skuCode where LC_CODE=@lcCode",
new
{
skuCode = entity.SkuCode,
lcCode = entity.Location
});
}
return(ret);
}
/// <summary>
/// 基础管理（推荐货位-查询所有推荐货位）
/// </summary>
/// <returns></returns>
public List <RecLocationEntity> GetAllRecLocation()
{
List <RecLocationEntity> list = new List <RecLocationEntity>();
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
//loStr.Append("roleId=").Append(roleId);
string jsonQuery = WebWork.SendRequest(string.Empty, WebWork.URL_GetAllRecLocation);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(list);
}
#endregion
#region 正常错误处理
JsonGetAllRecLocation bill = JsonConvert.DeserializeObject <JsonGetAllRecLocation>(jsonQuery);
if (bill == null)
{
MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(list);
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return(list);
}
#endregion
#region 赋值数据
foreach (JsonGetAllRecLocationResult jbr in bill.result)
{
RecLocationEntity asnEntity = new RecLocationEntity();
asnEntity.Location = jbr.lcCode;
asnEntity.RecLoc = jbr.recLoc;
asnEntity.SkuCode = jbr.skuCode;
asnEntity.SkuName = jbr.skuName;
asnEntity.Spec = jbr.spec;
asnEntity.ZnName = jbr.znName;
list.Add(asnEntity);
}
return(list);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(list);
}
private void ShowEditLocation()
{
RecLocationEntity editEntity = SelectedLocationRow;
if (editEntity == null)
{
MsgBox.Warn("没有要修改的数据。");
return;
}
FrmRecLocationEdit frmRecLocationEdit = new FrmRecLocationEdit(editEntity);
frmRecLocationEdit.DataSourceChanged += OnEditChanage;
frmRecLocationEdit.ShowDialog();
}
/// <summary>
/// 基础管理（推荐货位-添加或编辑库存货位）
/// </summary>
/// <param name="entity"></param>
/// <param name="IsCreateNew"></param>
/// <returns></returns>
public bool SaveUpdate(RecLocationEntity entity, bool IsCreateNew)
{
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("lcCode=").Append(entity.Location).Append("&");
loStr.Append("skuCode=").Append(entity.SkuCode).Append("&");
loStr.Append("recLoc=").Append(entity.RecLoc);
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_Save);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(false);
}
#endregion
#region 正常错误处理
Sucess bill = JsonConvert.DeserializeObject <Sucess>(jsonQuery);
if (bill == null)
{
MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(false);
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return(false);
}
#endregion
return(true);
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(false);
}
public void Delete()
{
RecLocationEntity removeEntity = SelectedLocationRow;
if (removeEntity == null)
{
MsgBox.Warn("没有要清空的数据。");
return;
}
if (MsgBox.AskOK(string.Format("确定要清空货位\" {0} \"的推荐商品\" {1} \"吗？", removeEntity.RecLoc, removeEntity.SkuName)) == DialogResult.OK)
{
bool ret = DeleteRecLoc(removeEntity.RecLoc);
if (ret)
{
removeEntity.SkuName = "";
removeEntity.SkuCode = "";
removeEntity.Spec = "";
bindingSource1.ResetBindings(false);
}
}
}
public RecLocationEntity PrepareSave()
{
RecLocationEntity editEntity = this.recLocationEntity;
if (editEntity == null)
{
editEntity = new RecLocationEntity();
}
MaterialEntity entity = listSku.Properties.View.GetFocusedRow() as MaterialEntity;
if (entity == null)
{
return(null);
}
editEntity.SkuCode = entity.MaterialCode;
editEntity.SkuName = entity.MaterialName;
editEntity.Spec = entity.Spec;
return(editEntity);
}
public FrmRecLocationEdit(RecLocationEntity entity)
: this()
{
this.recLocationEntity = entity;
}
private void ShowEditInfo(RecLocationEntity entity)
{
//txtCode.Text = grpEntity.GrpCode;
listSku.EditValue = entity.SkuCode;
txtlocCode.Text = entity.Location;
}