/// <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); }