/// <summary>
/// 检查送货牌编码是否已存在
/// </summary>
/// <param name="unit"></param>
/// <returns></returns>
private bool IsCodeExists(DriverCardEntity cardState)
{
IMapper map = DatabaseInstance.Instance();
string id = map.ExecuteScalar <string>("SELECT CARD_NO FROM WM_CARD_STATE WHERE CARD_NO = @COD", new { COD = cardState.CardNO });
return(!string.IsNullOrEmpty(id));
}
/// <summary>
/// 添加或编辑送货牌
/// </summary>
/// <param name="entity"></param>
/// <param name="isNew">添加或编辑</param>
/// <returns></returns>
public int Save(DriverCardEntity cardState, bool isNew)
{
IMapper map = DatabaseInstance.Instance();
int ret = -2;
if (isNew)
{
//检查编号是否已经存在
if (IsCodeExists(cardState))
{
return(-1);
}
ret = map.Execute("INSERT INTO WM_CARD_STATE(CARD_NO, CARD_STATE) VALUES(@CARD_NO, @CARD_STATE)",
new
{
CARD_NO = cardState.CardNO,
CARD_STATE = cardState.CardState
});
}
else
{
//更新
ret = map.Execute("UPDATE WM_CARD_STATE SET CARD_NO = @CARD_NO WHERE CARD_NO = @CARD_NO",
new
{
CARD_NO = cardState.CardNO
});
}
return(ret);
}
private bool Save()
{
if (!IsFieldValueValid())
{
return(false);
}
bool success = false;
try
{
DriverCardEntity editEntity = PrepareSave();
//int ret = cardStateDal.Save(editEntity, isNew);
//if (ret == -1)
// MsgBox.Warn("送货牌编号已存在，请改为其他的送货牌编号。");
//else if (ret == -2)
// MsgBox.Warn("更新失败，该行已经被其他人删除。");
//else
if (SaveAddCardState(editEntity, isNew))
{
success = true;
if (DataSourceChanged != null)
{
DataSourceChanged(editEntity, null);
}
}
}
catch (Exception ex)
{
MsgBox.Warn(ex.Message);
}
return(success);
}
private void OnCreateChanage(object sender, EventArgs e)
{
DriverCardEntity newEntity = (DriverCardEntity)sender;
bindingSource1.Add(newEntity);
bindingSource1.ResetBindings(false);
}
///<summary>
///查询所有送货牌
///</summary>
///<returns></returns>
public List <DriverCardEntity> GetAllCardState()
{
List <DriverCardEntity> list = new List <DriverCardEntity>();
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
//loStr.Append("whCode=").Append(warehouseCode).Append("&");
//loStr.Append("state=").Append(state);
string jsonQuery = WebWork.SendRequest(string.Empty, WebWork.URL_GetAllCardState);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(list);
}
#endregion
#region 正常错误处理
JsonGetAllCardState bill = JsonConvert.DeserializeObject <JsonGetAllCardState>(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 (JsonGetAllCardStateResult jbr in bill.result)
{
DriverCardEntity asnEntity = new DriverCardEntity();
#region
asnEntity.CardNO = jbr.cardNo;
asnEntity.CardState = jbr.cardState;
asnEntity.HeaderID = Convert.ToInt32(jbr.headerId);
#endregion
list.Add(asnEntity);
}
return(list);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(list);
}
public DriverCardEntity PrepareSave()
{
DriverCardEntity editEntity = cardStateEntity;
if (editEntity == null)
{
editEntity = new DriverCardEntity();
editEntity.CardState = BaseCodeConstant.CARD_STATE_KONG_XIAN;
}
editEntity.CardNO = txtCode.Text.Trim();
return(editEntity);
}
/// <summary>
/// 添加或编辑送货牌
/// </summary>
/// <param name="entity"></param>
/// <param name="isNew">添加或编辑</param>
/// <returns></returns>
public bool SaveAddCardState(DriverCardEntity cardState, bool isNew)
{
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("cardNo=").Append(cardState.CardNO).Append("&");
loStr.Append("cardState=").Append(cardState.CardState);
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_SaveAddCardState);
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);
}
private void ShowEditInfo(DriverCardEntity cardStateEntity)
{
txtCode.Text = cardStateEntity.CardNO;
}
public FrmDriverCardEdit(DriverCardEntity cardStateEntity)
: this()
{
this.cardStateEntity = cardStateEntity;
}
