private void button1_Click(object sender, EventArgs e)
{
TMSDataHeader header = this.cboGroup.EditValue as TMSDataHeader;
if (header == null)
{
return;
}
if (MsgBox.AskOK("确定要取消吗?") == DialogResult.No)
{
return;
}
if (!DelleteGp(header))
{
MsgBox.Warn("删除失败，请重新操作！");
}
RequestPackage request = new RequestPackage("jscanshu.php");
request.Method = EHttpMethod.Get.ToString();
request.Params.Add("id", header.id);
ResponsePackage response = _httpContext.Request(request);
if (response.Result == EResponseResult.成功)
{
MsgBox.Warn("取消成功");
LoadData();
this.gridHeader.DataSource = null;
}
else
{
MsgBox.Warn("取消失败，请检查网络！");
}
}
public static string GetVHtype(TMSDataHeader header)
{
string sql = string.Format("SELECT wbc.ITEM_DESC FROM tms_data_header tdh " +
"JOIN wm_base_code wbc ON tdh.VH_TYPE =wbc.ITEM_VALUE AND wbc.GROUP_CODE =131 " +
"WHERE tdh.GROUP_NO ='{0}'", header.id);
IMapper map = DatabaseInstance.Instance();
return(map.ExecuteScalar <string>(sql));
}
/// <summary>
/// 新增分组
/// </summary>
/// <param name="header">分组对象</param>
/// <returns>新增结果</returns>
public static int Insert(TMSDataHeader header)
{
string sql = @"INSERT INTO TMS_DATA_HEADER(GROUP_NO, VH_TYPE, WH_CODE, CREATE_DATE, START_TIME,
ATTRI_1, ATTRI_2, ATTRI_3, ATTRI_4, ATTRI_5) VALUES(@GroupNo, @VhType, @WhCode, NOW(),@StartTime, @Attri1,
@Attri2, @Attri3, @Attri4, @Attri5)";
IMapper map = DatabaseInstance.Instance();
//IDbTransaction trans = map.BeginTransaction();
int result = -1;
try
{
result = map.Execute(sql, new
{
GroupNo = header.id,
VhType = header.car_type,
WhCode = header.storehouse,
StartTime = header.start_time,
Attri1 = header.Attri1,
Attri2 = header.Attri2,
Attri3 = header.Attri3,
Attri4 = header.Attri4,
Attri5 = header.Attri5
});
if (result > 0)
{
foreach (string marketKey in header.order_list.Keys)
{
TMSDataMarket market = header.order_list[marketKey];
market.marketid = marketKey;
market.GroupNo = header.id;
result += InsertMarket(market);
}
}
//trans.Commit();
}
catch
{
result = -1;
//trans.Rollback();
}
return(result);
}
/// <summary>
/// 选择组别后显示该组别的所有订单信息
/// </summary>
private void cboGroup_EditValueChanged(object sender, EventArgs e)
{
try
{
TMSDataHeader header = this.cboGroup.EditValue as TMSDataHeader;
if (header == null)
{
return;
}
this.gridHeader.DataSource = Details(header.id);
lblVHtype.Text = GetVHtype(header);
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
}
/// <summary>
/// 得到车辆类型
/// </summary>
/// <param name="header"></param>
/// <returns></returns>
public string GetVHtype(TMSDataHeader header)
{
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("groupNo=").Append(header.id);
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_GetVHtype);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(null);
}
#endregion
#region 正常错误处理
JsonGetVHtype bill = JsonConvert.DeserializeObject <JsonGetVHtype>(jsonQuery);
if (bill == null)
{
//MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(null);
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return(null);
}
#endregion
if (bill.result != null && bill.result.Length > 0)
{
return(bill.result[0].billTypeName);
}
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(null);
}
/// <summary>
/// 根据派单id 32位（组别）删除数据
/// </summary>
/// <param name="tmsDataHeader"></param>
/// <returns></returns>
public bool DelleteGp(TMSDataHeader tmsDataHeader)
{
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("groupNo=").Append(tmsDataHeader.id);
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_DelleteGp);
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 btnCreateTask_Click(object sender, EventArgs e)
{
try
{
TMSDataHeader header = this.cboGroup.EditValue as TMSDataHeader;
if (header == null)
{
MsgBox.Warn("请选择组别！");
return;
}
if (listPersonnel.CheckedItems.Count < 1)
{
MsgBox.Warn("请选择装车人员！");
return;
}
if (listTransPersonal.CheckedItems.Count < 1)
{
MsgBox.Warn("请选称重人员！");
return;
}
VehicleEntity vehicle = this.searchLookUpEdit1.EditValue as VehicleEntity;
if (vehicle == null)
{
MsgBox.Warn("请选择车辆！");
return;
}
List <SOHeaderEntity> soHeaderList = this.gridHeader.DataSource as List <SOHeaderEntity>;
if (soHeaderList == null || soHeaderList.Count == 0)
{
MsgBox.Warn("当前组别未找到任何订单！");
return;
}
//装车人员
List <UserEntity> userLoadingList = new List <UserEntity>();
foreach (var obj in this.listPersonnel.CheckedItems)
{
if (obj is UserEntity)
{
UserEntity user = obj as UserEntity;
userLoadingList.Add(user);
}
}
//称重人员
List <UserEntity> userTransList = new List <UserEntity>();
foreach (var obj in this.listTransPersonal.CheckedItems)
{
if (obj is UserEntity)
{
UserEntity user = obj as UserEntity;
userTransList.Add(user);
}
}
LoadingHeaderEntity loadingHeader = new LoadingHeaderEntity()
{
WarehouseCode = GlobeSettings.LoginedUser.WarehouseCode,
LoadingNO = DateTime.Now.ToString("yyyyMMddHHmmssms"),
VehicleID = vehicle.ID,
UserName = GlobeSettings.LoginedUser.UserName,
UpdateDate = DateTime.Now
};
List <LoadingDetailEntity> details = new List <LoadingDetailEntity>();
foreach (SOHeaderEntity data in soHeaderList)
{
details.Add(new LoadingDetailEntity()
{
LoadingNO = loadingHeader.LoadingNO,
BillNO = data.BillNO,
InVehicleSort = ConvertUtil.ToInt(data.OrderSort),
UpdateDate = DateTime.Now,
BillID = data.BillID
});
}
List <LoadingUserEntity> users = new List <LoadingUserEntity>();
foreach (UserEntity item in userLoadingList)
{
users.Add(new LoadingUserEntity()
{
LoadingNO = loadingHeader.LoadingNO,
UserName = item.UserName,
UserCode = item.UserCode,
UpdateDate = DateTime.Now
});
}
//规定排序
TMSDataHeader tmsDataHeader = this.cboGroup.EditValue as TMSDataHeader;
if (tmsDataHeader == null)
{
return;
}
using (FrmLoadingSortMap frmSOSortMap = new FrmLoadingSortMap(this.SelectedBills, vehicle, userLoadingList, userTransList, tmsDataHeader.id))
{
if (frmSOSortMap.ShowDialog() == DialogResult.OK)
{
//生成叫号信息
foreach (UserEntity user in userLoadingList)
{
CreateCalling(BaseCodeConstant.TASK_LOADING, vehicle.VehicleNO, user.UserName, user.UserCode, -1);
}
// 修改TMS表头的本地状态
UpdateLocState(header.HeaderID, 1);
}
}
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MsgBox.Err("错误：" + ex.Message);
}
}
/// <summary>
/// 装车信息--分派装车-获取组别
/// </summary>
/// <param name="locState"></param> 本地状态：-1：所有；0：未装车；1：已装车
/// <returns></returns>
public List <TMSDataHeader> Select(int locState)
{
List <TMSDataHeader> list = new List <TMSDataHeader>();
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
loStr.Append("locState=").Append(locState);
string jsonQuery = WebWork.SendRequest(loStr.ToString(), WebWork.URL_Select);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(list);
}
#endregion
#region 正常错误处理
JsonSelect bill = JsonConvert.DeserializeObject <JsonSelect>(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 (JsonSelectResult jbr in bill.result)
{
TMSDataHeader asnEntity = new TMSDataHeader();
asnEntity.Attri1 = jbr.attri1;
asnEntity.Attri2 = jbr.attri2;
asnEntity.Attri3 = jbr.attri3;
asnEntity.Attri4 = jbr.attri4;
asnEntity.Attri5 = jbr.attri5;
asnEntity.car_type = jbr.type;
asnEntity.HeaderID = Convert.ToInt32(jbr.headerId);
asnEntity.id = jbr.groupNo;
asnEntity.LocalState = Convert.ToInt32(jbr.locState);
asnEntity.storehouse = jbr.code;
try
{
if (!string.IsNullOrEmpty(jbr.createDate))
{
asnEntity.CreateDate = Convert.ToDateTime(jbr.createDate);
}
}
catch (Exception msg)
{
MsgBox.Warn(msg.Message);
//LogHelper.errorLog("FrmVehicle+QueryNotRelatedBills", msg);
}
list.Add(asnEntity);
}
return(list);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(list);
}
