/// <summary>
/// 添加或编辑分类
/// </summary>
/// <param name="entity"></param>
/// <param name="isNew">添加或编辑</param>
/// <returns></returns>
public int Save(MaterialTypeEntity entity, bool isNew)
{
IMapper map = DatabaseInstance.Instance();
int ret = -2;
if (isNew)
{
//检查编号是否已经存在
if (IsCodeExists(entity))
{
return(-1);
}
ret = map.Execute("INSERT INTO WM_SKU_TYPE(TYP_CODE, TYP_NAME, ZN_CODE) VALUES(@COD, @NAM, @ZN_CODE)",
new
{
COD = entity.MaterialTypeCode,
NAM = entity.MaterialTypeName,
ZN_CODE = entity.ZoneCode
});
}
else
{
//更新
ret = map.Execute("UPDATE WM_SKU_TYPE SET TYP_NAME = @NAM, ZN_CODE = @ZN_CODE WHERE TYP_CODE = @COD",
new
{
COD = entity.MaterialTypeCode,
NAM = entity.MaterialTypeName,
ZN_CODE = entity.ZoneCode
});
}
return(ret);
}
private void OnCreateChanage(object sender, EventArgs e)
{
MaterialTypeEntity newEntity = (MaterialTypeEntity)sender;
bindingSource1.Add(newEntity);
bindingSource1.ResetBindings(false);
}
/// <summary>
/// 检查主分类编码是否已存在
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
private bool IsCodeExists(MaterialTypeEntity type)
{
IMapper map = DatabaseInstance.Instance();
string id = map.ExecuteScalar <string>("SELECT TYP_CODE FROM WM_SKU_TYPE WHERE TYP_CODE = @COD",
new { COD = type.MaterialTypeCode });
return(!string.IsNullOrEmpty(id));
}
public void AddMaterialType(MaterialType materialType)
{
var entity = new MaterialTypeEntity {
MaterialTypeId = materialType.MaterialTypeId, MaterialTypeName = materialType.MaterialTypeName
};
_materialTypeRepo.Add(entity);
_materialTypeRepo.Save();
}
///<summary>
///查询所有分类
///</summary>
///<returns></returns>
public List <MaterialTypeEntity> GetMaterialTypeAll()
{
List <MaterialTypeEntity> list = new List <MaterialTypeEntity>();
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
//loStr.Append("roleId=").Append(roleId);
string jsonQuery = WebWork.SendRequest(string.Empty, WebWork.URL_GetMaterialTypeAll);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(list);
}
#endregion
#region 正常错误处理
JsonGetMaterialTypeAll bill = JsonConvert.DeserializeObject <JsonGetMaterialTypeAll>(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 (JsonGetMaterialTypeAllResult jbr in bill.result)
{
MaterialTypeEntity asnEntity = new MaterialTypeEntity();
#region 11-14
asnEntity.MaterialTypeCode = jbr.typCode;
asnEntity.MaterialTypeName = jbr.typName;
asnEntity.ZoneCode = jbr.znCode;
asnEntity.ZoneName = jbr.znName;
#endregion
list.Add(asnEntity);
}
return(list);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(list);
}
/// <summary>
/// 编辑
/// </summary>
private void ShowEdit()
{
MaterialTypeEntity editEntity = SelectedHeaderRow;
if (editEntity == null)
{
MsgBox.Warn("没有要修改的数据。");
return;
}
FrmMaterialTypeEdit frmEdit = new FrmMaterialTypeEdit(editEntity);
frmEdit.DataSourceChanged += OnEditChanage;
frmEdit.ShowDialog();
}
public MaterialTypeEntity PrepareSave()
{
MaterialTypeEntity editEntity = mtlTypeEntity;
if (editEntity == null)
{
editEntity = new MaterialTypeEntity();
}
editEntity.MaterialTypeCode = txtCode.Text.Trim();
editEntity.MaterialTypeName = txtName.Text.Trim();
editEntity.ZoneCode = ConvertUtil.ToString(listZones.EditValue);
editEntity.ZoneName = listZones.Text;
return(editEntity);
}
private bool Save()
{
if (!IsFieldValueValid())
{
return(false);
}
bool success = false;
try
{
MaterialTypeEntity editEntity = PrepareSave();
//int ret = mtlTypeDal.Save(editEntity, isNew);
//if (ret == -1)
// MsgBox.Warn("分类编号已存在，请改为其他的编号。");
//else if (ret == -2)
// MsgBox.Warn("更新失败，该行已经被其他人删除。");
//else
bool ret;
if (isNew)
{
ret = SaveAddSkuType(editEntity, isNew);
}
else
{
ret = SaveUpdateSkuType(editEntity, isNew);
}
if (ret)
{
success = true;
if (DataSourceChanged != null)
{
DataSourceChanged(editEntity, null);
}
}
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(success);
}
/// <summary>
/// 添加或编辑分类
/// </summary>
/// <param name="entity"></param>
/// <param name="isNew">添加或编辑</param>
/// <returns></returns>
public bool SaveUpdateSkuType(MaterialTypeEntity entity, bool isNew)
{
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("typCode=").Append(entity.MaterialTypeCode).Append("&");
loStr.Append("typName=").Append(entity.MaterialTypeName).Append("&");
loStr.Append("znCode=").Append(entity.ZoneCode);
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_SaveUpdateSkuType);
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);
}
/// <summary>
/// 删除
/// </summary>
private void DoDelete()
{
MaterialTypeEntity removeEntity = SelectedHeaderRow;
if (removeEntity == null)
{
MsgBox.Warn("没有要删除的数据。");
return;
}
if (MsgBox.AskOK(string.Format("确定要删除分类{0}({1})吗？", removeEntity.MaterialTypeCode, removeEntity.MaterialTypeName)) == DialogResult.OK)
{
bool ret = DeleteSkuType(removeEntity.MaterialTypeCode);
if (ret)
{
bindingSource1.Remove(removeEntity);
}
//else
// MsgBox.Warn("删除失败，可能已经被其他人删除。");
}
}
public FrmMaterialTypeEdit(MaterialTypeEntity mtlTypeEntity)
: this()
{
this.mtlTypeEntity = mtlTypeEntity;
}
private void ShowEditInfo(MaterialTypeEntity mtlTypeEntity)
{
txtCode.Text = mtlTypeEntity.MaterialTypeCode;
txtName.Text = mtlTypeEntity.MaterialTypeName;
listZones.EditValue = mtlTypeEntity.ZoneCode;
}
