/// <summary>
/// 保存栈板信息
/// </summary>
/// <param name="pallet"></param>
/// <returns></returns>
public bool savePallet(Pallet pallet)
{
bool mark = true;
pallet.Uuid = Auxiliary.Get_UUID();
pallet.Createtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
pallet.Opuser = Auxiliary.loginName;
foreach (Carton carton in pallet.CartonList)
{
CartonRelPallet cartonRelPallet = new CartonRelPallet();
cartonRelPallet.CartonNo = carton.CartonNo;
cartonRelPallet.PalletNo = pallet.PalletNo;
mark = savePalletRelation(cartonRelPallet);
if (!mark)
{
return(mark);
}
mark = cartonService.updateCartonStatus(carton, 1);
if (!mark)
{
return(mark);
}
}
return(palletDao.savePallet(pallet));
}
/// <summary>
/// 保存栈板和装箱单关系
/// </summary>
/// <param name="cartonRelPallet"></param>
/// <returns></returns>
public bool savePalletRelation(CartonRelPallet cartonRelPallet)
{
cartonRelPallet.Uuid = Auxiliary.Get_UUID();
cartonRelPallet.Createtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
cartonRelPallet.Opuser = Auxiliary.loginName;
return(palletDao.savePalletRelation(cartonRelPallet));
}
/// <summary>
/// 保存装箱单与栈板关系
/// </summary>
/// <param name="cartonRelPallet"></param>
/// <returns></returns>
public bool savePalletRelation(CartonRelPallet cartonRelPallet)
{
bool saveMark = true;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_carton_pallet (uuid,cartonNo,palletNo,op_user,create_time)");
strSql.Append("values(@uuid,@cartonNo,@palletNo,@opuser,@createtime)");
MySqlParameter[] parameters =
{
new MySqlParameter("@uuid", MySqlDbType.VarChar, 900),
new MySqlParameter("@cartonNo", MySqlDbType.VarChar, 900),
new MySqlParameter("@palletNo", MySqlDbType.VarChar, 900),
new MySqlParameter("@opuser", MySqlDbType.VarChar, 900),
new MySqlParameter("@createtime", MySqlDbType.VarChar, 900)
};
parameters[0].Value = cartonRelPallet.Uuid;
parameters[1].Value = cartonRelPallet.CartonNo;
parameters[2].Value = cartonRelPallet.PalletNo;
parameters[3].Value = cartonRelPallet.Opuser;
parameters[4].Value = cartonRelPallet.Createtime;
int rows = SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
saveMark = true;
}
else
{
saveMark = false;
}
return(saveMark);
}
